Problems with roAfterInsert and roAfterUpdate....

[TEMRUS]

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]

Hello,

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