I have a simple loop buried in code invoked by way of

INET_GATEWAY:

…..

OPEN "","WEB_TRACKING" TO WEB_TRACKING_VAR THEN

SELECT "WEB_TRACKING" BY "LOGIN_DATE" SETTING CURSOR THEN

  LOOP

    READNEXT ID USING CURSOR BY "DT" ELSE

  WHILE ID#""

    LOGIN_DATE=XLATE("WEB_TRACKING",ID,"LOGIN_DATE","X")

    IF LOGIN_DATE#'' AND LOGIN_DATE<DATE() THEN

       DELETE WEB_TRACKING_VAR,ID THEN NULL

    END

  REPEAT

END

END ….

I put debugging calls to msg function to track ID and STATUS()

The value of STATUS() was always zero and the THEN clause executed

as expected. The ID returned by READNEXT is not an expected value but appears as portions of OI system type keys as if from the registry. What did I do wrong?

My current code uses the simple form of select var … readnext id

and works fine, but I thought I might need to grab a cursor to keep

from stepping on my own toes latter.

What happens if you change to AT type?

apk@sprezzatura.com

Sprezzatura, Inc.

Thanks, AT (without the quotes) worked. DT (without

quotes) still returns junk. But AT is just fine for

for what I want to do. It just goes to show that one

cannot trust the examples in the book verbatum!

(OforW programmers reference manual page 317)

It used to work, because I had an ARev app the relied very heavily on switching between them. It's why I asked you to check. Sounds like something you should report to Revelation QA as a bug.

apk@sprezzatura.com

Sprezzatura, Inc.

abjones,

The ID returned by READNEXT is not an expected value

We have reproduced a problem with READNEXT DT against resolved lists. A fix will probably not be available until 3.7, however.

Cameron Purdy

info@revelation.com

View this thread on the forum...