Sequential read of an access table via c55 1

[akiligar]

i'm trying to read through a microsoft access database table
with a certain key ie:

tab:name = '1'
set(namekey,namekey)
loop
next(nametable)
if errorcode() = 33
break
end
etc.........
end

the reponse i get imediately returns a error 33 without reading any records.
if you just set(nametable) it reads the records.
very confusing.

 

[ShankarJ]

I would suggest CLEARing the buffer before using a SET() i.e. CLEAR(TAB:Record). Also, should you not be using the prefix for the namekey i.e. TAB:namekey. Why don't you try :

CLEAR(TAB:Record)
TAB:Name = '1'
SET(TAB:NameKey,TAB:NameKey)
LOOP ......

I do remember that some versions of Clarion did not return Compile errors on using wrong key names.