PT3-E033_Expanding_Binds

Using PeopleCode to Expand Binds

PeopleTools Tech Tips
Randy Groncki

2023-02-26

PeopleCode has two little gem functions that expand binds: ExpandBindVar and ExpandSqlBinds.

At first glance, these two functions look similar. A cursory glance at PeopleBooks show that they both expand binds in strings. Even the parameter list is the same (not). But they are used is two very different situations and are not interchangeable.

Install

Import project into PeopleSoft Demo Environment Grand Role X_PT3 to user profile

Web Posting: https://peopletoolstechtips.com/expand-your-binds-with-peoplecode/

YouTube demo: https://youtu.be/kmAlJ1KI39o

Contact:

• randy@peopletoolstechtips.com
• PeopleToolsTechTips@Gmail.com

This file contains all the objects referenced in the video and document.

PeopleTools Project is using PeopleTools 8.59.12

• This contains all the components, pages, records and PeopleCode used in the demonstration.

• The target database must be minimal 8.58 PeopleTools

• X_PT3_E033_EXPAND_BINDS (folder - PeopleTools Project)

• X_PT3_E033_EXPAND_BINDS.zip (All Objects)