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