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 ).