Expand your binds ...with PeopleCode
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.
Jump to specific sections:
00:00 Intro
00:13 Overvierw
01:57 ExpandBindVar()
04:36 ExpandSQLBinds()
08:53 Wrap Up
PeopleTools Tech Tips: https://peopletoolstechtips.com/expan...
Github: https://github.com/PeopleToolsTechTip...
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki
Music: Vlad Gluschenko — Overseas
License: CC BY 3.0: https://creativecommons.org/licenses/...
/ @vladgluschenkomusic