Subject | FB & VFP6 How to store empty date |
---|---|
Author | Namit Nathwani |
Post date | 2004-09-07T09:38:56Z |
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).
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06/09/2004
[Non-text portions of this message have been removed]
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).
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06/09/2004
[Non-text portions of this message have been removed]