Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough Cursor
Message
 
 
To
25/06/2002 22:12:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00672289
Message ID:
00672292
Views:
9
>Hi, I created a cursor using SQL PassThrough.
>
>csql = [Select * from Foxdb!calls]
>sqlexec(connHandle, csql, 'Mycur')
>
>calls.dbf contains 3 fields
>caller, location, calldate
>
>Is it possible to alter this cursor so I may add additional fields?
>
>Thanks in advance....

No, ALTER command doesn't work on SPT cursors. However, you can modify your select statement to include additional fields. Something like
csql = [Select *, SPACE(16) AS charfield, 00000000.00 AS numbfield from Foxdb!calls]
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform