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
Connection:-CreateStatement - create a statement module
Calling Sequence
connection:-CreateStatement(opts)
Parameters
connection
-
Connection module
opts
(optional) equations of the form option=integer where option is one of timeout, maxrows or maxfieldsize
Description
CreateStatement opens a Statement module. This Statement module can be used to send arbitrary SQL statements to the database.
CreateStatement accepts as optional arguments the same options that can be set with Statement:-SetOptions.
timeout = integer
The number of seconds the client waits for a response from the database.
maxrows = integer
The maximum number of rows a query returns.
maxfieldsize = integer
The maximum number of bytes that a column uses to store character or binary data. This only applies to columns of type BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR. If the limit is exceeded then the extra data is ignored.
Examples
Create a statement with no options specified.
Create statements with various options.
See Also
Database, Database[Connection], Database[Connection][CreatePreparedStatement], Database[Connection][ExecuteQuery], Database[Connection][ExecuteUpdate], Database[PreparedStatement], Database[Statement], Database[usage]
Download Help Document
