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