Ad Hoc PeopleCode and SQL

Ad Hoc PeopleCode and SQL is a code testing application inside the Application Server. It is useful for implementing code and checking for errors. All SQL run in the window will commit directly to the database, and all PeopleCode written will implement inside the database.

Navigation: Manage GT e Forms 3.x > GT Utilities > Ad Hoc PeopleCode and SQL

Field	Value/Use
Run PeopleCode Button	Executes PeopleCode placed previously in G3UTIL.G3RUN_PC_PB.FieldChange in Application Designer
SQL Text	User can enter SQL commands to be executed on the database
Run SQL	Commits all SQL commands written in SQL Text field
SQL Results	Returns result from SQL when Run
Save	Commits changes to the database but does not work unless SQL code changed or updated and is correct
Notify	After saving data on the field opens link to share changes

Error Messages are built into the software to prompt and direct users to correct and properly execute SQL.