How to get schemaName.tableName from getTableNames(List)

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dam54
Posts: 10
Joined: Thu 23 Jun 2011 19:26

How to get schemaName.tableName from getTableNames(List)

Post by dam54 » Thu 23 Jun 2011 19:36

When setting the tableName property, it needs to be in the form schemaName.tableName, however, I get this information from getTableNames(List). Is there a setting or some way to get the list of tables returned to include the schema name as well? Thanks in advance!

AndreyZ

Post by AndreyZ » Fri 24 Jun 2011 08:20

Hello,

In the latest SDAC version 5.10.0.7 the GetTableNames method returns table names with schema names, unless schema name is dbo (the default schema name).

dam54
Posts: 10
Joined: Thu 23 Jun 2011 19:26

Post by dam54 » Fri 24 Jun 2011 13:55

Thank you for the quick response! I downloaded the latest version and it indeed solves the problem.

AndreyZ

Post by AndreyZ » Fri 24 Jun 2011 14:12

Feel free to contact us if you have any further questions about SDAC.

Post Reply