>>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.
>
>IN is for use with subqueries. Use INLIST or $ for lists of items...
Does it mean that "in (item1, item2, item3)" is not pure SQL? I've used that instead of InList() just because I'm trying to avoid Fox's internals in SQL - though it may be a long time before I stumble over FoxSQL vs RealSQL compatibility issues.