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
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);
   if (fPodrazdRed->ShowModal()==mrOk) msqPodrazdAllSel->Post();
   else 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
  PodrazdID = :PodrazdID
Who knows my mistake?


Post by AndreyZ » Wed 02 Feb 2011 09:26


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

Post Reply