Maple Professional
Maple Academic
Maple Student Edition
Maple Personal Edition
Maple Player
Maple Player for iPad
MapleSim Professional
MapleSim Academic
Maple T.A. - Testing & Assessment
Maple T.A. MAA Placement Test Suite
Möbius - Online Courseware
Machine Design / Industrial Automation
Aerospace
Vehicle Engineering
Robotics
Power Industries
System Simulation and Analysis
Model development for HIL
Plant Modeling for Control Design
Robotics/Motion Control/Mechatronics
Other Application Areas
Mathematics Education
Engineering Education
High Schools & Two-Year Colleges
Testing & Assessment
Students
Financial Modeling
Operations Research
High Performance Computing
Physics
Live Webinars
Recorded Webinars
Upcoming Events
MaplePrimes
Maplesoft Blog
Maplesoft Membership
Maple Ambassador Program
MapleCloud
Technical Whitepapers
E-Mail Newsletters
Maple Books
Math Matters
Application Center
MapleSim Model Gallery
User Case Studies
Exploring Engineering Fundamentals
Teaching Concepts with Maple
Maplesoft Welcome Center
Teacher Resource Center
Student Help Center
PreparedStatement:-GetOptions - get options of a PreparedStatement module
Calling Sequence
preparedstat:-GetOptions( opts )
Parameters
preparedstat
-
PreparedStatement module
opts
(optional) name; the option to get, one of timeout, maxrows, or maxfieldsize
Description
GetOptions gets the values of options that affect the behavior of preparedstat.
All the options that can be read with GetOptions can be set by calls to SetOptions or when the PreparedStatement is created by CreateStatement.
An option's current value can be set by calling SetOptions.
GetOptions recognizes the following options
timeout
the number of seconds preparedstat waits for a query to execute. If the limit is exceeded, an error is raised.
maxrows
the maximum number of rows a query returns. If there are more than maxrows rows in the database that match the query, the extra rows are dropped.
maxfieldsize
the maximum number of bytes a field of type BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR will use. If a field needs more than this, it is truncated.
Calling GetOptions with no arguments returns the current values of all the arguments that GetOptions can query.
Examples
See Also
Database, Database[Connection], Database[Connection][CreateStatement], Database[PreparedStatement], Database[PreparedStatement][SetOptions], Database[usage]
Download Help Document