schema names with tables

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Fri 24 Sep 2010 14:18

schema names with tables

Post by pabon » Fri 24 Sep 2010 14:30

when using the TMSTable component, the tablename property in the object explorer does not show the schema name. Setting the component to active causes an object not found,because the schema name is not specified. SDAC v5.00.1 for Dephi 2010, SQL 2008R2.

Am I doing something incorrect? In earlier version the table dropdown list displayed schema.tablename...


Post by AndreyZ » Mon 27 Sep 2010 08:05


You have to set the schema name explicitly if you are using non-standard schema name.
To solve the problem you should use the following code:

Code: Select all

MSTable.TableName := 'your_schema_name.your_table_name';

Post Reply