Database Driving Auto Complete Selection
-
- 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
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?
- 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
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);
Then, in the RPG code, use the following:
CRITERIA = 'DRACPY = ' + %Char(R1CPYNO);
Who is online
Users browsing this forum: Esdale and 1 guest