Page 1 of 1

SDAC 8.0.4 RefreshQuick Problem

Posted: Fri 26 Jan 2018 09:31
by wishmaster
Hi,
We select some data from a parameterized table valued function.
Till 8.0.4 we haven't got any problems, the table and function both have timestamp fields and refreshquick works perfect. With 8.0.4 we start to get "The multi-part identifier "xxx.dbo.xxx.timestamp" could not be bound. the fieldname is [timestamp] and it's data type is timestamp. The query itself have no problems, we got this error when we refreshquick only.

Thanks

Re: SDAC 8.0.4 RefreshQuick Problem

Posted: Fri 26 Jan 2018 09:55
by wishmaster
I return back to 8.0.3 and problem gone, so I can confirm again this is related to 8.0.4.

Now I've another problem, as I understand 8.0.4 adds new property to all my hundreds of TMSQuery compnents, after downgrading to 8.0.3 I started to get:

Code: Select all

.... Error reading Table.Constraints: Property Constraints does not exists. Ignore the error and continue? ....

Re: SDAC 8.0.4 RefreshQuick Problem

Posted: Tue 30 Jan 2018 13:45
by Stellar
We tested the work of SDAC 8.0.4, but unfortunately found no problems when retrieving data with the table-valued function. In order for us to analyze the issue, please send us a sample demonstrating this issue, as well as a script for creating the function and the table.

In the new SDAC 8.0.4 version, the Constraints property was added to the TMSQuery class. You can ignore the "Property Constraints does not exist" error, because the TMSQuery class did not have the Constraints property, and dfm-reader finds this property stored in the dfm-file and does not find this property in the TMSQuery class.

Re: SDAC 8.0.4 RefreshQuick Problem

Posted: Sun 11 Feb 2018 01:19
by wishmaster
Hi Stellar,
Sorry it takes a lot of time to prepare the same environment to reporoduce the bug.
Can you send me email address to send the demo project to?

Thanks

Re: SDAC 8.0.4 RefreshQuick Problem

Posted: Mon 12 Feb 2018 12:28
by Stellar
Please leave your request including details of the issue and an example at e-support ( https://www.devart.com the "Support"\"Request Support" menu ).