[sqlite] SQLite Database File Copied into another machine

2008-08-17 Thread Srilatha Avula
Hi, I have created a database with name test.db and i have to check this database and view the tables in the database in another machine. I have copied entire folder of SQLite analyzer into another windows machine and verified the database.Unable to see the database in the GUI of Analyzer. Let

Re: [sqlite] System function with Sqlite

2008-08-17 Thread Chris Brown
Hi Chris > Can you check which libc you are using and if there is any LD_PRELOAD > or similar active? There does not appear to be any LD_PRELOAD active. The version of lic is 2.2.3. Thanks Chris ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] System function with Sqlite

2008-08-17 Thread Chris Brown
Hi Asif > AFAIK, how the system() passes the command-string to the command-processor > is implementation defined. I would suggest that you also pass the shell > (e.g. /bin/sh) to system() in addition to the command string. Which shell > are you using? I am running bash version 2.05a.0(1). I

Re: [sqlite] Precompiled SQLite Binaries for WinCE

2008-08-17 Thread Harold Wood & Meyuni Gani
newobjects Woody from his pda -Original Message- From: Roger Binns <[EMAIL PROTECTED]> Sent: Sunday, August 17, 2008 2:00 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Precompiled SQLite Binaries for WinCE -BEGIN PGP SIGNED

Re: [sqlite] Currency Issues

2008-08-17 Thread jonwood
John Stanton-3 wrote: > > I implemented a decimal type in Sqlite. It uses fixed point and correct > rounding rules. To my mind it is an essential component if one is using > Sqlite for commerical purposes and must have accurate financial > information. > And, just to be clear: when you

Re: [sqlite] Currency Issues

2008-08-17 Thread John Stanton
I implemented a decimal type in Sqlite. It uses fixed point and correct rounding rules. To my mind it is an essential component if one is using Sqlite for commerical purposes and must have accurate financial information. jonwood wrote: > > Brad Stiles-2 wrote: > >>That's a very real

Re: [sqlite] Generic speed testing

2008-08-17 Thread Nuno Lucas
On Fri, Aug 15, 2008 at 11:19 PM, Noah Hart <[EMAIL PROTECTED]> wrote: > Greg, I intended that sqlite3 be launched without a filename, so this > will give a memory based database and disk I/O would not need to be > considered. If I remember correctly the default is an "anonymous" disk based

[sqlite] Lemon: Functionality like Bison's %error-verbose / Access to last follow set from %syntax_error

2008-08-17 Thread Markus Thiele
Greetings, I've been using Lemon for a small custom compiler project. I've used Bison before, and I very much prefer the way Lemon does things, there's just one feature I'm missing and haven't been able to find. Bison generates a human readable error message on syntax errors, and when setting

Re: [sqlite] Currency Issues

2008-08-17 Thread jonwood
Brad Stiles-2 wrote: > > That's a very real possibility. I'll second your idea, and Dennis' > recommendation, to use an integer type for this (unless you are using a > compiler that has a scaled integer or dedicated currency type). In > addition, you might consider storing at least one more

Re: [sqlite] Currency Issues

2008-08-17 Thread jonwood
That's the plan then. Thanks. Dennis Cote wrote: > > jonwood wrote: >> I've done very little programming related to currency (dollars, etc.) and >> I'm >> wondering if I need to worry about rounding errors. Since SQLite doesn't >> appear to have a currency type, I had planned on using REAL

Re: [sqlite] Precompiled SQLite Binaries for WinCE

2008-08-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > Of course I could set up a development tool just to compile the SQLite > source, but it is some seemingly unnecessary extra work. Also I would not > know where to start. As far as I know, DRH builds the download binaries

Re: [sqlite] Precompiled SQLite Binaries for WinCE

2008-08-17 Thread cc_
Roger, "Why do you need the binary?" I am using Lazarus with FPC. Free Pascal would not compile the SQLite source. :) Of course I could set up a development tool just to compile the SQLite source, but it is some seemingly unnecessary extra work. Also I would not know where to

Re: [sqlite] Precompiled SQLite Binaries for WinCE

2008-08-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > I was looking for precompiled SQLite binaries for WinCE on the download page, Why do you need the binary? If you use the amalgamation (a single source file which includes the WinCE support) then you can just add that