Hi Naomi. Tahanks for replying.
This is a C# program , should I not be using SQL syntax ?
How using C# and OleDB, can I select out into a Temporary table
Regards,
Gerard
>>I have an Oledb link set up to a VFP table with a command like:
>>Select * from MyTable into #MyTemp1
>> but keep getting a syntx error when I run any command option (i.e. comm.EcecuteReader, comm.ExceuteScalar, comm.ExecuteNonQuery.
>>
>>If I take out the Into #MyTemp1 , workds fine.
>>
>>Tia
>>Gerard
>
>The syntax you're trying to use is SQL Server syntax, not VFP, so no wonder you're getting an error.
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