From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Cenk KIZILDAG <cenk1536(at)yahoo(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Getting user created tables from SQL |
Date: | 2005-10-05 08:32:31 |
Message-ID: | 43438F9F.9090207@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 unfortunately, after the second select statement,
> in C++ Builders SQL Explorer window, it brings the correct number of
> rows but without datas in them!!! In Enterprise Manager the second
> select statement also works correct but how come it aint work in C++
> builder?
I don't suppose this could be an identifer case issue? In the first
query TNAME will be case-folded to 'tname' (because that's how PG does
case-insensitive identifiers).
Try looking up FieldByName("tname") and see if that comes up with anything.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Joost Kraaijeveld | 2005-10-05 11:35:32 | Help with simple SQL query? |
Previous Message | Richard Huxton | 2005-10-05 08:30:04 | Re: BirthDay SQL Issue |