Using RefreshQuick with views
Posted: 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.
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.