We just spent a couple hours trying to figure out why a simple rlist select and a loop readnext will not work. Has anyone found selection problems in 3.6?

We can select small tables (500 to 1000 records) with and without by statements and they work. We can select large tables (105,000 records) without by statements and have no trouble. However, if we select a table (roughly 5,000 records or larger) and we use a by statement: @Reccount is set but it will not readnext and therfore Cnt is 0. It sets Eof to True on the first pass. Please help!

False=0

True=1

Clearselect

!Call Rlist("SELECT DEMOGRAPHICS",5,,,) ;* does work Call Rlist("SELECT DEMOGRAPHICS BY ZIP",5,,,) ;* does not work

Rec=@Reccount

Cnt=0

Eof=False

Loop

Readnext Id else Eof=True

Until Eof

Cnt += 1 

Repeat

debug

There are 107,340 records in this table.

If we select like this:

Call Rlist("SELECT 107340 DEMOGRAPHICS BY NAME_LF",5,,,) It works. If we select like this: Call Rlist("SELECT 107341 DEMOGRAPHICS BY NAME_LF",5,,,)

or

Call Rlist("SELECT DEMOGRAPHICS BY NAME_LF",5,,,'')

It does not work.

We are also getting "invalid target type 5" error messages on entities that do larger selects. (mainly popups)

It seems as though if the select is allowed to reach the end and grab all records, that it then looses what it had.

All this works in 3.5. After installing 3.6 we have this trouble. Please help, it is critical that we resolve this quickly.

Jeff,

Your problem prompted another customer to call to report a similar problem which triggered the rememberance of a weird FS111 error message which … to make a long story short … allowed us to track down the error.

Unfortunately, I cannot yet provide a patch because $RTP9, the cause of the problem, is located in the REVBOOT file. I will work on getting this into the next product upgrade (3.61) which should be available shortly.

Cameron Purdy

Revelation Software

Thanks! The patch corrected it.

View this thread on the forum...