David SG
|
| Posted: 05/05/2002, 6:30 PM |
|
Hi
Anyone has any ideas as to why the following statement returns an error? It's being used in the AfterUpdate event. I don't think the field variables are to blame, since it doesn't work either if I replace them with literal values.
cn.Execute ("UPDATE Usuarios SET Pwd=" & ToSQL(fldPwd, "Text") & " WHERE IDCliente=" & fldIDCliente )
any help would be greatly appreciated, thx!!
|
|
|
 |
Nicole
|
| Posted: 05/07/2002, 1:41 AM |
|
David,
if "IDCliente" is primary key then use this code:
cn.Execute ("UPDATE Usuarios SET Pwd=" & ToSQL(fldPwd, "Text") & " WHERE IDCliente=" & ToSQL(pPKIDCliente, "Number"))
I.e. primary key value is stored in pPKprimary_key_name var
|
|
|
|
|
