SQL more... problem with <NULL> V4MD1

[Ruslan Zasukhin]

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

>> Aha, right. V1 do not support expressions in SELECT.
>> You need make this as Table Method.
>> 
>> --
>> Best regards,
>> 
>> Ruslan Zasukhin
> 
> I already tried this as i am already using some week() and month() stuff.
> But instead of an "empty" I just get a crd_number from a total different
> KD_ID (last of the table KUNDEN)??? This is my method:
> 
>   --Z_DAY Method CRD_SUB     ISNULL(CRD_Number)
> if getfieldref(VAL_ID,val[#KUNDENKARTENtable],"CRD_SUB")=0 then
> AddField(VAL_ID, VAL[#KUNDENKARTENtable],
> "CRD_SUB",#kTypeString,30,0,"IFNULL(CRD_Number,'')")
>     setFieldFlag(VAL_ID,
> getfieldref(VAL_ID,val[#KUNDENKARTENtable],"CRD_SUB"),16,TRUE)
>     ChangeFieldMethod
> VAL_ID,getfieldref(VAL_ID,val[#KUNDENKARTENtable],"CRD_SUB"),
> "IFNULL(CRD_Number,'')"
>     if valentinaError()<>0 then
>       alert "Datenbankerweiterung konnte nicht initialisiert werden. Bitte
> informieren Sie den Support"
>     end if
>     flush(VAL_ID)
>   end if

Looks correct.

Try in Valentina studio may be.
You need first of all find correct formula of 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]