Subject | Re: [IBO] Q. about order of row insertion |
---|---|
Author | Jason Wharton |
Post date | 2002-11-04T23:34:04Z |
That all depends on how you dataset behaves as a result of the Commit. If
you do a refresh the records will be brought back from the server in the
order it deems appropriate. If you have an ORDDER BY then it uses it. If the
dataset is not refreshed then the records will remain in the buffer in the
same order as they were when inserted.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
you do a refresh the records will be brought back from the server in the
order it deems appropriate. If you have an ORDDER BY then it uses it. If the
dataset is not refreshed then the records will remain in the buffer in the
same order as they were when inserted.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
----- Original Message -----
From: "tickerboo2002" <support@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, November 01, 2002 9:02 AM
Subject: [IBO] Q. about order of row insertion
> Hello
>
> If, using a TIB_Query, I insert row1, row2, row3 and then call
> commit, will my after insert trigger see row1, followed by row2,
> followed by row3 in that order?
>
> Thanks
>
> David