Tech Tip: SQL access to 4D Record Number
PRODUCT: 4D | VERSION: 17 | PLATFORM: Mac & Win
Published On: September 25, 2019
When using SQL calls to 4D's tables, it is possible to access the 4D Record Number through the virtual field __ROW_ID.
For example:
| Begin SQL SELECT * FROM Table_1 WHERE __ROW_ID > 0 End SQL |