BindedParams not recognised

bart.pietercil at gmail.com bart.pietercil at gmail.com
Fri Mar 30 08:39:57 CDT 2007


Hi List,

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 ?

TIA

Bart Pietercil


More information about the Valentina mailing list