Problem with sqlite3 cursor and imbricated for loop

[Charles V.]

Hi,

Thank for replying.

> Either use a second cursor OR ensure you fetch all the data from the
> first .execute() first:

Are these really the only solutions ? I was expecting the same behavior than 
MySQLdb module, which is, as sqlite3, DB-API 2.0 compatible.

It means a program written for MySQLdb won't be compatible with sqlite3 (even 
if I am using standard SQL). In fact I don't really understand why the 
iterator isn't in some way "encapsulated". Does anybody tried to implemented 
this functionality ?

Cheers,

Charles