version 2004
PGSQL_ExecuteWithBlob (connID; blobedQuery) Longint
| Parameter | Type | Description | |
| connID | Longint | Connection ID returned by PGSQL_Connect | |
| blobedQuery | Blob | SQL or PL/pgSQL Query As blob | |
| Function result | Longint | Error code (where 0 means no error) |
Description
The PGSQL_ExecuteWithBlob command executes a SQL query passed in a Blob parameter. The main interest of this routine compared to PGSQLExecute is that using a Blob, you can pass queries that contain more than 32 KB of data. If you don't expect to use queries longer than 32 KB, use PGSQL_Execute instead. Returns an error code (Longint) that is used with all commands that work on the query result.
connID is a Longint that corresponds to the connection ID returned by PGSQL_Connect.
blobedQuery is a Blob that corresponds to the SQL or PL/pgSQL Query As Blob.