Subject | how to delete all record in Tiboquery? |
---|---|
Author | bigred17201720 |
Post date | 2002-09-05T08:37:47Z |
Hi,
I use ibodatabase+iboquery(catchupdate,requrestlive).
when I want to delete all record in iboquery,
my code like follow:
while not iboquery.isempty do
iboquery.delete;
iboquery.applyupdate;
iboquery.close;
iboquery.open;
after the iboquery open, some time I will
find there is still 1 record in iboqery.
so I change change the code as:
while not iboquery.isempty do
iboquery.delete;
iboquery.applyupdate;
iboquery.close;
iboquery.open;
while not iboquery.isempty do
iboquery.delete;
iboquery.applyupdate;
iboquery.close;
iboquery.open;
after twice apply the delete action,
the iboquery finally empty.
but why I need twice delete action?
Please Help.
Kadee
I use ibodatabase+iboquery(catchupdate,requrestlive).
when I want to delete all record in iboquery,
my code like follow:
while not iboquery.isempty do
iboquery.delete;
iboquery.applyupdate;
iboquery.close;
iboquery.open;
after the iboquery open, some time I will
find there is still 1 record in iboqery.
so I change change the code as:
while not iboquery.isempty do
iboquery.delete;
iboquery.applyupdate;
iboquery.close;
iboquery.open;
while not iboquery.isempty do
iboquery.delete;
iboquery.applyupdate;
iboquery.close;
iboquery.open;
after twice apply the delete action,
the iboquery finally empty.
but why I need twice delete action?
Please Help.
Kadee