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