Hi,
I have an Update that works in Database Desktop but not in Through ODBC. I keep getting "Operation must use an updatable Query". The tables are Paradox & Database Desktop version is V7
The SQL is relativly simple
update table1 set description = ( select description from table2 where table1.prodid = table2.prodid)
I have even added
where table1.prodid in ( select prodid from table2 )
I have found some notes saying that the fields must be indexed, this I tried but to no avail. ANY Suggestions???
What I realy wish to do is to schedule this update, but the database desktop has no scheduler capability. The utility I am using allows me to run most sql but is failing with this one. Another tool to permit me to schedule the above query would get me out of the problem. I am not a Delphi developer, hence my preference for a SQL solution.
Thanks in advance for any pointers.
I have an Update that works in Database Desktop but not in Through ODBC. I keep getting "Operation must use an updatable Query". The tables are Paradox & Database Desktop version is V7
The SQL is relativly simple
update table1 set description = ( select description from table2 where table1.prodid = table2.prodid)
I have even added
where table1.prodid in ( select prodid from table2 )
I have found some notes saying that the fields must be indexed, this I tried but to no avail. ANY Suggestions???
What I realy wish to do is to schedule this update, but the database desktop has no scheduler capability. The utility I am using allows me to run most sql but is failing with this one. Another tool to permit me to schedule the above query would get me out of the problem. I am not a Delphi developer, hence my preference for a SQL solution.
Thanks in advance for any pointers.
