Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Description of Table |
Tue, Feb 20 2007 6:18 AM | Permanent Link |
Rastislav | 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 |
Tue, Feb 20 2007 7:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Feb 22 2007 12:21 PM | Permanent Link |
Rastislav | "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 |
Fri, Feb 23 2007 7:13 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |