Subject IBOUpdateSQL UPDATE problem
Author Julian Maisano
Hello all...

When this code is executed, no error is raised, but the update action do not
change anything in the DB table.

Note that IDALUMNO there is not a table's primary key. Can this be the
problem?

Is there any wrong word in the sql statement? (i don't think so bcause an
exeption should be raised i guess)



vsSQL :=

'UPDATE Alumnos SET
IDALUMNO="x",APELLIDO_ALU="x",NOMBRE_ALU="x"
WHERE Alumnos.IDALUMNO="x";'


DBO_DataModule.IB_Transaction.StartTransaction;

DBO_DataModule.IBOUpdateSQLPersona.ModifySQL.Text := vsSQL;
DBO_DataModule.IBOUpdateSQLPersona.ExecSQL(ukModify);

DBO_DataModule.IB_Transaction.Commit;



TIA
---------------------------------------------------
JULIAN MAISANO ® / ® 1976
La Plata - Argentina
----------------------------------------------------