Hello,

Thanks so much for all your help. For some reason I'm really struggling getting this parameterized query thing to work with the datasets. The tableadapter wizard now returns "unspecified error" when I use the 'Select * from user where userid=?' syntax. But even with the wizard error at least the main select clause works although it doesn't write out the insert, update, or delete statements. I suppose those will have to be coded by hand.


Greg

>>>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 #1160494
>Cetin