BindedParams not recognised

[Ruslan Zasukhin]

On 31/3/07 1:20 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

>>> 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."

>> 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

Aha, I did not notice it is complex query.

Then please add this query and may be small db or just vdb file into Mantis

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]