Subject | IBOUpdateSQL UPDATE problem |
---|---|
Author | Julian Maisano |
Post date | 2003-08-05T07:22:53Z |
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
----------------------------------------------------
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
----------------------------------------------------