Database[SQLite] - Maple Programming Help

Online Help

All Products    Maple    MapleSim


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

Database[SQLite]

  

ColumnNames

  

get names of columns in prepared statement

 

Calling Sequence

Parameters

Description

Examples

Compatibility

Calling Sequence

ColumnNames( statement )

Parameters

statement

-

prepared statement obtained using Prepare command

Description

• 

The ColumnNames command returns names of columns in prepared statement.

Examples

withDatabaseSQLite

Attach,Bind,ClearBindings,Close,ColumnCount,ColumnNames,Execute,Fetch,FetchAll,FetchRow,Finalize,Open,Opened,Prepare,RESULT_BUSY,RESULT_DONE,RESULT_ROW,Reset,Step

(1)

dbFileToolsJoinPathkernelopts'datadir',SQLite,G20-Population.db:

connectionOpendb:

Select all data from table - prepare statement

stmtPrepareconnection,SELECT * FROM population

stmtSQLite statement,SELECT * FROM population

(2)

Number of columns

ColumnNamesstmt

Date,USA,CHN,JPN,DEU,FRA,BRA,GBR,ITA,RUS,IND,CAN,AUS,ESP,MEX,KOR,IDN,TUR,SAU,ARG,ZAF

(3)

Fetch all rows

FetchAllstmt

(4)

Finalizestmt:

Closeconnection:

Compatibility

• 

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

• 

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