Newbie web app developer: data validation

[phabio]

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

but I want to insert the validate on the section formitem... not in the table column...

[barrymavin]

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..

Yes I have a good idea what validation is used for.

What I was trying to explain to you is that Lianja.evaluate() has no clue what {} is.

When you specify {} in the validation expression for a formitem, the framework knows what formitem is associated with {} and it can then substitute the current input text value.

{} is primarily used to substitute the current value associated with a UI element. In certain cases e,g Data Mapping on the server it is used to substitute current table.column value.

[yvonne.milne]

Yes, that's what I meant. Put it in the validation attribute for the field in the Form Section.

[barrymavin]

You are getting yourself really confused. You asked about how to do this using keylookup() which my response was replying to then you did it using Lianja.evaluate()... different code.

[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

Why are you escaping this with Lianja.evaluate()? Nobody told you to do that.

[barrymavin]

Why are you escaping this with Lianja.evaluate()? Nobody told you to do that.

Apart from that the last quote is mistyped.

[phabio]

Yes Barry, true...
but the subject is: DataValidation.. :-)

in the first, I've try with rlookup, keylookup.. sqllookup..

then, I've thinked about a more complex test.. and now the reale focus is on the
Lianja.evaluate("mylib::mylibproc('\'{}'\')")

if is possible.. good.
else.. I need to found other way.. or back to desktop App.. :-(

[barrymavin]

Try reading the replies and following what is said.

Don’t imply validation doesn’t work in web apps. That’s just not the case. You are struggling to get the javascript syntax right with substitution of values that get executed in the server.

Furthermore you asked on tickets, were replied to then proceeded to have real time response on the forums at 9:30pm my local time.

As usual I will put a small example together for you that you can copy and study. Tomorrow.

[phabio]

thanks
Fabio

[phabio]

My goal is:
use a Web App as a front end, with a minumum JavaScript code and delegate to a server Lianja/VFP procedure all the code..

If possible.. :-)

thanks
Fabio