[V4MD] Empty field returns <void>, can it return ""? -- YES using IFNULL()

[Irv Kalb]

Thanks Bart and Ruslan.  Since you've both come up with the same 
solution, I'm sure I can get it to work.

I still don't understand why a string field would default to <VOID> 
rather than the empty string, but I make the change.

Irv

At 10:14 AM +0300 9/24/08, Ruslan Zasukhin wrote:
>On 9/23/08 8:18 PM, "Irv Kalb" <Irv at furrypants.com> wrote:
>
>Ji Irv,
>
>>  My customer creates their tables in Excel and exports them to tab
>>  delimited files.  In some of their records, they have no entry for
>>  one or more fields.  For example, they may have a record with fields
>>  (all are 'string' fields):
>>
>>     A  B  C  D  E
>
>>  And a record may look like:
>>
>>  ValueOfA<tab>ValueOfB<tab>ValueOfC<tab><tab>ValueOfE
>
>Right. And \t\t   means for Valentina    NULL value.
>
>-----
>>  In this record, there is no value for D.  When I try to get this
>>  record in my application, I get a list back like this:
>>
>>  ["ValueOfA", "ValueOfB", "ValueOfC", <Void>, "ValueOfE"]
>
>This is Lingo list
>
>>  Which seems perfectly reasonable.   However, I am converting code
>>  from V12 to Valentina, and in the same situation, V12 returned a list
>>  like this:
>>
>>  ["ValueOfA", "ValueOfB", "ValueOfC", "", "ValueOfE"]
>
>Okay, easy
>
><http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:docume
>ntation:vsql:reference:expr:functions:flowcontrol>
>
>Here see function ifnull()
>
>You need just change your SELECT to be as
>
>     SELECT ..., ifnull( fldD, "" )
>
>
>--
>Best regards,
>
>Ruslan Zasukhin
>VP Engineering and New Technology
>Paradigma Software, Inc
>
>Valentina - Joining Worlds of Information
>http://www.paradigmasoft.com
>
>[I feel the need: the need for speed]
>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>
>--
>This message has been scanned for viruses and
>dangerous content by MailScanner, and is
>believed to be clean.


-- 

Multimedia R Us