XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Juan AlfonsoSubject: [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".

The value is there.

Someone knows something about it.

Thanks.

Postnext
Ivan PedruzziSubject: [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?

Could you post the query?

Thank You
Ivan Pedruzzi
Stylus Studio Team

Postnext
Juan AlfonsoSubject: [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 namespace EDS = "http://www-nass.nhtsa.dot.gov/NASS/Schema";
import module namespace edsData="http://www.nass-nhtsa.dot.gov/moduleFunctions" at "edsData.xquery";
import module namespace ddtek-sql = "http://www.datadirect.com/xquery/sql-function" at "sqlfunctions_ora.xq";

declare variable $caseid as xs:decimal external;

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.

Thanks,

PD:
Sorry can you add a Topic to the thread .

Postnext
Ivan PedruzziSubject: [DataDirect][XQuery]No value has been set for external variable
Author: Ivan Pedruzzi
Date: 26 Oct 2006 11:59 AM

Hi Juan,

Could you please try with the latest Stylus Studio version?
http://www.stylusstudio.com/xml_download.html

Thank You
Ivan Pedruzzi
Stylus Studio Team

Postnext
Juan AlfonsoSubject: [DataDirect][XQuery]No value has been set for external variable
Author: Juan Alfonso
Date: 26 Oct 2006 01:21 PM
I don't have 2007, it doesn't allow me to install a trial version.

Postnext
Ivan PedruzziSubject: [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)?

Which XQuery processor are you using?



Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Juan AlfonsoSubject: [DataDirect][XQuery]No value has been set for external variable
Author: Juan Alfonso
Date: 26 Oct 2006 02:55 PM
Build 653g

Postnext
Ivan PedruzziSubject: [DataDirect][XQuery]No value has been set for external variable
Author: Ivan Pedruzzi
Date: 26 Oct 2006 03:22 PM

The processor is obviously "DataDirect XQuery".

We are investigating.

Thank You
Ivan Pedruzzi
Stylus Studio Team

Posttop
Ivan PedruzziSubject: [DataDirect][XQuery]No value has been set for external variable
Author: Ivan Pedruzzi
Date: 26 Oct 2006 04:47 PM
Hi Juan,

We discovered what is causing the problem and is affecting 2007 as well.

The problem will be fixed in the next update.

As a temporary solution please change the path to the module from relative to absolute.

import module namespace edsData="http://www.nass-nhtsa.dot.gov/moduleFunctions" at "file:///c:/mypath/edsData.xquery";

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.