BindedParams not recognised

[Bart Pietercil]

Hi Ruslan,

On 30-mrt-07, at 21:34, Ruslan Zasukhin wrote:

> On 30/3/07 3:39 PM, "bart.pietercil at gmail.com"  
> <bart.pietercil at gmail.com>
> wrote:
>
> Hi Bart,
>
>> this query
>>
>> SELECT recid,profile_name,
>> COUNT_LINKED(mm_compcard_functprofile,profile_to_compcard_mm) AS
>> 'nr_of_linked_compcards' from funct_profiles WHERE recid IN  
>> (SELECT prof_ptr
>> FROM mm_oc_profiles WHERE recid IN (SELECT mm_ocprofiles_ptr from
>> mm_ocprofiles_users WHERE user_ptr = ?));
>>
>> Binded with an array ={8} ---> verified in the debugger
>>
>> results in an exception:
>>
>> "Using clause required for dynamic parameters."
>>
>> Running the query in VStudio (replacing ? with 8) gives no problem  
>> so I
>> suspect the problem to be with the binded array and the stacking  
>> of the
>> selects
>>
>> Running RB2007r1
>> WIN XP
>> Valentina 2.5.8
>>
>>
>> Any advice ?
>
> We need get confirmation from Ivan,
> It seems in SELECT binding is not supported yet.
> Only INSERT, UPDATE, DELETE

It most definitely IS supported on select (I use it all the time).  
But it seems it is not supported in subselect

Greetz

Bart