Delphi 7 SDAC 4.80
Posted: Tue 26 Jan 2010 13:52
Hi,
I am using Delphi 7 and the latest SDAC version. I have converted several of my tables to use uniqueidentifier primary keys populated with defaults using newid(). My issue is that when I insert a record the GUID isn't available until I call a full refresh of the dataset.
I have tried calling refreshrecord, setting roafterinsert etc but these raise errors as it can't find the record because it doesn't know the GUID.
Any ideas?
Thanks
I am using Delphi 7 and the latest SDAC version. I have converted several of my tables to use uniqueidentifier primary keys populated with defaults using newid(). My issue is that when I insert a record the GUID isn't available until I call a full refresh of the dataset.
I have tried calling refreshrecord, setting roafterinsert etc but these raise errors as it can't find the record because it doesn't know the GUID.
Any ideas?
Thanks