This is purely VFPOLEDB thing. See SetResultSet : http://msdn.microsoft.com/en-us/library/56z41c1f(v=vs.80).aspx

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