Subject | Avoiding Null value and having basic default values |
---|---|
Author | Namit Nathwani |
Post date | 2004-06-15T10:50:57Z |
Hi all
I am using FireBird as a backend for VFP using remote views. When I save a
record in my applications fields that are not modified get saved as Null
this creates problems at the time of reporting. Also say for eg. Double
Precision numbers show a 0.00 on the app. form but actually the users is
assuming that a zero is saved, but a Null is.
Please advise as to what I can do to avoid this behaviour?
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.703 / Virus Database: 459 - Release Date: 10/06/2004
[Non-text portions of this message have been removed]
I am using FireBird as a backend for VFP using remote views. When I save a
record in my applications fields that are not modified get saved as Null
this creates problems at the time of reporting. Also say for eg. Double
Precision numbers show a 0.00 on the app. form but actually the users is
assuming that a zero is saved, but a Null is.
Please advise as to what I can do to avoid this behaviour?
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.703 / Virus Database: 459 - Release Date: 10/06/2004
[Non-text portions of this message have been removed]