Subject Re: FB & VFP6 How to store empty date
Author Dorin Vasilescu
--- In, 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
> 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.