Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Sat, Dec 16 2006 6:32 PM	Permanent Link
"Gabriel"	Tim, Is it possible to create fields calculations directly in the database? Gabriel
Sun, Dec 17 2006 4:29 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Gabriel, << Is it possible to create fields calculations directly in the database? >> Yes. Use the GENERATED ALWAYS AS <Expression> syntax for the desired column during table creation: http://www.elevatesoft.com/edb1sql_create_table.htm However, generated columns can only use simple expressions - no queries, references to other tables, or stored function calls. -- Tim Young Elevate Software www.elevatesoft.com