When calling GetTableNames using the Acess provider I get an "Abstract Error". Using 3.0.0.10.
I can call this with MS SQL database. Does this not working on Access?
If not does anyone know how to get a table list with access database with or without unidac?
GetTableNames - Access Provider
-
- Posts: 22
- Joined: Thu 10 Sep 2009 16:18
- Location: United States
Hello
I executed the following code successfully:
Try to create a new application and execute the same code. Please provide me the result of executing this code. If this code is working correctly then please modify this code to reproduce your issue.
I executed the following code successfully:
Code: Select all
var
i: integer;
str: string;
TableNames: TStringList;
MyConnection: TUniConnection;
begin
MyConnection := TUniConnection.Create(self);
MyConnection.ProviderName := 'Access';
MyConnection.Database := '...'; // set correct database
TableNames := TStringList.Create;
try
MyConnection.Open;
MyConnection.GetTableNames(TableNames, true);
for i := 0 to TableNames.Count - 1 do
str := str + TableNames[i] + #13;
ShowMessage(str);
finally
TableNames.Destroy;
MyConnection.Destroy;
end;
end;