>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.
This syntax is SQL Server. Simply put ? and that will work.