From b5ddc6c8de90632ac8cbd9c2c1d3eb30534d66cb Mon Sep 17 00:00:00 2001 From: tobigun Date: Thu, 23 Jul 2009 21:04:32 +0000 Subject: update to current trunk (1853) git-svn-id: svn://svn.code.sf.net/p/ultrastardx/svn/branches/experimental@1913 b956fd51-792f-4845-bead-9b4dfca2ff2c --- unicode/src/lib/SQLite/SQLiteTable3.pas | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'unicode/src/lib/SQLite/SQLiteTable3.pas') diff --git a/unicode/src/lib/SQLite/SQLiteTable3.pas b/unicode/src/lib/SQLite/SQLiteTable3.pas index 7df76363..3aed54a4 100644 --- a/unicode/src/lib/SQLite/SQLiteTable3.pas +++ b/unicode/src/lib/SQLite/SQLiteTable3.pas @@ -139,6 +139,7 @@ type procedure Commit; procedure Rollback; function TableExists(TableName: string): boolean; + function ContainsColumn(Table: String; Column: String) : boolean; function GetLastInsertRowID: int64; function GetLastChangedRows: int64; procedure SetTimeout(Value: integer); @@ -759,6 +760,26 @@ begin end; end; +function TSQLiteDatabase.ContainsColumn(Table: String; Column: String) : boolean; +var + sql: string; + ds: TSqliteTable; + i : integer; +begin + sql := 'PRAGMA TABLE_INFO('+Table+');'; + ds := self.GetTable(sql); + try + Result := false; + while (ds.Next() and not Result and not ds.EOF) do + begin + if ds.FieldAsString(1) = Column then + Result := true; + end; + finally + ds.Free; + end; +end; + procedure TSQLiteDatabase.SetTimeout(Value: integer); begin SQLite3_BusyTimeout(self.fDB, Value); -- cgit v1.2.3