Hi
Even if 0.00 is displayed in browse, only null is sent to ODBC driver, from my experience
The "" default value for memo is ok, without a default value, a null is sent.
All these are regarding remote views, but I think that can be the same with CA

>Hi Dorin
>
>That might be the problem because I have used the NOT NULL constraint on all the fields in the FireBird Table but I have some VFP memo field with no data which I suppose might be interpreted as Null values. I was assuming that an empty string was not the same as a NULL value.
>
>Simon
>
>
>>Did you tried the same with remote views?
>>I remember that I've encoutered something like this with nulls appended as default values when columns defined in remote view didn't had default values and those columns had NOT NULL constraint in Firebird table. After setting default values for columns, everything was OK.
>>
>>
>>>Hi
>>>
>>>I have been testing several database server for use with the new CursorAdapter class.
>>>
>>>I was able to create my database and all the associated tables in Firebird 1.5. However when I append data into a cursor attahced to a cursoradapter object the data appears never to be saved in Firebird. I used the same procedure with PostgreSQL and everything worked fine. I simply create the cursoradapter object and execute the Cursorfill method. I get an empty cursor to which I append some data and issue a TableUpdate command. No errors are report when I check with Aerror() but the next time I create the cursoradapter I again get an empty table.
>>>
>>>Any ideas of what possible settings I may have missed?
>>>
>>>Thanks
>>>Simon