🚀 go-pugleaf

In article <01bd7536$79b17a40$16f3f3c2@pserver>, mario@mbox.medianetis.it 
grudgingly admits...
> Is possible in a SELECT instruction formatting numeric fields to _0_ if
> this same fields are empty ?
-----
Replace them with 0 if they are NULL and set the default value for that 
field to be 0 _in_ the table. (MODI STRU)

> 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.
----
Level 7 tables just offer true NULL support just like any other DBMS in 
the world did from the beginning, it's only us that have to get 
accustomed to it.


-- 
Romain Strieff [TeamB]
Want quick help? Check previous Q and A at:
http://forumsearch.borland.com:88/ and TIs at
http://www.borland.com/VdBASE/vdbprod.html