--- In firebird-support@yahoogroups.com, Namit Nathwani
<namitnathwani@h...> wrote:

> Hi all
>
> I am using FireBird as a backend for VFP6, via remote views. I have a
> couple of date fields in the table. When I try to save a record in the
> view I get the following error:
>
> Connectivity error: Dynamic SQL Error
> SQL error code = -303
> conversion error from string '"'
>
> This error goes away when I fill in the date fields. Anyway that FB

will

> accept blank dates (not NULL please I have had a tough time with it

in VFP).

>

You can either:
1. Set a default value for column in VFP remote view
2. Set a default value for column in database

I recommend you to have default values specified in RV for all columns
with NOT NULL constraints in database.