HOW CAN I CREATE ARRAY IN SQL 6.5
I am a visual foxpro programmer
I want to create array in SQL 6.5 to perform some tasks.
# Visual coding
Local lnArrayLength , lni
laDbf = "a"
laDbf = "b"
lnArrayLength = alen(laDbf)
for lni = 1 to lnArrayLength
use in (laDbf[lni])
Now in SQL 6.5
I have create a lot of view
i just want to create an array , and than i assign all the view-name
in the array
than loop all the elements in array and test if the view is exists ,
drop the view.
if exists (select * from sysobjects where name = "view")
drop view "view"
since the if command is same to all the view
i want to create array and use a loop to loop until the end of array.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL