Devart Forum Index

The time now is Thu 09 Sep 2010 12:34

GetTableNames - Access Provider

 
Post new topic   Reply to topic    Devart Forum Index -> Universal Data Access Components
View previous topic :: View next topic  
Author Message
johnbitner



Joined: 10 Sep 2009
Posts: 11
Location: United States

PostPosted: Thu 29 Jul 2010 13:44    Post subject: GetTableNames - Access Provider Reply with quote

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?
Back to top
View user's profile Send private message
bork
Devart Team


Joined: 12 Mar 2010
Posts: 467

PostPosted: Mon 02 Aug 2010 11:17    Post subject: Reply with quote

Hello

I executed the following code successfully:
Code:
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;

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Devart Forum Index -> Universal Data Access Components All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum