>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--