| Allegro CL version 8.2 Unrevised from 8.1 to 8.2. 8.1 version |
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-2016, Franz Inc. Oakland, CA., USA. All rights reserved.
This page was not revised from the 8.1 page.
Created 2010.1.21.
| Allegro CL version 8.2 Unrevised from 8.1 to 8.2. 8.1 version |