Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB Public Beta Tests
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Table version
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