开发者

How do you build a parameter query for Oracle with Visual Web Developer 2010?

开发者 https://www.devze.com 2023-02-28 09:38 出处:网络
I am using a dataset and have build my tableAdapter in VWD.In SQL Server you can use an @somevar to be the parameter.But what do you put in Oracle to make it look for a parameter so that I can later b

I am using a dataset and have build my tableAdapter in VWD. In SQL Server you can use an @somevar to be the parameter. But what do you put in Oracle to make it look for a parameter so that I can later bind it to a t开发者_运维知识库extbox? I tried ? but it did not work.


I believe Oracle PSQL expects parameters of a query to use a colon (":") instead of "@". So, try :somevar.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号