cannot be zero-length string

set up a series of pages with the data assist wizard.

the update page isn't working, gives a Field cannot be a zero-length string error on any fields left blank.

shouldn't this be suppressing that issue?

That depends on how you have your db setup. If you have the columns in this table set to NOT NULL then you will not be able to leave them blank when inserting or updating a record. If you would like to be able to have empty values for these columns you will need to alter your table and take away the NOT NULL attribute for these columns.

If this is not the case for you and you are not using NOT NULL columns then the issue may be somewhere else within the query or the code. If you can post back with a copy of your update I should be able to take a look to see what I can spot. Can you insert blank values on the insert page?

good, learned something on that one. my insert form is my own, suppresses blank fields, and to answer your question, yes could leave fields blank. never had a problem with inserting or updating, but bought your dataassist, figured i'd try it.

adjusting the database columns fixed the issue. thanks.

Glad to hear that you got it worked out and learned a little about the tool in the process. Let us know if you have any further questions or if you run into any problems.