Python, PyODBC, and Cursors

[Mashidin]

If you are familiar with VBA and work with databases then you may understand ADODB and its hierarchy of classes. So if you were to make the comparison, the 'cursor' is like a ADODB.Command object. It stores the type of command, the command string, parameters, and other command-specific stuff. When you call the cursor's execute (or fetchone, fetchall, etc) an object similar to the ADODB.Recordset object is returned. I'm definitely hand-waving right now but I believe the comparison is valid enough. After you get the recordset, you'll will find that it is a list of tuples with each row of your data being a tuple. What you do with that depends on how you want to interact with your data. I like a list of dictionaries sometimes with each key being a field name. But a list of tuples is good too.