Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'Dynamic' SQL
Message
From
23/01/2001 07:19:54
 
 
To
23/01/2001 07:11:42
Gad Hutt
Express Print
Herzliya, Israel
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00467190
Message ID:
00467194
Views:
12
You could use two cursors...
I.E.

Select ...
from..
where i=firstsomthing into cursor MyCursor

use dbf("MyCursor") again in 0 alias mycursor2

local i
...
Do while i>1

Select ...
from..
where i=somthing into cursor MyCursor
select mycursor
scatter memvar memo
select mycursor2
append blank
gather memvar memo
Enddo

select mycursor2

...

or something along those lines...
Hope that helps.
Previous
Reply
Map
View

Click here to load this message in the networking platform