OI3.61

When using select by with a sortlist which contains more than one option AND one of the sortlist selections is not a key field the select by returns no records.

The same problem with Rlist (select ).

The system selects correctly in development but not in runtime

Example=Select Product by prod_group by prod_code OK

Select Product by prod_group by prod_descr returns no selections.

Only seems to happen with more than say 1000 records

Do I need new DLL's . I have checked that all dlls are same in dev and runtime.

Also for different table with different dictioneries.

I have changed dictionery names etc etc.

I am at a loss??

Thanks,

Gerry

Gerry,

I run 3.61 too. I tried a "LIST … BY BY " in Report Builder (ORMAIN) and it seemed to work fine in runtime. Well, at least I think that more than 1000 rows had been displayed in the preview window at the time I cancelled. I hadn't got the patience to wait for all 4000. (My keys are around 12-16 characters in length, and the fields I displayed had on average 40 characters per row.)

If you don't get help, I suggest the following workaround: Make a symbolic from the two fields, put on an index, and use that symbolic for sorting instead:

prod_group_and_code=prod_group : : prod_code

- Oystein -

Thanks Oystein,

The list and select works ok in report builder but not in RBASIC.

Gerry.

ps cant be memory or operating system as tried on different pcs NT4 Win95 etc.

Gerry,

R/List does report error information. For example, try running your statement using a program like:

function Test_Rlist(Stmt)

…

Set_Status(FALSE$)

Rlist(Stmt, …)

if Get_Status(Err) then

Set_Status(FALSE$)

Ret=Failed, error info=: Err

end else

Ret=Success, ": @reccount: " records selected."

end

return Ret

Cameron Purdy

Revelation Software

Gerry

Check that the directory for the SORT/TEMPORARY files as set up in the environment (DB manager/Environment) are available and do exist. RLIST will normally return an error if it cannot access this directory, but it is worth checking anyway.

Nick

View this thread on the Works forum...