Apologies if this answer is already posted elsewhere - a search didn't answer my question.
Basically I need to pre-populate some sqlite tables used with my web2py app with a fair amount of data. Would like to run some scripts that performs this task via conventional pythonwin IDE. Thus far connect, execute and so forth but updates don't take. Clearly I'm missing something here - any insights/suggestions would be appreciated. Thanks in advance Bill