Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
BCD fields with default 0 |
Wed, Jun 30 2010 12:46 PM | Permanent Link |
Robert Kaplan | If I have a BCD field with a default of zero, should it allow changes to
null? ie if you are editing the field and press delete, it becomes null, not zero. Robert |
Wed, Jun 30 2010 1:47 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Robert
Defaults only apply on insert/append not on edit. What happens on edit depends on three things, the engine, the component you're using to edit, and how you return the data to the field after edit. On top of that there's the presentation level which generally can't present a null so chooses some other value (the worst is TDateTime - ie a float - which return zero which is sometime in 1899 I think). To find out if a field is really null test with field.IsNull. What I do is explicitly call .Clear for those fields I want to be null. Roy Lambert [Team Elevate] |
Thu, Jul 1 2010 5:35 AM | Permanent Link |
John Hay | > If I have a BCD field with a default of zero, should it allow changes to
> null? ie if you are editing the field and press delete, it becomes null, not > zero. Yes it should. If you want to prevent this then set Required to true for the field. John |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |