Devart Forums

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

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

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.