Page 1 of 1

Using RefreshQuick with views

Posted: Thu 18 Feb 2010 17:01
by AndyFox
I am using Delphi 5 and SDAC 4.00.06. I have a table with both a timestamp and a uniqueidentifier field. The uiniqueidentifier field is set as a row GUID.

If I assign an MSTable component to the table and do a .RefreshQuick call, it works just dandy. Now, I also have an SQL view set up to return rows from my table, including the aforementioned timestamp and uniqueidentifier fields unaltered. If I re-assign my MSTable component to the view and do a .RefreshQuick call, I get a "unique keyfields required" error, even though the fields are still being returned--just by a view, not a table.

Any way to get .RefreshQuick to work with views?

Thanks.

Posted: Fri 19 Feb 2010 08:07
by Dimon
Please, try to download the latest SDAC build (4.80.0.55) and check if this problem still exists.

Posted: Fri 19 Feb 2010 15:37
by AndyFox
Dimon wrote:Please, try to download the latest SDAC build (4.80.0.55) and check if this problem still exists.
I'd rather you told me if this issue has been fixed or not before forking over another $50 and finding out I wasted my money, please.

Posted: Mon 22 Feb 2010 15:52
by Dimon
We have fixed this problem in the latest SDAC build (4.80.0.55). Upgrade to this build to solve the problem.

Posted: Tue 16 Mar 2010 16:51
by AndyFox
Dimon wrote:We have fixed this problem in the latest SDAC build (4.80.0.55). Upgrade to this build to solve the problem.
Thank you!