Re: [sqlite] GUI for data entry

Thanks for the suggestion, Tom, your post was very educational. At least in my case, you're on the spot, I knew about views but I didn't use them in my project so far, although a short analysis tells me that they would be extremely useful for it - for example I should create one called "files" for

Re: [sqlite] GUI for data entry

Gabor, > If the purpose of this is teaching with R then the R package sqldf > lets you query all R data frames in your session using sql as if they > were one big giant database. No, nothing to do with teaching R, but still a useful point in terms of broadening the use of SQL with R. Thanks,

Re: [sqlite] GUI for data entry

On Fri, Oct 15, 2010 at 12:54 PM, Graham Smith wrote: > Tom, > > Thanks for this. > > My main reason for asking is because I am trying to encourage my > students and indeed clients to think "database" rather than > "spreadsheet". Most of the time these aren't big or complex

Re: [sqlite] GUI for data entry

Tom, Thanks for this. My main reason for asking is because I am trying to encourage my students and indeed clients to think "database" rather than "spreadsheet". Most of the time these aren't big or complex data sets (normally records in the hundreds, sometimes the thousands) but still big

Re: [sqlite] GUI for data entry

Hi Graham, >> You don't need to create special tables for data entry. You can create views >> instead, coupled with "instead of" triggers. > >> I'll see if I can put together some SQL with a few examples of how a view >> updates several >related tables. > > As the OP, I would be very

Re: [sqlite] GUI for data entry

Tom > You don't need to create special tables for data entry. You can create views > instead, >coupled with "instead of" triggers. > I'll see if I can put together some SQL with a few examples of how a view > updates several >related tables. As the OP, I would be very interested in this. I

Re: [sqlite] GUI for data entry

On Wed, 13 Oct 2010 18:15:54 +0300 Mihai Militaru wrote: > But I got this idea: what if you create such "forms" yourself, using the > flexibility given by SQL? I don't know whether it would satisfy all your > requirements, but at least for duplication of data you can

Re: [sqlite] gui for data entry

Mihal > But I got this idea: what if you create such "forms" yourself, using the > flexibility given by SQL? I don't know whether it would satisfy all > your requirements, but at least for duplication of data you can easily > use temporary "tool" tables with triggers, Thanks for this suggestion,

Re: [sqlite] gui for data entry

On Wed, 13 Oct 2010 18:15:54 +0300 Mihai Militaru wrote: > That is what I am using, but unless I am missing something, it doesn't > let me create a form for data entry. Please pardon my distraction, Graham, I didn't read your post carefully. My recommendation was

Re: [sqlite] gui for data entry

Mihai > I use the Mozilla add-on, it's very handy and it gets updated. > https://addons.mozilla.org/en-US/firefox/addon/5817/ That is what I am using, but unless I am missing something, it doesn't let me create a form for data entry. Thanks, Graham

Re: [sqlite] gui for data entry

I use the Mozilla add-on, it's very handy and it gets updated. https://addons.mozilla.org/en-US/firefox/addon/5817/ It currently uses SQLite version 3.6.22. -- Mihai Militaru ___ sqlite-users mailing list

Re: [sqlite] gui for data entry

Oliver > I use OOo under WinXP and had a problem related to 3.2.1 in connection with > UNIQUE CONSTRAINTS Not sure I understand everything in the thread, but worth knowing as I learn. Thanks, Graham ___ sqlite-users mailing list

Re: [sqlite] gui for data entry

Vivien, > Libgda: http://www.gnome-db.org This is certainly a new one for me, I will give it a look. Thanks, Graham ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] gui for data entry

Graham Smith writes: [...] > Mmmm, still stuck on 3.2.1 with current release of Ubuntu (the OS I > use most of the time, followed by my Mac), so interesting to hear your > views on 3.2.1. > I use OOo under WinXP and had a problem related to 3.2.1 in connection with UNIQUE

Re: [sqlite] gui for data entry

David > Take a look at Kexi. (kexi-project.org) It is part of the Koffice suite, but > can be used >standalone. I had tested it on Windows and had no trouble > installing it. I have also used this before (on Ubuntu) as well as the OOo option, I suppose I find the SQLite GUIs that much nimbler

Re: [sqlite] gui for data entry

> the best is to take OOo 330 m9 > > that is a milestone without all former illnesses - believe me I suffered a lot > > D o n' t use 3.2.1!!! Mmmm, still stuck on 3.2.1 with current release of Ubuntu (the OS I use most of the time, followed by my Mac), so interesting to hear your views on 3.2.1.

Re: [sqlite] gui for data entry

On 12 October 2010 17:51, Graham Smith wrote: > There are several GUI editors for SQLite, but is there one that allows > creation of simple forms to allow data entry.  Although some allow > adding data to a single table, none that I have looked at seem to > allow a new record

Re: [sqlite] gui for data entry

--- On Tue, 10/12/10, Graham Smith <myotis...@gmail.com> wrote: > From: Graham Smith <myotis...@gmail.com> > Subject: Re: [sqlite] gui for data entry > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Tuesday, October 12, 2010, 12

Re: [sqlite] gui for data entry

ahh I forgot: the best is to take OOo 330 m9 that is a milestone without all former illnesses - believe me I suffered a lot D o n' t use 3.2.1!!! Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] gui for data entry

Oliver > works fine now but take the latest odbc driver from here: > > http://www.ch-werner.de/sqliteodbc/sqliteodbc-088pre2.exe > > because the 0.87 has a problem under special circumstances (makros) - > something > you will use if you like to automate some functions in your forms or make them

Re: [sqlite] gui for data entry

Graham Smith writes: [...] > > Thanks, I did consider this, but the last time I tried, it was very > clunky, and crashed a lot, but I will have another look since you > have suggested it. [...] works fine now but take the latest odbc driver from here:

Re: [sqlite] gui for data entry

Oliver > OpenOffice Base > > you need an ODBC driver too (http://www.ch-werner.de/sqliteodbc/) Thanks, I did consider this, but the last time I tried, it was very clunky, and crashed a lot, but I will have another look since you have suggested it. Graham

Re: [sqlite] gui for data entry

Graham Smith writes: > > There are several GUI editors for SQLite, but is there one that allows > creation of simple forms to allow data entry. Although some allow > adding data to a single table, none that I have looked at seem to > allow a new record to be added when it

[sqlite] gui for data entry

There are several GUI editors for SQLite, but is there one that allows creation of simple forms to allow data entry. Although some allow adding data to a single table, none that I have looked at seem to allow a new record to be added when it involves more than one table. It needs to be cross