Notices

I downloaded Python 2.5 runtime using the app manager. I am using Diablo but have all the Chinook repositories as well.

Got it, by turning off the Chinook repositories and just going with the Diablo ones.

Now problem is I have an sqlite3 db in my MyDocs/.documents folder
When I try to save settings, I get

Unable to set settings
OperationalError('attempt to write a readonly database')

If I go using Open Database icon in the Databases tab, I get

Error in AddToStat

I can then see the tables in the Databases tab, but not the sqlite database name itself, nor can I view data.

I 'fixed' it by uninstalling and re-installing again.

Thank you again for great app!

I just reinstalled release 0.6 - did we lose the ability to sort by clicking on column heading?

Bizshop

I'm not sure what you mean there isn't a version 0.6 the latest version is datable-0.4-4 ( do you mean you have installed datable-0.0.6? This is an early alpha version ) The sort by column is still there in the current version Just to be sure I've just checked this on my N800 (0.4-4).

Edit: The first post on this thread allways has a current link to the latest version.

Rick

Sorry, I had downloaded from the link that appeared at the bottom of the page I was on here, forgot it was not the beginning of the thread.

I uninstalled that and installed 0.4-4

Unfortunately, when trying to connect to an sqlite3 database (full one I was using on n800/Chinook) I get ValueError('substring not found')

Any way around this you can think of?

bizshop

If you are you ok with the command line do the following

and then re-run datable. This will rebuild datables own db. you will have to reopen any db's and will lose any saved SQL's / preferences.

Rick

datable 0.4-5 is now in svn you can grab it with

svn checkout https://garage.maemo.org/svn/datable

This version has a lot of background code improvements
* it includes sqlanalyser,py contributed by Dmitry Makovey this improves the
freestyle sql queries greatly. This allows queries like

SELECT t1.name as t1_name, t1.blah as t1_text from table1 as
t1 where t1.name='foo';

SELECT t1.name as t1_name, t1.blah as t1_text from 'table1' as
t1 where t1.name='foo';

* 'like' is included in the sql wizard.

* Default form now defaults to a datasheet view -- see below
Previous behavior is selectable on preferences page

Sorry for the delay. Real life got in the way there for a while.

I havn't done a deb yet because there are issues with the datasheet view. Its nearly there. Mostly works on the desktop but on the 800 when trying to 'add' the keyboard forces a focus change which I'm scratching my head to fix.

Any help great-fully received.

hallo rcull, i´ve installed the 0.4-4 .deb @ my n900 (0.4-5 in svn not found) but wont start. from xterminal:
~ $ datable
Traceback (most recent call last):
File "/usr/bin/datable", line 3378, in <module>
app=Db()
File "/usr/bin/datable", line 3360, in __init__
self.First_Run()
File "/usr/bin/datable", line 667, in First_Run
self.Show_Note("","First run creating .datable\n"+" and database!","Inf")
File "/usr/bin/datable", line 197, in Show_Note
dialog=hildon.Note ("information", (self,data,gtk.STOCK_DIALOG_INFO))
TypeError: HildonNote.__init__() takes at least 3 arguments (2 given)

i´m not a developer and have no idea how to fix.
any suggestions please?
(sry 4 my bad english)

heiko

p.s. installed 'Crochik dbBrowser' yet