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/02/21 19:09 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki