Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FP2.6DOS - EOF()
Message
From
12/11/1997 10:22:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
FP2.6DOS - EOF()
Miscellaneous
Thread ID:
00059699
Message ID:
00059699
Views:
72
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
Map
View

Click here to load this message in the networking platform