- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:axmls:printsql

# printSql

##### Syntax

    array printSql (
      optional string $format = 'NONE'
      )

## Description

Returns the last generated current SQL array in printable format.

Call this method to fetch the array of SQL queries resulting from ParseSchema() or ParseSchemaString().

The method returns an array of SQL statements or FALSE if an error occurs. The available options are:

Value | Description
--- | ---
'string' or 'text' | Returns a value formatted for the console
'html' | Returns an HTML formatted string

Any other provided argument returns a PHP array, which can be sent to executeSchema() or executesqlarray

v5/axmls/printsql.txt · Last modified: 2016/01/12 17:26 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top