Hi

We have been using AREV sins 1989 and I have never had any big problems with Perform Select but when I execute this statement :

Perform "SELECT COSTUMER (WITH C_KOD EQ "" OR "D") AND (WITH COSTUMERNO EQ ..and then 70 numbers..)

I get FS.130

Code 33 has not been been impleme

in the filing system RTP 57

This operation will be cancelled.

If we reduse the numers from 70 to 50 the select works.

I tryed the same Select on a AREV 2.12 system on then same PC and it worked.

Is there a limit in then Select statement in AREV 3.12 when using the filter keyword WITH ?

Regards

Bo Follaug / AKRIBI System AB

Yes there is a limit. At least we have experienced the

same problem. Here are some ideas to get around the

problem.

1) Create a record somewhere, like lists, containg the

 desired values delmited by a FM, VM, RM, etc. or 

 whatever

2) Make a symbolic that xlates the record from the list

 file, then locates the record id/field and returns

 either true or false.

3) Include the symbolic in the select statement.

IF you need to do things on the fly, then the list

record can be updated with whatever values before

running the select.

Good Luck.

Brock Prusha

DFM Systems, Inc

bprusha@mapcon.com

View this thread on the forum...