[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== RBASIC SELECT BY (OpenInsight Specific) ====
=== At 11 MAR 1998 03:16:08PM abjones wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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.


</QUOTE>
----

=== At 12 MAR 1998 12:16PM Aaron Kaplan wrote:  ===

<QUOTE>What happens if you change to AT type?





apk@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>

----

=== At 12 MAR 1998 02:07PM abjones wrote:  ===

<QUOTE>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)

</QUOTE>

----

=== At 12 MAR 1998 05:30PM Aaron Kaplan wrote:  ===

<QUOTE>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

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>

----

=== At 18 MAR 1998 02:47PM Cameron Revelation wrote:  ===

<QUOTE>abjones,



[i]The ID returned by READNEXT is not an expected value[/i]



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

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=140B935B5187C5BA852565C40069D8E8|View this thread on the  forum...]]