BindedParams not recognised

[Ruslan Zasukhin]

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

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