User Tools

Site Tools


tech:psoft:psquery_to_sql

Build SQL from PSQueries

See “QRY_SQL.Activate() Page PeopleCode”

Declare Function
Declare Function WriteQueryToApi PeopleCode QRYFUNCTIONs.QRYQUERYFUNCS FieldFormula;

Local ApiObject &aQuery;
Local number &x;

&aQuery = %Session.GetQuery();
&x = &aQuery.create(<xxxxx>, False, 1, "", "");
WriteQueryToApi(&aQuery);
&string = String(&aQuery.SQL);
&aQuery.Close();
tech/psoft/psquery_to_sql.txt · Last modified: 2024/06/21 12:04 by 127.0.0.1