eof() function

[Mark Campidonica]

I want to use the eof() function in a script. It will not evaluate if used as documented. 'eof()' will evaluate, but 'eof("tablename")' will not evaluate, even though I am using the slection feature of the expression editor (the down arrow for a list of tables) to choose the tablename. Any ideas?

[Stan Mathews]

RE: eof() function

Don't find any documentation of the eof() function taking a parameter in the expression functions reference. The eof() function is used with a pointer obtained with the table.open() or table.current() methods.

The xbasic manual refers to Tbl.eof([Tagname]) where tagname refers to a valid index name.

[crimmelcp]

RE: eof() function

usually when I use eof in a script I am checking to see if the fetch is past the last record.

charlie crimmel

t=table.open("yourtablehere")
t.fetch_first()
while .not. t.frtch_eof()

your code here

t.fetch_next
end while
t.close()

[Tom Cone Jr]

RE: eof() function

Stan,

check pg 41 of the new Expression - function Reference book.

My guess is that the doc's description is wrong, and that EOF() works like BOF()... i.e. with the current table, and not with a table that's identified as an argument to the function.

-- tom

[Tom Cone Jr]

RE: eof() function

Mark, the docs do a poor job of explaining how BOF() and EOF() seem to work.

Here's a series of simple commands from the Interactive Editor, that illustrate it better. The example
is uses a table with 3 records in it.

tbl = table.open("customers.dbf")
?tbl.records_get()
= 3.000000

?tbl.recno()
= 1.000000

?tbl.bof()
= .T.

?tbl.eof()
= .F.

tbl.fetch_next()
?tbl.recno()
= 2.000000

?tbl.bof()
= .F.

?tbl.eof()
= .F.

tbl.fetch_next()
tbl.fetch_next()
?tbl.recno()
= 3.000000

?tbl.bof()
= .F.

?tbl.eof()
= .T.

tbl.close

Both work with the current table, and require
a pointer to reference that table.

-- tom

[Stan Mathews]

RE: eof() function

Tom,

I saw earlier what you see on page 41, but it doesn't refer to a parameter being passed to eof(), nor does the bof() documentation refer to a parameter. Don't know why it is in the expressions reference at all since it is more properly a property? or method? than a function.

I also tried what Mark suggests in the interactive window and it performs exactly as he indicates. The auto-complete provides the [c tablname] and activating the ctrl-down arrow brings up a list of tables. You have to manually type in the "tagname" to correctly use the method.

Any idea why the auto-complete stops at around 148 tables when building the lookup? I have many more than that and only saw tables/sets with names beginning with "a" part-way through "r".

[Mark Campidonica]

RE: eof() function

Charlie hit the nail. I wanted to update a field in a table using an expression. I'll try using Charlie's code in a in-line basic (whatever they are called).

Thanks

Mark

[Stan Mathews]

RE: eof() function

Charlie was just giving you a quick example. More fully the code would be:


t=table.open("yourtablehere")
t.fetch_first()
while .not. t.fetch_eof()

your code here

t.fetch_next()
end while
t.close()

[Mark Campidonica]

RE: eof() function

Aside from the little typo "frtch.eof()", Charlie got me where I needed to go. I was trying to stay with Action Scripts, but alas it looks like I am going to have to write some code. The last time I got deeply into coding I was using punch cards (it is easier to move the lines around, just resort the cards).

Here's what I ended up with. Thanks for the help.


'Assign Employee ID Numbers
dim Shared Employee_IDCounter AS C
dim Shared Counter2 AS C
dim shared Counter1 as N
LET Counter1=0
LET Counter2=""
tbl=table.open("recruitsconv")
tbl.fetch_first()
'A COMET Session Number is set outside this script
'in the character variable Comet_SessionNum. Then a counter is
'added to the end of this number. The counter is padded
'with leading zeros so that it is always 3 places.
WHILE tbl.fetch_eof()=.F.
LET Counter1=Counter1+1
LET Counter2=""
tbl.change_begin()
IF Counter1

[CALocklin]

RE: eof() function

Yes, it was easier to move the code around but, whatever else you do, DON'T DROP THE CARDS!!

[Mark Campidonica]

RE: eof() function

Wanna see a grown man cry?