SQL more... problem with <NULL> V4MD1

[Ruslan Zasukhin]

On 11/4/06 1:33 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

>>> I see. I guess it would be IFNULL(CRD_Number,0) ?
>>> 
>>> Where would I insert that in the SQL string?
>> 
>> Instead of CRD_Number
>> 
>> 
>> SELECT IFNULL(CRD_Number,0), f2, f3
>> 
> 
> Sorry, but it does not work:
> 
> put valselectreturnrecord("select CRD_Number, KD_ID, vorname FROM
> KUNDENTABLE,KUNDENKARTENTABLE WHERE KD_ID*=CRD_KD_ID")
> 
> is fine: -- [#CRD_Number: "delight", #KD_ID: 3083, #vorname: "Kasse"]
> 
> put valselectreturnrecord("select IFNULL(CRD_Number,0), KD_ID, vorname FROM
> KUNDENTABLE,KUNDENKARTENTABLE WHERE KD_ID*=CRD_KD_ID")
> 
> produces: 
> 
> error 603
> error 603
> 
> "expected field not found"
> 
> 
> ???

Aha, right. V1 do not support expressions in SELECT.
You need make this as Table Method.

-- 
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]