Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Bob>cd\
C:\>cd photography
C:\Photography>cd software
C:\Photography\Software>cd dabo
C:\Photography\Software\dabo>c:\python27\python
Python 2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]
on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> cn = sqlite3.connect("rakPhoto.sqlite")
>>> crs = cn.cursor()
>>> crs.execute("select * from sqlite_master")
<sqlite3.Cursor object at 0x01802420>
>>> crs.fetchall()
[]
>>>
-----Original Message-----
From: Ed Leafe
Sent: Saturday, June 04, 2011 11:59 AM
To: Dabo Users list
Subject: Re: [dabo-users] classDesigner Data Connection not working
On Jun 3, 2011, at 8:38 AM, Bob K. wrote:
> The database was created with SQLiteManager. The database connection test
> ran successfully, so I assumed it was good.
>
> I'm very new to python. what is the quickest way for me to test the
> database?
Here is an example of a Python session that should do the trick:
http://dabo.codepad.org/5LIrndI2
It's doing the basics of what the code that caused the exception was doing.
Let me know what error message, if any, you get when you run it.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/A656A615BC6F48FC8BCC9DC7BE89CFA1@BobHP
