After some questions in a thread under elevatedb.sql named "table
version and updates", I decided to post the TableVersion function here.
It comes in quite handy when wanting to update a customer's database
and you need to query their current version of a table to decide how
which set of ALTER statements to execute.  Here it is for your EDB
library:


CREATE FUNCTION "TableVersion" (IN "TableName" VARCHAR COLLATE ANSI)
RETURNS FLOAT
BEGIN
 DECLARE VerCursor CURSOR FOR VerStmt;
 DECLARE Ver FLOAT;

 PREPARE VerStmt FROM
   'SELECT Version FROM Information.Tables
    WHERE Name = '''' + TableName + ''''';

 OPEN VerCursor;
 FETCH FIRST FROM VerCursor (Version) INTO Ver;
 CLOSE VerCursor;
 UNPREPARE VerStmt;

 RETURN Ver;
END


--
David Cornelius
CorneliusConcepts.com
custom designed software

David,

Thanks for the contribution.

--
Tim Young
Elevate Software
www.elevatesoft.com