Spaces
Apps
Templates
Create
Profound Logic Documentation
All content
Space settings
Content
Results will update as you type.
•
Profound Logic - Product Support Policy
Profound AppDev
Profound UI
Profound.js
•
Profound.js Overview
Installation
Getting Started with Profound.js
Using Low Code
Profound.js Framework
Visual Designer for Profound.js
•
Strongly typed fields
Promises
•
Fibers
•
Hot module reloading
•
Error reporting and logging
•
Passing parameters to an initial module
Profound.js Connector
Profound.js Coding Reference
Profound.js API List
Array API
Call API
Data Area API
Data Conversion API
Data Structure API
Date/Time API
Declaration/Initialization API
Encryption API
Error Handling API
Information/Logging API
Number API
Memory Management API
Printer File API
Record Level Access API
SQL API
Data API
•
pjs.allocStmt()
•
pjs.bindParameters()
•
pjs.close()
•
pjs.getConnection()
•
pjs.getDB()
•
pjs.getRemoteDB()
•
pjs.escapeString()
•
pjs.execute()
•
pjs.executeDirect()
•
pjs.getSQLOption()
•
pjs.setConnectAttr()
•
pjs.query()
•
pjs.parallelQueries()
•
pjs.setSQLOption()
•
pjs.setStmtAttr()
•
pjs.prepare()
•
pjs.connect()
•
pjs.disconnect()
•
pjs.sqlHelper
•
SQL Diagnostics
SQL Examples
SQL Fetch API
•
pjs.fetch()
•
pjs.fetchFirst()
•
pjs.fetchLast()
•
pjs.fetchNext()
•
pjs.fetchPrior()
•
pjs.fetchAbsolute()
•
pjs.fetchRelative()
•
pjs.rowCount()
•
pjs.hasMoreRows()
•
statement.endOfData()
String API
User Interface API
Server Management API
IFS API
Miscellaneous PJS APIs
Profound.js Constants
Profound.js Directives
•
Profound.js Intellisense
Profound.js Reserved Words
•
Server-side Typescript
•
Profound.js Function Handling
•
Handling Session Ending in PJS Modules
•
Profound.js Server performance
•
Profound.js performance logging
•
File Encryption
Decimal Arithmetic
Troubleshooting
PJS tips
Profound API
Profound AI
Profound Installer
You‘re viewing this with anonymous access, so some content might be blocked.
Close
Profound Logic Documentation
/
SQL Fetch API
SQL Fetch API
Alex Roytman
Jessica Tomkins
Owned by
Alex Roytman
Last updated:
Aug 16, 2023
by
Jessica Tomkins
Loading data...
{"serverDuration": 36, "requestCorrelationId": "87811dec659e44cb82f3abb968c49bdf"}