SQL question

[Florian Bogeschdorfer]

Hi!

I am back to this topic again...

> 
> I have check docs.
> 
> AddField object me, integer boRef,string fldName,symbol 
> fldType, [integer Param1], [integer Param2],[integer Method]
> 
> 
> 
> Now look on your code:
> 
>   AddField(
>         VAL[#ID], 
>         VAL[#KUNDENTable],
>         "gebmo",
>         #kTypeString,
>         5,
>         "MONTH(geburtsdatum)")
> 
> Count parameters, Florian.
> 
> You have miss the Param2.
> Must be 
> 
> 
>   AddField(
>         VAL[#ID], 
>         VAL[#KUNDENTable],
>         "gebmo",
>         #kTypeString,
>         5,
>         0, 
>         "MONTH(geburtsdatum)")
> 
> 

Please look at this ( I corrected the syntax):

put AddField(VAL[#ID], VAL[#KUNDENTable],
"gebmo",#kTypeByte,0,0,"MONTH(geburtsdatum)")
-- 102360736

put getFieldFlag(VAL[#ID],
getfieldref(val[#ID],val[#KUNDENTable],"gebmo"),16)
-- 0
put getfieldflag(VAL[#ID],102360736,16)
-- 0

//field is not a method...
//now:

setFieldFlag(VAL[#ID],
getfieldref(val[#ID],val[#KUNDENTable],"gebmo"),16,TRUE)

put getFieldFlag(VAL[#ID],
getfieldref(val[#ID],val[#KUNDENTable],"gebmo"),16)
-- 1

What am I doing wrong?

Best regards, Florian