Hi Dragon,

Another approach would to use the IN clause the SQL of your view would look something like this:

SELECT * FROM MyTable WHERE cid IN (SELECT cTempId FROM cTempCursor)

Before requerying the view, all you have to do is create this temporary cursor cTempCursor and insert values which you want to be brought into the SQL. You might also want to open the view with NoDataOnLoad which will not require the presence of this tempoeray cursor which is being used in the view.


>Is it possible to have a parametrized view defined like this:
>
>create sql view ndd as select * from ..\nalog\nd where nalog in (?lcspisak)
>
>lcspisak=[000005, 000004]
>use ndd
>
>It gives me only the records where nalog="000005", but none where it's "000004". Has anybody done this properly? Or is it impossible altogether. I've tried stuffing an array for lcSpisak, but it uses only the first element. I've tried several combinations, but none seems to work, except macro substitution, which kind of defeats the whole idea of parametrized views.