I am using PSQL 10.30.017.0000 and RealBasic Real Studio 2011r4.3. I talk to PSQL via ODBC that installed itself along with PSQL.
We are working on a Btrieve database that had character screens, and our goal is to create new modern application that uses windows.
In one of the forms we have four date fields (along with many more fields), and those date fields can have values or not. User will update the form and change the dates as he/she sees it fit.
Now, when we send empty strings (ODBC supports only strings) containing no dates, btrieve complains that "0000-00-00" is not correct date,, also we think is suggesting us to use nullable values from realbasic side. Real Basic can't have string nulled.
As we understand it, Btrieve will accept null as a value for empty date and it will make it happy, however how can we set null values from our end if the language does not support???
Right now as a dirty solution we have a big SQL statement that is executed every time, however we have removed date fields. We handle those date fields separately to determine if there is anything in them. If they are empty than I execute separate SQL statement setting that field to null.
This means to update one form, we need to execute 5 sql command... 4 for dates and one with other data.
Any help on this matter is more then welcome.