Article View: borland.public.vdbase.forms
Article #36Re: Re Filtering above - apologies
From: Romain Strieff [TeamB]
Date: Wed, 10 Mar 1999 00:00
Date: Wed, 10 Mar 1999 00:00
25 lines
1549 bytes
1549 bytes
In article <01be6af7$f2d27de0$d30ad3d4@CIS.CIS>, Derek Fawell politely paraphrased ... > After six hours at the machine and then sending previous message, I have > found the cause not a solution but another problem. > > The data I am using is from Xbase with a simple debit, credit and paid > field. The xbase files have either debit or credit empty. I used the old > xbase command 'replace' on the file to set my paid fields. The 7.01 does > not recognise a numeric field with a dot entry as empty as opposed to a > 0.00 which it seems to do. --- Yes we got finally true null support as thousands of users have asked for this feature the last dozen years. Set a default value of 0 if you don't want that behaviour. Same thing for logical values. Also why are you using REPLACE? Since it can be calculated at any time if credit>=debit (or the other way round depending on your system) it should be a calulated field IMO. -- Romain Strieff [TeamB] Please read this newsgroup guide below before posting on the private Inprise newsgroups. http://www.inprise.com/newsgroups/guide.html --
Technical Details
Message-ID:
<MPG.1150d28f3ba0c4f698a035@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01be6af7$f2d27de0$d30ad3d4@CIS.CIS>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 15bdfb,f9fa882b93e4c485 X-Google-Attributes: gid15bdfb,public From: teamb@opto-pps.com (Romain Strieff [TeamB]) Subject: Re: Re Filtering above - apologies Date: 1999/03/10 Message-ID: <MPG.1150d28f3ba0c4f698a035@forums.inprise.com> X-Deja-AN: 453471899 References: <01be6af7$f2d27de0$d30ad3d4@CIS.CIS> Organization: TeamB Newsgroups: borland.public.vdbase.forms