SQL more... problem with <NULL> V4MD1

[Florian Bogeschdorfer]

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


???

Best, FLorian