>>Greetings,
>>
>>I'm trying to create a business object layer that is going to talk to my VFP tables through OLEDB. Everything went fine creating a 'fillAll' method that pulls all records. However now that I'm trying to do a parameterized select I've run into problems. The SQL statement is simple enough:
>>
>>
>>SELECT * from User where userid = @userid
>>
>>
>>I get back, "Error in Where clause near '@'. Unable to parse query text.
>>
>>Is there a different syntax I will need to use in order to create parameters for my query.
>>
>>Thanks in advance!
>>
>>Greg
>
>
>SELECT * from User where userid = ?
>
>You should then add add a parameter to parameters collecion. There you can use parameter name if you want (but VFP doesn't use that name - it cares about its positon).
>Cetin
For a sample check:
Re: C# 2005 updating VFP data Thread #
1160448 Message #
1160494Cetin