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?

Roger Vellacott
Passfield Data Systems Ltd
Tel: +44 1225 317202
Kingston House, Pierrepont Street, Bath BA1 1LA, UK