Subject | Primary Key of Query set by Trigger |
---|---|
Author | Dieter Tremel |
Post date | 2002-04-04T13:45:49Z |
Hello,
I have a TIB_Query in a Form the user uses to insert end edit Records.
Since I have a 2 field PK of which 1 field is set by a trigger it is
difficult for me to show the actual record after insert. I set
BufferSyncroFlags to [bsAfterEdit,bsAfterInsert], but this doesn't
help for Inserts. I tried
procedure Tfrm_Belege.qry_FormAfterPost(IB_Dataset: TIB_Dataset);
var
bmark: string;
begin
inherited;
with IB_DataSet do
if FieldByName('BELEGNR').IsNull then begin
bmark := Bookmark;
Refresh;
Bookmark := bmark;
end;
end;
but this doesn't work also.
I guess because it is the Primary key that is given by the server. But
I like to use the trigger to have an atomic operation for creation of
the PK.
Any Suggestions? Thank You.
Dieter Tremel
I have a TIB_Query in a Form the user uses to insert end edit Records.
Since I have a 2 field PK of which 1 field is set by a trigger it is
difficult for me to show the actual record after insert. I set
BufferSyncroFlags to [bsAfterEdit,bsAfterInsert], but this doesn't
help for Inserts. I tried
procedure Tfrm_Belege.qry_FormAfterPost(IB_Dataset: TIB_Dataset);
var
bmark: string;
begin
inherited;
with IB_DataSet do
if FieldByName('BELEGNR').IsNull then begin
bmark := Bookmark;
Refresh;
Bookmark := bmark;
end;
end;
but this doesn't work also.
I guess because it is the Primary key that is given by the server. But
I like to use the trigger to have an atomic operation for creation of
the PK.
Any Suggestions? Thank You.
Dieter Tremel