refresh record error

bekturov · Post by **bekturov** » Fri 21 Apr 2006 10:54

Hi!

I use TMsQuery, are set SQL, SQLUpdate and SQLRefresh if to do so:

MSQuery1.Edit;
MSQuery1['test'] := 'test';
MSQuery1.Post;
MSQuery1.ApplyUpdates;
MSQuery1.RefreshRecord;

that all is normal, but if

MSQuery1.RefreshOptions := [roAfterUpdate];
MSQuery1.Edit;
MSQuery1['test'] := 'test';
MSQuery1.Post;
MSQuery1.ApplyUpdates;

That is raised a error " Could not convert variant of type null into type int64 " the project empty, i.e. contains only the resulted code, it is a mistake of library or mine? sdac 3.70.1.26

Jackson · Post by **Jackson** » Fri 21 Apr 2006 15:20

Please specify definition of your database objects and your selection query.
Also supply us following information
- Exact version of Delphi
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in Info sheet of TMSConnection Editor

Jackson · Post by **Jackson** » Tue 25 Apr 2006 11:50

Thank you for information.
We reproduced the problem and fixed it. This fix will be included in the next SDAC build. Please watch for announcements at the forum.