🚀 go-pugleaf

Srinivas,

check the "DataExpress/ParameterizedQuery" sample, it shows how 
to do that.

As I already told you on the Borland chat I believe that the 
source of you problems is your use of the ODBCJDBC bridge. It 
is notorious for having problems with advanced JDBC features 
like an updateable resultset.

You are trying to change colB, so that it contains the values 
of colA "+ x", right? You want that for all records of your db, 
right?
I still believe that a single UPDATE will do the trick, 
something like: "UPDATE table SET colB = colA + x"
That would affect all rows. You can also apply a WHERE if you 
want. 
Using one simple UPDATE will guarantee the best performance
possible. You told me that ~900.000 rows will be affected, 
right?

BTW - is there a DBA available? It should be his job to inform 
you about the best SQL statement for the task at hand and the 
given database.

Torsten

"Srinivas Lanka" <srinivas_lanka@horizon-bcbsnj.com> wrote:
>
>Hello!
>  How do I pass parameters to a QueryDataSet?
>I have the SQL query as 
>   select * from TABLE_A where TABLE_A.COL_1 = ?
>Can someone please let me know the steps to achieve this.
>
>Thanks
>