Devart Forums

Hi,
I evaluate the latest version of UniDAC. I have a problem with auto generating SQLRefresh when I did-not set a specified value to related property.
when I call Post method of TDataSet, the exceptio "Incorrect syntax near '.'" was raised.
I inspect the error and saw that the auto generated sql was mistake.


SELECT ID AS _1, Name AS _2, Code AS _3 FROM dbo.Priority PABaseDb.dbo.Priority WHERE ID = :Old_ID

You could see that base table name appeare more that once with two different values.

The sql property is "SELECT ID, Name, Code FROM PABaseDb.dbo.Priority".

Best Regards
Mehdy Karimpour

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