Newbie web app developer: data validation

[phabio]

Hi all,
linked to this post https://www.lianja.com/community/sho...st-data-access, I'm tryng to create some test app for my new ERP.

My first question is:
I can use function like (keylookup('pdc', 'conto', '{}', true, false)) on FormItem data validation?
I think no.. this is Lianja/VFP..

But I can use this code on column data validation into the DB.. right?

thanks
Fabio

[barrymavin]

Hi Fabio,

Right click on the browser window and inspect it.

Select the console.

Type expressions and look at the results.

keyLookup() is there as is sqlLookup().

Javascript is case sensitive.

Any expressions that cannot be evaluated on the client are evaluated on the server. So you can call your own functions on the server.

https://www.lianja.com/doc/index.php/Data_Validation

[phabio]

Thanks Barry.

this work!

keylookup("semdata!pdc", "conto", "20/01/EMMB", "true", "false")!="false"

Fabio

[phabio]

work on the Inspector, but not work as a data validation.

On the FormItem, I've wryte:
keylookup("semdata!pdc", "conto", "{}", "true", "false")!="false"

but on the preview, the record are not updated... without error.

thanks
Fabio

[barrymavin]

Try single quotes and learn how to see what network requests are made to see any possible errors.

[phabio]

I don't know where to search any error..

on the inspector:
keylookup('semdata!caucont', 'C_CAUCONT', 'IFAC', 'true', 'false')!='false'
return true..

keylookup('semdata!caucont', 'C_CAUCONT', 'XXXXXXXX', 'true', 'false')!='false'
return true.. but it's wrong..

I'm confused (and ignorant).

[phabio]

Ok, on the debug window, I see something


but why the string are without quotes?

[phabio]

found.. I need to wryte:
keylookup('semdata!caucont', 'C_CAUCONT', "'{}'", 'true', 'false')!='false'

but this work on the inspector, don't work on the Lianha App Builder and don't work on the Lianja Web App View

[barrymavin]

You still have it in double quotes.

[phabio]

I've try with single and double..