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?