if i have a user defined field in Invoice header called U_Test, and if I need to read it using a query (to be used on a formatted search).
I am not quite sure of the syntax. can anyone help please?
I tried
$[$U_Test.0.0] which is the accepted way with fields with numerical ids such as $[$8.0.0] etc.
appreciate any help,
Indika.
Hi!
You should use Table.Field notation. In your case it'll probably be <b>SELECT OINV.U_Test</b>...
I suppose you are going to implement an universal query for all the forms, but... tehere is no trick for that issue, you have to develop unique query for every form.
Hope, it helps
Add a comment