Subject Re: [ib-support] UDFs and computed fields
Author Svein Erling Tysvær
>If wrote a UDF containing a function WEEKNO to return week numbers from
>dates. It works a treat. So I put in a load of new fields to my tables in
>the form

>DELIVERY_WEEK COMPUTED BY (WEEKNO(DELIVERY_DATE))

>This also works nicely in wisql and such. But wheni run my Delphi app,
>using TIBOQuery linked to TDatasource and VCL Controls, everything is blank.
>If I remove the computed fields, everything comes back again. Tables without
>computed fields behave throughout as normal.

>Any ideas why?

No, but I think Jason or Geoff will have if you post this question to
ibobjects@yahoogroups.com and supply a bit more detail (e.g. source code
for your UDF and SQL for your TIBOQUERY). This list is more suitable for
questions not specific to connection tools (IBO, IBX, FIB, BDE) being used.

Set