IDC and emty fields

Andras Tudos - Computronic, C3 ( (no email) )
Wed, 23 Jul 1997 12:50:50 +0200

Anyone has an idea how could I setup IDC files to accept empty form fields?

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
Budapest, Hungary