How to add custom DB SQL Statements in ABL/Native SQL?

Q: How can custom db sql statement be coded? Must the format be OE-like (FOR EACH tabel….) or is there a way to write native MS SQL statements (SELECT field FROM table…)

A: There is no way of running sql statements from within pasoe. The dataserver converts abl statements into sql access, so you'd have to write your access code as an ABL procedure

Home

Documentation

Use Cases

Training

Applications

Release Notes

How to add custom DB SQL Statements in ABL/Native SQL?

Q: How can custom db sql statement be coded? Must the format be OE-like (FOR EACH tabel….) or is there a way to write native MS SQL statements (SELECT field FROM table…)

A: There is no way of running sql statements from within pasoe. The dataserver converts abl statements into sql access, so you'd have to write your access code as an ABL procedure