FunctionPackage: dbiToCDocOverviewCGDocRelNotesFAQIndexPermutedIndex
Allegro CL version 9.0
Unrevised from 8.2 to 9.0.
8.2 version

run-prepared-sql

Arguments: &key db hstmt row-count width types

Execute the sql statement that was last prepared via prepare-sql. The prepared sql statement is associated with the statement handle.

If statement handle hstmt is true then it is used for the conversation with its associated database. Otherwise if db is true then it is the database on which the sql statement will be run. If db is also nil then the database used is the one that is the value of *default-database*.

width is the size for character buffers used in retrieving character-valued fields. If not given, then the width for the database, db-width, is used.

types should be either the keyword :auto or a list of type specifiers from the following table. The value :auto means that the types will be determined automatically from the query results.

Specifier Meaning
:int return as a 4 byte signed value
:long return as a 4 byte signed value
:double return as an 8 byte floating point value
t return as a string or nil for the null value (the default)

If the sql statement is parameterized then values for all of the parameters must be bound before the statement is executed.

The returned values are the same as for the sql function and are documented in sql's description.

See aodbc.htm for more information on Allegro ODBC.


Copyright (c) 1998-2019, Franz Inc. Oakland, CA., USA. All rights reserved.
This page was not revised from the 8.2 page.
Created 2012.5.30.

ToCDocOverviewCGDocRelNotesFAQIndexPermutedIndex
Allegro CL version 9.0
Unrevised from 8.2 to 9.0.
8.2 version