SQL question

[Ruslan Zasukhin]

On 11/11/04 9:09 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

>> You have forget that you cannot use funcs directly in SQL.
>> You need BaseObject method
>> 
> 
> I tried a method. After some time I figured out what to do.
> I used the only example in the docs (V4MD) but the field did not become a
> method. I set the method flag and since I did not get a method text, I
> changed that too...
> 
>     AddField(VAL[#ID], VAL[#KUNDENTable],
> "gebmo",#kTypeString,5,"MONTH(geburtsdatum)")

Why string ?

Month() will return integer


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

No need

>     ChangeFieldMethod
> val[#id],getfieldref(val[#ID],val[#KUNDENTable],"gebmo"),
> "MONTH(geburtsdatum)"

No need

>     if valentinaError()<>0 then
>       alert "Datenbankerweiterung konnte nicht initialisiert werden. Bitte
> informieren Sie den Support"
>     end if
>     flush(VAL[#ID])

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------