Not if you want to use the view designer. You could try Erik Moore's E-view in the downloads section, or hand code your views, and don't try opening them in the designer.

>I have the need to access a not predermined number of records using a parameterized view, with a single REQUERY().
>
>The simplest view could be the following:
>SELECT * FROM prdatab1!orderRows WHERE orderRows.id IN (?lnIDs)
>
>No problem if lnIDs represents a single ID (i.e. 3).
>
>Problems begin when records to extract are 2 or more: i.e. records with ID= 3,5,7
>
>I tried to use an array to store the IDs to download:
>DIMENSION lnIDs[3]
>lnIDs[1] = 3
>lnIDs[2] = 5
>lnIDs[3] = 7
>and then requery; but only the record with ID = 3 is extracted.
>
>With a second attempt, I've created a view like that:
>SELECT *;
> FROM prdatab1!pr1ordcr;
> WHERE Pr1ordcr.id IN (SELECT id FROM TempCursXView)
>
>Before the requery I fill the records of TempCursXView with:
> id = 3 (record 1)
> id = 5 (record 2)
> id = 7 (record 3)
>
>This works, but when I try to re-open the view with the designer I get the error "SQL expression is too complex".
>
>Is there a way to obtain the result in a more comfortable way?
>Thanks.