Originally posted by: SystemAdmin

[aldreas said:]

Hi all,

When I try to insert or update a table in a Oracle BD form de .dat file with the "DBUpdate" command I get the following Error:

Database error (state=21000 code=-8): Index out of range, near "myVar"

If I used the same files with an access BD, it works fine!!

I've tried to use a very simple update sql: "update tableName set fieldName='555'" and with the DBExecute command works but not with the DBUpdate.

Any ideas??

Thanks in advance

David
#DecisionOptimization
#OPLusingCPOptimizer

Originally posted by: SystemAdmin

[aldreas said:]

Respond myself

The "DBUpdate" command is a bit diferent for Oracle and for Access, its well explained in an old version of the documentation:

------------------
For ODBC, the insertion is made by the instruction:
DBupdate(db, "insert into Result (task, startTime, endTime)
values (?, ?, ?)")(resultSet);
For Oracle, the insertion is made by the instruction:
DBupdate(db, "insert into Result (task, startTime, endTime)
values (:1, :2, :3)")(resultSet);
------------------

The sintax has changed but the "?,?" and the ":1,:2" are the same


David


#DecisionOptimization
#OPLusingCPOptimizer