>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
Looks like you should add a ? before @sign, e.g.
Re: Returning Value from Oracle SP to VFP Thread #
620820 Message #
621528
If it's not broken, fix it until it is.
My Blog