Newbie web app developer: data validation

[barrymavin]

It’s to do with how you are quoting the arguments. I’ll look at it tomorrow. You can quote ‘ by specifying it twice e.g ‘’.

[phabio]

Ok, I've create a simple APP, Javascript, based on SouthWind
I've a section, based on Orders table
I've created a index on customers table
Index on customerid tag customerid

on the customer formfield I've add a validation:
keylookup('southwind!customers', 'customerid', "'{}'", 'true', 'false')!='false'

this work on App Builder but not on Web Preview.

but work on app inspector if I put a value
keylookup('southwind!customers', 'customerid', "WILMK", 'true', 'false')!='false'

I've try with single and double quotes

it's impossible to save the edited records.

[phabio]

Can I use:
Lianja.evaluate("mylib::mylibproc('{}')") ?

[yvonne.milne]

Hi Fabio,

There are too many quotes around the {}. It should be:

keylookup('southwind!customers', 'customerid', '{}', 'true', 'false')!='false'

Regards,

Yvonne

[phabio]

Hi Yvonne,
your sample don't work on web preview.

[barrymavin]

Can I use:
Lianja.evaluate("mylib::mylibproc('{}')") ?

Fabio,

Tell me what you think {} is substituted for. Then maybe you can answer your own question.

[barrymavin]

Ok Fabio.

you need to double the single quotes around the {} as keylookup() is a built-in function that will proxy a call to keylookup on the server.

You are not enclosing {} in quotes to the server.

‘\’{}’\’

That should properly enclose the value substituted for {} and it will be sent as ‘WILMK’

[phabio]

Fabio,

Tell me what you think {} is substituted for. Then maybe you can answer your own question.

Hi Barry,
this is to use a custom validate code.
for example:
you're insert a sales order for cusromer "WILMK"; this code it's right.. but the customer are suspended cause have a not payed invoice..

[yvonne.milne]

Hi Yvonne,
your sample don't work on web preview.

Hi Fabio,

Yes, it does. Put it in the field's validation attribute as you said you were doing in your test App.

Regards,

Yvonne

[phabio]

i've updated the Validate:
Lianja.evaluate("mylib::mylibproc('\'{}'\')")

but I got the error:
mar giu 12 16:24:40 2018
**** Lianja error ****
mylibproc('\'WILML'\')
^
')' was expected

mar giu 12 16:24:40 2018
**** Lianja error ****
Lianja.evaluate("mylib::mylibproc('\'WILML'\')")
^
METHOD 'EVALUATE' not found