python - Iterating over PyoDBC result without fetchall() -


i'm trying process large query pyodbc , need iterate on rows without loading them @ once fetchall().

is there , principled way this?

sure - use while loop fetchone.

http://code.google.com/p/pyodbc/wiki/cursor#fetchone

row = cursor.fetchone() while row not none:     #     row = cursor.fetchone() 

Comments

Popular posts from this blog

How to mention the localhost in android -

php - Calling a template part from a post -

c# - String.format() DateTime With Arabic culture -