How would this work though in Dot Net and C# ??
I dooubt if Cursors are supported in Dot Net in the same way as VFP
I have used another selection (with the Sql driver) and no problem there so I am wondering maybe OleDb does not support Temprary Tbales ??
Regards,
Gerard
>>Hi Naomi.
>>This is not a VFP program..... its a c# app.
>>Regards,
>>Gerard
>
>
>I know, but if you're querying VFP table, then you need to use VFP syntax. It doesn't matter if you're using VFP or C#, the DB syntax should be the one used for the particular back-end. In case of VFP back-end, the correct syntax is SELECT * from myTable INTO cursor CursorName (or INTO TABLE TableName)
>
>
>>>If you're using VFP, then try
>>>
>>>select * from MyTable into cursor csrTemp
>>>
>>>How do you intend to use this temp table?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only