Devart Forums

Hello,

we recently upgraded the SDAC components we use in our projects to version 7.1.3. This version has introduced a behavior that might be a bug:

If a SQL statement contains schema and table name in square brackets the table will get an alias. Auto-generated refresh statements will be of incorrect syntax for this.

Example:
SELECT FieldName FROM [Schema].[Table]
Resulting refresh statement:
SELECT FieldName AS _0 FROM Schema.Table [Schema].[Table]
WHERE ...

Is this a bug? The SDAC version used before did not use an alias.

We couldn't reproduce the problem. Please, try to compose a small sample to demonstrate the problem including a script to create test table and send it to andreyz*devart*com .

I have the same problem, i try to use database.schema.table and when SDAC will try to generate sql they supress the database and just use schema.table, this give me a lot of problems ... this works on 6.11 fine but after update to 7, start to give a error.

We have reproduced this problem and are investigating it. We will notify you about the results as any are available.

We have fixed this problem. This fix will be included in the next SDAC build.