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 ‘’.
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 ‘’.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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.
Can I use:
Lianja.evaluate("mylib::mylibproc('{}')") ?
Hi Fabio,
There are too many quotes around the {}. It should be:
Regards,Code:keylookup('southwind!customers', 'customerid', '{}', 'true', 'false')!='false'
Yvonne
Hi Yvonne,
your sample don't work on web preview.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/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’
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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
Bookmarks