Subject | Question |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2002-04-02T14:55:05Z |
Hello Jason,
Using TIBOQuery with either RollBack or RollBackRetaining,
Append or Insert,
The sequence:
TIBOQuery.Append
TIBOQuery set values
TIBOQuery.Post
Dataset.CommitRetaing
TIBOQuery.Append
works fine, and last Append is ready to accept a new record
however
The sequence:
TIBOQuery.Append
TIBOQuery set values
TIBOQuery.Post
Dataset.RollbackRetaing
TIBOQuery.Append
the last append shows the first record in the TIBOQuery
and will mistakingly edit that record. It and only moves
to a new record if I use say some DBEdit control linked
to the TIBOQuery in
while Trim(DBEdit.Text) <> '' do
TIBOQuery.Append;
or after the last
TIBOQuery.Append
show some ShowMessage, followed by another
TIBOQuery.Append
With either the While or ShowMessage in place all
Appending/Inserts, Posting with Commit or Rollbacks work
just fine.
Almost seems some time delay is required.
Any suggestion ?
Best regards
Hans
Using TIBOQuery with either RollBack or RollBackRetaining,
Append or Insert,
The sequence:
TIBOQuery.Append
TIBOQuery set values
TIBOQuery.Post
Dataset.CommitRetaing
TIBOQuery.Append
works fine, and last Append is ready to accept a new record
however
The sequence:
TIBOQuery.Append
TIBOQuery set values
TIBOQuery.Post
Dataset.RollbackRetaing
TIBOQuery.Append
the last append shows the first record in the TIBOQuery
and will mistakingly edit that record. It and only moves
to a new record if I use say some DBEdit control linked
to the TIBOQuery in
while Trim(DBEdit.Text) <> '' do
TIBOQuery.Append;
or after the last
TIBOQuery.Append
show some ShowMessage, followed by another
TIBOQuery.Append
With either the While or ShowMessage in place all
Appending/Inserts, Posting with Commit or Rollbacks work
just fine.
Almost seems some time delay is required.
Any suggestion ?
Best regards
Hans