Re: check the table exist with ado

Posted by Joe Mamma on November 28, 2004

In Reply to: Re: check the table exist with ado posted by Rbrrneck on October 31, 2004

while that will work, not the recommended way. dont use exceptions as control constructs. . . .

ADOConnection1.OpenSchema(siTables, Vararrayof([Catalog,Schema,TableName,TableType]),
EmptyParam,
ADODataSet1);

tabExists := not (ADODAtaSet1.bof and ADODAtaSet1.eof)

catalog, schema, tablename, tabletype are strings

refer to the win sdk data access section for proper values for these