Page 1 of 1

Database Driving Auto Complete Selection

Posted: Tue Aug 10, 2010 3:28 pm
by devinst
I am trying to use a field that has been definded on a previous screen as part of the selection criteria for a auto complete field. The company number is selected on the first screen. The second screen allows selection of a driver code. The driver master contains records for multiple companies so I only want to show drivers for the company that was selected. I tried using 'DRACPY = R1CPYNO' in the choices selection criteria but it does not offer any suggestions when ran. If I change it to a hard coded value, such as 'DRACPY = 1', this works fine. Does ProundUI allow using of fields in the selction criteria?

Re: Database Driving Auto Complete Selection

Posted: Wed Aug 11, 2010 12:36 am
by Alex
The entire selection criteria property must be built with RPG code. For example, the property can be bound to a character field named CRITERIA.

Then, in the RPG code, use the following:

CRITERIA = 'DRACPY = ' + %Char(R1CPYNO);