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 8:58 PM	Permanent Link
Fernando Dias Team Elevate	Tim, How to get/set the table version (via SQL and/or TEDBTable component) ? -- Fernando Dias
Sun, Dec 17 2006 4:49 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Fernando, << How to get/set the table version (via SQL and/or TEDBTable component) ? >> You can get it via the database's Information schema like this: SELECT * FROM Information.Tables WHERE TableName='MyTable' You'll see it in there as a field value. For setting it, use the ALTER TABLE SQL statement: http://www.elevatesoft.com/edb1sql_alter_table.htm like this: ALTER TABLE MyTable VERSION 2.00 -- Tim Young Elevate Software www.elevatesoft.com