You can use UDF, i get freeudflib.dll from internet(i forgot the site), and you can use it.(download the attachment). first copy freeudflib.dll to udf directory in your firebird installation directory, then declare this udf like :
DECLARE EXTERNAL FUNCTION F_DAYOFWEEK
DATE
RETURNS INTEGER BY VALUE
ENTRY_POINT 'DayOfWeek' MODULE_NAME 'FreeUDFLib'

and, now you can work with function F_DAYOFWEEK, imagine this
CREATE TABLE TABLE_NAME
(
ID INTEGER NOT NULL PRIMARY KEY,
DATE_ONLY DATE,
DOFWEEK COMPUTED BY (F_DAYOFWEEK(DONLY))
);




Wayne Forrest <wayne@...> wrote:

How can one determine the Day of week in a cumputed field.

Monday being day 1
Friday being day 5


[Non-text portions of this message have been removed]


Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.






---------------------------------
Do you Yahoo!?
The all-new My Yahoo! � Get yours free!

[Non-text portions of this message have been removed]