Using VS2005. I have created a dataset for our Oracle database and have created a TableAdapter within the dataset for one of the Oracle tables.
When I Add a Query, I want to create a SELECT statement with a parameter as such:
SELECT * FROM customer WHERE custno = @lccustno
However, when I get to the Finish page of the dialog, I get an error "Missing expression".
My question is, how do I define a parameter on a SELECT statement for an Oracle table? The '@' works on a Sql Server table but not on an Oracle table.
Thanks,
Jerry