Hello,

how I can get description of Table ? In DBISAM I use Table1.Description, Table12.LocaleID,
etc. ... I cannot find it in Elevate Table ...

Thanks

Rastislav,

<< how I can get description of Table ? In DBISAM I use Table1.Description,
Table12.LocaleID,etc. ... I cannot find it in Elevate Table ... >>

You would use a catalog query on the special Information schema for the
database like this:

SELECT Description
FROM Information.Tables
WHERE Name='MyTable'

An alternative is simply opening up the Tables table and just setting a
filter:

function GetTableDescription(const TableDB: string; const TableNm: string):
string;
var
   TempTable: TEDBTable;
begin
  TempTable:=TEDBTable.Create(nil);
  try
     with TempTable do
     begin
     DatabaseName:=TableDB;
     TableName:='Information.Tables';
     Filter:='Name='+Engine.QuotedSQLStr(TableNm);
     Filtered:=True;
     Open;
     Result:=FieldByName('Description').AsString;
     end;
  finally
     TempTable.Free;
  end;
end;

You can find more information on the Information schema here:

http://www.elevatesoft.com/edb1sql_information_schema.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

You would use a catalog query on the special Information schema for the
database like this:

SELECT Description
FROM Information.Tables
WHERE Name='MyTable' ...
----------------------------------------------------------------------------

Tim,

thank you for answer and example of solution !
I am user of DBISAm also and I will start development of new local application.  
Could be I use DBISAM without worry ...?
Do you will continue in development DBISAM also ? (since you develope EDB ...)

Thank you for answer in advance

Rastislav

Rastislav,

<< I am user of DBISAm also and I will start development of new local
application.  Could be I use DBISAM without worry ...?  >>

Sure.  But, it may be a good opportunity to use EDB also.

<< Do you will continue in development DBISAM also ? (since you develope EDB
....) >>

We will be supporting and issuing fixes for DBISAM for at least for one more
year.

--
Tim Young
Elevate Software
www.elevatesoft.com