Subject:[DataDirect][XQuery]No value has been set for external variable Author:Juan Alfonso Date:26 Oct 2006 11:21 AM Originally Posted: 25 Oct 2006 02:06 PM
I'm trying to execute Xquery modules using 2006 R3 it looks like was implemented in that version, but is complaining about an external variable not set.
[DataDirect][XQuery]No value has been set for external variable "caseid".
Subject:[DataDirect][XQuery]No value has been set for external variable Author:Ivan Pedruzzi Date:26 Oct 2006 11:21 AM Originally Posted: 25 Oct 2006 06:35 PM
Hi Juan,
What do you mean by "the value is there"?
Do you see the variable and the value in the scenario dialog?
Subject:[DataDirect][XQuery]No value has been set for external variable Author:Juan Alfonso Date:26 Oct 2006 11:22 AM Originally Posted: 26 Oct 2006 09:01 AM
Yes, it is in the scenario.
It is a very extensive Xquery, the prolog is like this:
declare variable $ctUsed as xs:string := "Used";
declare variable $ctUnk as xs:string := "Unk";
declare variable $ctUndef as xs:string := "Undefd";
declare variable $theText as xs:string := "";
declare function EDS:GetPersonInjurySeverity($vehid,$occid)
{
for $in in collection("NASS.INJURY")/INJURY
let $value := substring($in/AISCODES/text() ,7,1)
where $in/CASEID = $caseid and $in/VEHICLEID = $vehid and $in/OCCUPANTID = $occid and $in/RANK = 1 ......................
Yesterday I disabled the modules , I made the functions local, then it recognized the caseid variable, then I put back the code with the modules, then still working , nut when I close stylusStudio the error persists.
Subject:[DataDirect][XQuery]No value has been set for external variable Author:Ivan Pedruzzi Date:26 Oct 2006 02:43 PM
Stylus Studio 2007 can be evaluated side by side with 2006.
The Installation complains only if you have already install 2007 and the the trial is expired.If that's case send an email to stylusstudio@stylusstudio.com with the 2007 activation key and we will grant you an extension.
Which Stylus Studio 2006 build are you running (Help->About)?