GPAL
  • Concepts
  • Tutorials
  • Library
  • Endpoints
  • API
  • OttoMagic
  • Services
v1.0.0
Library
  • AI
  • Application
  • Base64Helper
  • Browser
  • Converter
  • Credentials
  • Database
  • Excel
  • File
  • Form
  • Gherkin
  • GoogleDorking
  • GoogleDrive
  • GoogleSheets
  • Grid
  • ImageHelper
  • Launcher
  • Logger
  • Mail
  • PuppeteerClient
  • RESTClient
  • Selector
  • Url

Database

  • Column Definitions
  • Connection Configuration
  • CRUD Operations
  • Parameters
  • Query Configuration
  • Retrieving Results
  • Transactions

Library

Column Definitions

Methods for defining the data type and properties of database columns when using GPAL to create tables or define schema.

Connection Configuration

Methods for configuring the database connection - either via a full connection string or by setting server name, database name, username, and password individually.

CRUD Operations

Methods for reading, creating, updating, and deleting database records, and for executing arbitrary SQL commands.

Parameters

Methods for passing parameter values to SQL commands and stored procedures, and for using a grid as the parameter source.

Query Configuration

Methods for specifying the SQL query, stored procedure, or table name that a database operation runs against.

Retrieving Results

Methods for capturing query results as a DataTable, an IGPALGrid, or via the Tokens property for debugging.

Transactions

Methods for wrapping multiple database operations in a single transaction with commit and rollback support.

On this page


Library
Column Definitions
Connection Configuration
CRUD Operations
Parameters
Query Configuration
Retrieving Results
Transactions

GPAL

Generally Positive Automation Library

Get Started Library Desktop Viewer

Learn More

Contact Us

GPAL License

About GPAL

FAQs


Bug Reports

Report a bug


Software Decisions Inc © 2026 Copyright
X