Javascript exception

Question

Question

Marco Blom · Mar 25, 2017

Hi community,

I do not understand why I get a 'javaScript exception'?

Purpose is to search for a [Country] based upon a [Code] as search parameter.

this is my code:

<hgroup>
<text id="CountryID" name="Code" label="Code" size ="8" />
<spacer width="5"/>
<text id="CountryName" name="CName" label="Country" size ="24" />
</hgroup>
<spacer height="5"/>
<button caption="Search" onclick="zenPage.searchValue();"/>

</page>
}

ClientMethod searchValue() [ Language = javascript ]
{
var ctrl = zen('CountryID');
tVar = ctrl.getValue();
alert (tVar); ///test-show text value
zenPage.sqlTest(tVar);
}

Method sqlTest(tVar) [ ZenMethod ]
{
SET InVal = tVar
   &sql(SELECT Countrie
        INTO :OutVal
        FROM ZenCrm_Data.Countries
        WHERE CountrieCode=:InVal)
   IF SQLCODE'=0 { SET OutVal="?"
      IF OutVal="?" {
      WRITE !,"No data returned"
      WRITE !,"SQL error code ",SQLCODE } }
   ELSE {
   WRITE !,"Name is: ",OutVal}
}

Does the method needs a 'Return' statement ore something?

Can somebody explain please? this might help me with other programming issue's to!

Thanks in advance,

Discussion (9)0

Log in or sign up to continue

Andrei Luiz Nenevê · May 15, 2017

Hi Marco,

You can do with QUIT, to take back the value in javascript and work with it:

ClientMethod searchValue() [ Language = javascript ]
{
var ctrl = zen('CountryID');
tVar = ctrl.getValue();
alert (tVar); ///test-show text value

///example
name = zenPage.sqlTest(tVar);

zen('CountryName').setValue(name);
}

Method sqlTest(tVar) [ ZenMethod ]
{
SET InVal = tVar
   &sql(SELECT Countrie
        INTO :OutVal
        FROM ZenCrm_Data.Countries
        WHERE CountrieCode=:InVal)
   QUIT:SQLCODE'=0 "No data returned! \n SQL error code "_SQLCODE
   QUIT "Name is = "_OutVal
}

0 0

score 1 · Answer 1 · 2017-03-25T12:11:41-04:00

Eduard Lebedyuk · Mar 25, 2017

Try commenting out all write statements in sqlTest method.

1 0

score 0 · Answer 2 · 2017-03-25T13:23:08-04:00

Thank you Eduard!

Now it works. This is the code:

My only comment is that the -not working- code a (100%) sample is from the documentation, which makes it sometimes confusing...

Thanks.

score 0 · Answer 3 · 2017-03-25T13:32:05-04:00

Eduard Lebedyuk · Mar 25, 2017

Where exactly in samples?

0 0

score 0 · Answer 4 · 2017-03-25T13:50:24-04:00

This was the code snippet I have used:

I am now looking how the get a "No data returned" message into my Form

score 0 · Answer 5 · 2017-03-25T14:00:52-04:00

It's a valid sample. You just can't write directly into ZEN context. Well, you can, obviously, but that causes errors.

score 0 · Answer 6 · 2017-05-13T11:07:57-04:00

I would like to return a "No Data message" but why does the write statement not work?,

while the documentation is full of examples with the statement in it?

score 0 · Answer 7 · 2017-05-14T15:53:00-04:00

Write statement does what it's name implies - outputs characters into a current device. It's a way to go if you're working from a terminal, but ZEN does it's own device management, so writing into a current device interferes with ZEN also writing into current device, which causes an error.

To make it work check if there's no data (SQLCODE=100) and set OutVal to empty (or error message) and work with that on a client.

score 1 · Answer 8 · 2017-03-25T14:02:16-04:00

Eduard Lebedyuk · Mar 25, 2017

SQLCODE=100

would be a codepath for no data.

1 0