Since this appears to be a reporting application with multiple readers, why not use an HTML report output and any web browser. Then if you decide to publish the reports on your network, there is little more needed to do so.
On Wed, 2009-07-22 at 10:12 -0700, scabral wrote: > Do you know of any third party applications that i could use to build the > front end? This will need to run on local machines, not on servers. So, > some sort of desktop application i would imagine.... > > thanks > Scott > > P Kishor-3 wrote: > > > > On Wed, Jul 22, 2009 at 11:34 AM, scabral<scabr...@lifespan.org> wrote: > >> > >> HI, > >> > >> i am new to SQLite and i currently have an access database that i would > >> like > >> to convert over to a SQLite database. > >> > >> there are a couple of processes that would need to take place in order > >> for > >> this to work and i'm not sure if SQLite has these capabilities: > >> > >> 1. Need to automatically import text file into SQLite database on local > >> machine (machine always on). I was thinking of using scheduled task to > >> run > >> a script to do this, but not sure if that is possible. > > > > Sure it is possible. You will have to choose your favorite programming > > language, write a program to locate and import the local text file, > > and set up a scheduler to do so periodically. > > > >> 2. Neet to somehow create a front-end to query data from SQLite database > >> (not sure if SQLite has front end application). > > > > Lots of third-party applications. You might end up writing your own to > > suit your own requirements. > > > > > >> > >> Basically, i want to get rid of the Access database because the user's > >> have > >> to manually update the tables everyday from the text files that get ftp'd > >> over. I was trying to figure out a solution that would automatically > >> load > >> the text files withouth any human intervention and then give the user's > >> the > >> ability to view the data through some sort of front-end (similar to > >> Access > >> form). > >> > >> Thanks > >> scott > > > > -- > > Puneet Kishor http://www.punkish.org > > Carbon Model http://carbonmodel.org > > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > > ----------------------------------------------------------------------- > > Assertions are politics; backing up assertions with evidence is science > > ======================================================================= > > Sent from Madison, WI, United States > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
