Database Driving Auto Complete Selection

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
devinst
Profound User
Posts: 80
Joined: Mon Apr 20, 2009 11:26 am
First Name: Devin
Last Name: St. Germain
Company Name: Dupre Logistics, LLC
Phone: 337.314.2259
Address 1: 201 Energy Pkwy. Ste. 500
City: Lafayette
State / Province: Louisiana
Zip / Postal Code: 70508
Country: United States
Contact:

Database Driving Auto Complete Selection

Post 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?
User avatar
Alex
Profound Logic Staff Member
Posts: 233
Joined: Fri Jan 04, 2008 12:10 pm
First Name: Alex
Last Name: Roytman
Company Name: Profound Logic Software
Contact:

Re: Database Driving Auto Complete Selection

Post 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);
Post Reply

Who is online

Users browsing this forum: Esdale and 1 guest