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

Author: bob k.

Posted: 2011-06-04 at 12:33:02

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: 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/CFDD6374-E239-4696-A37E-CB49B53147A6@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/A656A615BC6F48FC8BCC9DC7BE89CFA1@BobHP

©2011 bob k.