Hi Everybody!
I have an old fox program. which I got back with a strange behaviour.
(The problem described here, didnot occur till now, because all data was imported at start - explanation follows)
The program runs on network.
There is a sure empty table. (ITEMS)
use items again alias firstopen
do myproc && this proc add some records
select firstopen
go top
&& after this, the EOF() still TRUE!!!
use
procedure myproc
select 0
use items again alias secondopen
for i=1 to 5 && any number cause the same behaviour
insert into secondopen (...) values (...)
endfor
use
SO. The problem is, that EOF() is TRUE, but the record pointer went to the top of the table. The behaviour is independent from how much record were added by myproc. This problem occurs only, if the table was empty, when myproc added the records. If ITEMS has 1 or more records, the problem doesnot occur.
I found two workarounds,
* close and reopen the table, or
* seek for any record.
But, I am afraid, there is an explanation.
Can somebody help me?
TIA:
Bela
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only