my apologies Ed. Here's the correct text:

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("rakData.sqlite")

>>> crs = cn.cursor()

>>> crs.execute("select * from sqlite_master")

<sqlite3.Cursor object at 0x017C2420>

>>> crs.fetchall()

[(u'table', u'Chemicals', u'Chemicals', 2, u'CREATE TABLE [Chemicals]

(Chemicals

ID integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,ChemicalsName text NOT

NULL

UNIQUE,Active boolean,Notes text)'), (u'index',

u'sqlite_autoindex_Chemicals_1'

, u'Chemicals', 3, None), (u'index', u'sqlite_autoindex_Chemicals_2',

u'Chemical

s', 4, None), (u'table', u'sqlite_sequence', u'sqlite_sequence', 5, u'CREATE

TAB

LE sqlite_sequence(name,seq)')]

>>>

-----Original Message-----

From: Ed Leafe

Sent: Saturday, June 04, 2011 12:39 PM

To: Dabo Users list

Subject: Re: [dabo-users] classDesigner Data Connection not working

On Jun 4, 2011, at 12:33 PM, bob k. wrote:

> 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()

> []

>>>>

So was the 'rakPhoto.sqlite' database file in the current directory? If not,

SQLite will create the database, which would show up as empty, as your last

line does.

-- Ed Leafe

_______________________________________________

Post Messages to: Dabo-users@leafe.com

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/86A71697-52CF-4063-BA5D-D6C014486661@leafe.com

_______________________________________________

Post Messages to: Dabo-users@leafe.com

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/B94C927063074114AB2241B35E37F73D@BobHP