I get this error when trying to update a form which contains empty fields:
[State=S1000][Error=-3702][Microsoft][ODBC Microsoft Access 7.0 Driver] Field
'xxx' can't be a zero-length string.
I try to use the following update.idc (generated by Frontpage 97):
Datasource: bvfelh
Template: sikerult.htx
SQLStatement: UPDATE DISTINCTROW Felhasznalok_Webre SET
+Felhasznalo_neve = '%Felhasznalo_neve%',
....
+Interface_kabel = '%Interface_kabel%' where ID=%ID%;
It works only if all the fields are filled with data.
-----------------------------------------------------
Andras Tudos
Computronic, C3 http://tech.c3.hu
Budapest, Hungary http://www.computronic.hu
-----------------------------------------------------