BorlandTalk.com

Erich Wanker · Guest

Question:

i have a lot of tables (i don´t know how mutch..)
and want to find a special field in all Tables.

every Table has the fields number,pid,searchfield.... and different other
fields
every Table name is written in my AllTableNames - Table ;-)

________________________________
SqlText:=" select field from "

for x= 1 to AlltableNames.recordcount
begin
SqlText = SqlText + Tablename+ " and"
end;

SqlText = SqlText +" order by xy"
_________________________________

Can somebody post me a demo-Statement please?
I want find all Rows with Pid as "T" over all Tables
How long can a sql-Syntax be ? (256 Chars?-when i have a problem...)

--
Contact:
Erich Wanker | www .sec. at | wanker @ sec.at

Using:
Delphi7 | Jedi | Reportbuilder | LmdTools | Zeos | InfoPower | RXLib |

The Awful Truth:
We are Microsoft. Resistance Is Futile. You Will Be Assimilated