> Oh, and don't forget the c.commit() part! That had me running around
> in circles all night last night.

Yep, I got got with lack of commit syndrome when I started with SQL
too :-)

> PS Anyone know if there's a way to get a list of tables in a DB?
I've
> got the pragma to get a list of columns in a table, but just in the
> off chance...

Irs very DB dependant. Standard SQL doesn't have such thing but
most DB systems provide commands to do so, but they are different
for each DB.

Often there is a "meta table" somewhere that stores the details of
the data structure and you can queruy that like any other. In other
cases it is special SQL keywords... or mixture of both...

Check the doxcumentation carefully.

Alan G.

_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor

Reply via email to