PGSQL_ExecuteWithBlob

4D - Documentation   Français   English   German   4D For PostgreSQL, Command Theme List   4D For PostgreSQL, Command Alphabetical List   Back   Previous   Next

version 2004


PGSQL_ExecuteWithBlob (connID; blobedQuery) Longint

ParameterTypeDescription
connIDLongintConnection ID returned by PGSQL_Connect
blobedQueryBlobSQL or PL/pgSQL Query As blob
Function resultLongintError 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.


4D - Documentation   Français   English   German   4D For PostgreSQL, Command Theme List   4D For PostgreSQL, Command Alphabetical List   Back   Previous   Next