ColumnCount - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : SQLite : Database/SQLite/ColumnCount

Database[SQLite]

  

ColumnCount

  

get number of columns in a prepared statement

 

Calling Sequence

Parameters

Description

Examples

Compatibility

Calling Sequence

ColumnCount( statement )

Parameters

statement

-

prepared SQL statement obtained using the Prepare command

Description

• 

The ColumnCount command returns the number of columns in a prepared statement.

Examples

withDatabaseSQLite:

dbFileToolsJoinPathkerneloptsdatadir,SQLite,G20-Population.db:

connectionOpendb:

Select all data from table - prepare statement

stmtPrepareconnection,SELECT * FROM population

stmtSQLite statement,SELECT * FROM population

(1)

Number of columns

ColumnCountstmt

21

(2)

Fetch all rows

FetchAllstmt

1960-12-311.80671000×1086.67070000×1089.2500572×1077.2814900×1074.6637746×1077.2775883×1075.2400000×1075.0199700×1071.19897000×1081961-12-311.83691000×1086.60330000×1089.4943000×1077.3377632×1074.7293811×1077.4988037×1075.2800000×1075.0536350×1071.21236340900000006×1081962-12-311.86538000×1086.65770000×1089.5832000×1077.4025784×1074.7990159×1077.7286629×1075.3250000×1075.0879450×1071.22590643400000006×1081963-12-311.89242000×1086.82335000×1089.6812000×1077.4714353×1074.8697015×1077.9643017×1075.3650000×1075.1252000×1071.23960074400000006×1081964-12-311.91889000×1086.98355000×1089.7826000×1077.5318337×1074.9361165×1078.2017016×1075.4000000×1075.1675350×1071.25344802900000006×1081965-12-311.94303000×1087.15185000×1089.8883000×1077.5963695×1074.9945471×1078.4379369×1075.4348050×1075.2112350×1071.26745000×1081966-12-311.96560000×1087.35400000×1089.9790000×1077.6600311×1075.0430631×1078.6721875×1075.4648500×1075.2519000×1071.27468492900000006×1081967-12-311.98712000×1087.54550000×1081.00725000×1087.6951336×1075.0829214×1078.9052356×1075.4943600×1075.2900500×1071.28196115799999997×1081968-12-312.00706000×1087.74510000×1081.01061000×1087.7294314×1075.1175036×1079.1377490×1075.5211700×1075.3235750×1071.28927892099999994×1081969-12-312.02677000×1087.96025000×1081.03172000×1087.7909682×1075.1518731×1079.3709914×1075.5441750×1075.3537950×1071.29663845500000000×10853 × 21 Matrix

(3)

Finalizestmt:

Closeconnection:

Compatibility

• 

The Database[SQLite][ColumnCount] command was introduced in Maple 18.

• 

For more information on Maple 18 changes, see Updates in Maple 18.