Notices

Sorry about the late replies I have been on holiday for a week.

Bizshop.
I'm glad you like it. Sorting has been added I'll do an interim release 0.1.2 this weekend

roblynn.
I am using pypackager ( I should have mentioned this before. In future I will include a mention of this in the docs.)
You will need a base folder ie

Then under that your folder structure. At its very simplest you will need

my .service file looks like

and the .desktop

you must also have a line in your program equivelent to

note: the service file,desktop file and osso_context all identical service name.
Then just run pypackager with all the fields filled in and it magics a .deb for you.

Rick

Version 0.1.2 now in garage.
* Sorting added ( click header on record page )
* Added version No to front page.
* Killed a bug with messages on records page.

enjoy
Rick

New release - two point releases in one

From the change log:-
0.2
- Will now run from your (linux) desktop as well as the tablet
- GUI tweeks
- Bug fixes
- Create new table from a CSV file with column headers.
- Save named queries ( select only for now ). Saves against current DB
- Load named query ( previously saved against current DB )
- Flag for autorun of queries on settings page.

0.3
- More Gui tweeks
- More Bugs squashed.
- Query builder wizard ( select only )

I will post some screenshots and some help text soon.

Please post any bugs ( I'm sure they will be there ) and any enhancement requests here.
version 0.4 will be a basic forms feature using the current query followed by a reporting facility if I am not otherwise persuaded.

https://garage.maemo.org/frs/downloa...-0.3-0_all.deb

Enjoy
Rick

Some screenshots ( taken on my desktop for ease )

Save and Load query. Plus create table from CSV with header.

A quick and dirty explanation of new functionality in a zipped rtf.


Rick

great work rcull !

rcull....dude I love you and wanna have your baby!!



I have been needing this ability from the tablet to help me work w/o dragging a laptop with me. If you add forms and I can then export the data I enter I will be in your debt more then ya know.

If I could actually use connection to remote SQL db's...I would be willing to, well, got an annoying neighbor? Maybe we can make that stop.

seriously, I am not fluent in SQLite and it's limitations not if you can even build in the ability to connect to a real remote SQL DB over HTTP of course. Maybe in the future?

You really have the makings of a nice SQL Server front end & DB manager here but I am not sure how far these tools can take it...but the addition of forms alone is above and beyond yet just what I have been needing.

I did have a question. Is there any doco yet? Things like field value limites/ranges and that sort of stuff. I need pretty much something like varchar type fields but even just text will work because I can do any conversion on the import side over on the server.

One reason this is so important is text input into the webforms I have on the my servers is so freaking slow via MicroB that I can get MINUTES ahead typing on my BT keyboard. But when typing into apps on the tablet there is no significant, if any, lag time so I can touch type and get real work done.

I can say once the forms get going I WILL be using this for all manner of data entry. Everything from inventory records to site content for a non-profit I manage a site for...you name it...

sorry for gushing but for the first time I feel like the tablet is more than a novelty I read books on and do crossword puzzles on...thanks!!

BTW, the only reason I ever found your app was because of Reggie's Software forum section. And I wanna thank Reggie for that even if it never comes back...at least one of us out here liked it and used it first day.

Here is one for Reggie too:

brecklundin

Thanks for the feedback.

This is going to be a short reply. I wont be doing a lot this week as I'm sitting on our Narrowboat in mid Warwickshire and will be for the next 8/9 days (mostly GPRS access)

This was the exact reason I put DaTable on Reggies software repo. I dont think the app is ready yet for Joe public but a few more downloads by tech savvy ITT users could provide valuable suggestiions and bug reports untill its ready for extras.

Forms are coming along quite well (plus xml based help screens). I'll try and do more work on the boat (they've forcast rain) and check here daily.

Rick

Did you just say FORMS? Woohoo! Looking forward to it. Trying to figure if I have enough resources to help, too.

Any way of implementing more data types/storage classes in sqlite? I'd especially like to see boolean. With a checkbox on the form of course.