Article View: borland.public.vdbase.data.sql
Article #1103Re: Empty field in sql query
From: Francesco Rossi
Date: Fri, 01 May 1998 00:00
Date: Fri, 01 May 1998 00:00
24 lines
1512 bytes
1512 bytes
Is possible in a SELECT instruction formatting numeric fields to _0_ if
this same fields are empty ?
I have tested with:
SELECT MyField {0} from MyTable
but if language driver of BDE is DB850IT this instruction generate empty
fields.
If language driver of BDE is Paradox intl this instruction generate 0 in
numeric value,
(correctly) but with this language driver name of field are truncated (only
10 characters) and underscore is added in place of space when rowset is
generated.
There is any other type of SELECT instruction for me ?
Thank
P.S. Romain, sorry, i give too many work form TeamB, but my applications is
various and very large and conversion is still difficult.
I hope this discussions are very useful for any VDB user.
Romain Strieff [TeamB] <Romain@Do.not.reply.via.e-mail> scritto
nell'articolo <MPG.fb2d66a3a0118aa98ac96@forums.borland.com>...
> Is _what_ possible in a SELECT instruction?
> --
Technical Details
Message-ID:
<01bd7536$79b17a40$16f3f3c2@pserver>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bd73a9$f0659ba0$12f3f3c2@pserver> <MPG.fb28e9fce712ffd98ac7c@forums.borland.com> <01bd745c$b2a7da40$14f3f3c2@pserver> <MPG.fb2d66a3a0118aa98ac96@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,bbdcd10171d882f5 X-Google-Attributes: gidff5a1,public From: "Francesco Rossi" <mario@mbox.medianetis.it> Subject: Re: Empty field in sql query Date: 1998/05/01 Message-ID: <01bd7536$79b17a40$16f3f3c2@pserver> X-Deja-AN: 349399788 References: <01bd73a9$f0659ba0$12f3f3c2@pserver> <MPG.fb28e9fce712ffd98ac7c@forums.borland.com> <01bd745c$b2a7da40$14f3f3c2@pserver> <MPG.fb2d66a3a0118aa98ac96@forums.borland.com> Organization: R.S.I. di Francesco Rossi Newsgroups: borland.public.vdbase.data.sql