Data validation

[phabio]

Hi,
I'm try this code:
(iif(keylookup("categories", "CATEGORYID", {}, "found", "notfound"))="found", true, false)

into the Validation attribute of CATEGORYID column of Products table.

but don't work.. return always "false"

How can I test the typed value?

thanks
Fabio

[barrymavin]

JavaScript = is an assignment operator. Use ==

[barrymavin]

JavaScript = is an assignment operator. Use ==

keylookup("categories", "CATEGORYID", {}, true, false)

[phabio]

Hi Barry,
don't work..
I'm tryng directly on the column validation.. I open the Product table with "double click" and edit the record on browse window.

[barrymavin]

That’s because you are jumping around changing what you are doing. Browse is just for looking at the data. Go try it in your original tests with a formitem.

if you ask a question or make a statement about something not working because always return “false” which I explained. Why do you then ignore the reply and try something else which is unrelated.

Follow the reply to your original post.

[phabio]

Hi Barry, I'm following the suggestion to use the data validation on the table..
I'm tryng to create a double data validation:
the first on the formitem, the second, on the table.

I want to prevent a wrong data input also if comeone try to update the record throug ODBC.

[barrymavin]

Phabio,

You asked this question last week and I answered you.

What do you think {} is to the database engine? This is a UI specific notation to substitute the current text in a formitem.

That validation is handled internally by the database engine.

Try it it in a form section. Not in browse.

If if you want it in the database engine you need to specify the column name not {} although I suppose the engine could recognize {} to simplify it for you.

Submit an ER.

[phabio]

Hi Barry,
no no... the field name it's ok.

On the doc I've not found any sample..
I've this with "this" and "this.value".. :-)
but not with che column name.. :-)

(keylookup("categories", "CATEGORYID", products.categoryid, true, false))

Work fine!

sorry for the mistakes.

the next week I'm back to Bologna.. my Lasagna is waiting for you.

Fabio