Re: [SQL] Getting user created tables from SQL

2005-10-05 Thread Richard Huxton
Cenk KIZILDAG wrote: TableQuery->SQL->Add ("SELECT TABLE_NAME AS TNAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE')"); CTableArr[f] = TableQuery->FieldByName ("TNAME")->AsString; the first Select statement work correct, counttables variable gets the right value but unfor

[SQL] Getting user created tables from SQL

2005-10-04 Thread Cenk KIZILDAG
hi guys,   i m trying to get the user created tables from SQL by using C++ Builder.Here is the code:   TQuery *TableQuery;    TableQuery= new TQuery (this);     TQuery *TableCountQuery;    TableCountQuery= new TQuery (this);     TableQuery->DatabaseName = "TEMP";    TableCountQu