Using RefreshQuick with views

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
AndyFox
Posts: 3
Joined: Thu 18 Feb 2010 16:50
Location: Minnesota

Using RefreshQuick with views

Post by AndyFox » Thu 18 Feb 2010 17:01

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.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 19 Feb 2010 08:07

Please, try to download the latest SDAC build (4.80.0.55) and check if this problem still exists.

AndyFox
Posts: 3
Joined: Thu 18 Feb 2010 16:50
Location: Minnesota

Post by AndyFox » Fri 19 Feb 2010 15:37

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.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 22 Feb 2010 15:52

We have fixed this problem in the latest SDAC build (4.80.0.55). Upgrade to this build to solve the problem.

AndyFox
Posts: 3
Joined: Thu 18 Feb 2010 16:50
Location: Minnesota

Post by AndyFox » Tue 16 Mar 2010 16:51

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!

Post Reply