lookup on web

[jefferson@results.com.br]

How I can use RLOOKUP() on Web/Mobile?

Regards,

[yvonne.milne]

Hi Jefferson,

Use KEYLOOKUP() or SQLLOOKUP().

Regards,

Yvonne

[jefferson@results.com.br]

What is the best way to define validation on the table?

[yvonne.milne]

Hi Jefferson,

What are your concerns?

Regards,

Yvonne

[jefferson@results.com.br]

Hi Yvonne,
I liked set only an instruction on database dictionary to validate on database and client. Because on database I need use the field name as expression and macro {} on client.
Examples
To database
KEYLOOKUP(<table>, <"indextagname">, <table.field>, <.t.> , <.f.> )
To client
KEYLOOKUP(<table>, <"indextagname">, {}, <.t.> , <.f.> )

[yvonne.milne]

Hi Jefferson,

I believe you should be able to use the {} or "{}" (for character) for both desktop and web. I have submitted a ticket as in my tests this is working when defined in the Field Attribute, but not when defined in the table dictionary.

Regards,

Yvonne