Problems with roAfterInsert and roAfterUpdate....

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
TEMRUS
Posts: 6
Joined: Tue 01 Feb 2011 12:06

Problems with roAfterInsert and roAfterUpdate....

Post by TEMRUS » Tue 01 Feb 2011 12:20

I'm using Embarcadero RAD Studio XE, SDAC5pro
And I've a problem AFTER inserting a new record into DB :

Code: Select all

msqPodrazdAllSel->Append() ;
Application->CreateForm(__classid(TfPodrazdRed), &fPodrazdRed);
try
   {
   if (fPodrazdRed->ShowModal()==mrOk) msqPodrazdAllSel->Post();
   else msqPodrazdAllSel->Cancel();
   }	
catch(...)
   {
   msqPodrazdAllSel->Cancel();
   }
msqPodrazdAllSel - SDAC TMSQuery
A new record inserts into DB table, but then I cant see it in the dataset.
But msqPodrazdAllSel has these settings:

Code: Select all

    CashedUpdates = False
    RefreshOptions = [roAfterInsert, roAfterUpdate, roBeforeEdit]   FetchAll = False.

Only Open/Close works.
RefreshSQL contains:

Code: Select all

SELECT PodrazdPolnNazv, PodrazdNazv, PodrazdComm, PodrazdCode FROM dbo.tPodrazd
WHERE
  PodrazdID = :PodrazdID
Who knows my mistake?
CRSDA-03069

AndreyZ

Post by AndreyZ » Wed 02 Feb 2011 09:26

Hello,

I cannot reproduce the problem. Please try composing a small sample to demonstrate the problem and send it to andreyz*devart*com.

Post Reply