hi,
I have a database ( e.g., base1) with two columns ( e.g., c1 and c2) and I want to get the record that satisfies some
conditions using the following sql statement.
base1.getValue("Select c2 From Tabel_name Where c1=@v1;");
v1 in this statement is a variable, its value varies, say . So I use @v1 as we used to do in the standard SQL. However
,it does not work. I would appreciate it if anyone could help me on this issue?
Thanks.
Pavel — 02.07.08
Hi Run,
You should use the code like the following:
base1.getValue("Select c2 From Tabel_name Where c1="+v1+";");
I hope it will help you.