cursor.md

cursor

cursor Object

An object representing an ODBC cursor.

Methods

• close

  Closes the cursor 

• execute

  Execute some SQL 

• fetchone

  Fetch one row of data 

• fetchmany

  Fetch many rows of data 

• fetchall

  Fetch all the rows of data 

• setinputsizes

   

• setoutputsize

   

cursor.close

close() Closes the cursor

Comments

This method does nothing!! I presume it should!?!?!

cursor.execute

int = execute(sql, [var, ...]

) Execute some SQL

Parameters

• sql : string

  The SQL to execute

• [var, ...]=[] : sequence

  Input variables.

cursor.fetchall

[data, ...] = fetchall() Fetch all rows of data

cursor.fetchmany

[data, ...] = fetchmany() Fetch many rows of data

cursor.fetchone

data = fetchone() Fetch one row of data

cursor.setinputsizes

setinputsizes()

cursor.setoutputsize

setoutputsize()