We are trying to insert blank fields rather than null values into a btrieve database. When we use an INSERT SQL statement and set the field = " " it still inserts a NULL value into the field. Any way to make the field blank rather than null? We have tried setting a variable = " " and then inserting the variable into the field and this didn't work either.

Another accounting application is using the btrieve application, and it is bombing on the NULL fields.

Thanks,
Doug