Re: [sqlite] Using SQLite on networked drive

2006-03-02 Thread Ray Mosley
s, > Vishal Kashyap. > http://www.vishal.net.in > -- Ray Mosley

Re: [sqlite] any lightweight linux DB browser

2005-11-21 Thread Ray Mosley
te.org/cvstrac/wiki?p=ConsoleForTclTk > > That program gives you a GUI. But the GUI just has a command-line > prompt into which you type SQL statements. It is no more capable > than the command-line shell. > > > -- Ray Mosley

Re: [sqlite] Pre-allocating disk space to avoid db file fragments

2005-09-13 Thread Ray Mosley
ile by bigger > >>>chunk(e.g. grow by 20% or so in size each time)? > >> > >> > >> > >>Why not do a vacuum every 10th time (or something similar) you exit the > >>program? > >> > >>--- > >>The Castles of Dereth Calendar: a tour of the art and architecture of > >>Asheron's Call > >>http://www.lulu.com/content/77264 > >> > >> > > > > > > > > > -- > Ben Clewett > +44(0)1923 46 > Project Manager > Road Tech Computer Systems Ltd > http://www.roadrunner.uk.com > > -- Ray Mosley

Re: [sqlite] Migrating from v2 to v3

2005-08-29 Thread Ray Mosley
d searching Google groups > to try to find a migration guide for going from sqlite 2 to sqlite 3. > Can anyone point me to such a guide? > > Thanks. > > Richard > > -- Ray Mosley

Re: [sqlite] blocking - busy_timeout vs database is locked(5)

2005-08-19 Thread Ray Mosley
y), and if its a SQLITE_LOCKED then you need > to > sleep for some random amount of time and retry -- with hopefully an > eventual > timeout mechanism in place. > > Robert > > > -- Ray Mosley

Re: [sqlite] how to get notice when database is free after it was busy

2005-08-05 Thread Ray Mosley
ntial and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy all > copies of the original message. > -- Ray Mosley

Re: [sqlite] how to get notice when database is free after it was busy

2005-08-05 Thread Ray Mosley
; keep trying to obtain a lock? You can set the wait time to a short value > and just repeat until the user cancels or it works. > -- Ray Mosley

Re: [sqlite] Coverting databases - 2.8 to latest 3

2005-08-04 Thread Ray Mosley
Opinions are not necessarily those of Misys Healthcare Systems nor its > board > of directors. > -- Ray Mosley

[sqlite] Coverting databases - 2.8 to latest 3

2005-08-04 Thread Ray Mosley
I started using 2.8 because I still have Tcl 8.3; If I convert to Tcl 8.4 to go to SQlite 3, how do I convert databases? -- Ray Mosley

[sqlite] timeout question

2005-07-28 Thread Ray Mosley
the timeout value, or only one? Thanks. -- Ray Mosley

Re: [sqlite] Syntax Help

2005-07-06 Thread Ray Mosley
> > input. > > They are separate sql statements, but being careful I would check to make > sure they actually did work when executing them. You can do something > reasonable if they fail instead of just crashing. > -- Ray Mosley

[sqlite] Syntax Help

2005-07-05 Thread Ray Mosley
t;END TRANSACTION\nCOMMIT TRANSACTION" DB eval "$tran_string" Thanks for the help. -- Ray Mosley

Re: [sqlite] Comparator bug? Overflow?

2005-06-29 Thread Ray Mosley
Miller > Software & Networking Solutions Consultant > ThinkGear, Inc. > (888) 5-THINKGEAR / www.thinkgear.com <http://www.thinkgear.com> > > > -- Ray Mosley

Re: [sqlite] Problem with memory using Tcl-defined SQL functions

2005-05-23 Thread Ray Mosley
copy, disclosure or distribution of this message > is strictly forbidden. If you have received this transmission in error, > please notify the sender immediately and delete it. > __ > -- Ray Mosley