|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 fromNo, but I think Jason or Geoff will have if you post this question to
>dates. It works a treat. So I put in a load of new fields to my tables in
>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?
firstname.lastname@example.org 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.