Re: [sqlite] Re: Structured or Object-Oriented

2006-04-14 Thread John Stanton
[EMAIL PROTECTED] wrote: - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Saturday, April 15, 2006 12:09 AM Subject: Re: [sqlite] Re: Structured or Object-Oriented [EMAIL PROTECTED] wrote: - Original Message - From: "John Stanton" <[EMAIL PROTECTED]>

Re: [sqlite] How to create a database without sqlite?

2006-04-14 Thread John Stanton
Dan Baker wrote: I been reading this list for several days, but just started using it today. I'm using it as an embedded database (on Windows), and want to be able to create the initial database from within my app -- meaning, I don't want to ship a database file. What is the recommended meth

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-14 Thread koneill
- Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Saturday, April 15, 2006 12:09 AM Subject: Re: [sqlite] Re: Structured or Object-Oriented > [EMAIL PROTECTED] wrote: > > - Original Message - > > From: "John Stanton" <[EMAIL PROTECTED]> > > To: > > Sent: F

[sqlite] Converting ver 2 to ver 3

2006-04-14 Thread Paul Nash
I have taken the plunge and am converting from ver 2.8.16 to ver 3. I used the .DUMP method but found a problem. My char/text fields containg numbers were output as pure numbers without the quotes, so that on input to ver 3 they were stored as integer rather than string. This is a kind of bug in

Re: [sqlite] How to create a database without sqlite?

2006-04-14 Thread Nemanja Corlija
On 4/15/06, Dan Baker <[EMAIL PROTECTED]> wrote: I've just now noticed the "without sqlite" part of subject. Though I'm a bit confused if you really meant that since you later said that you want to use it as embedded db. If that means you really can't/won't link your app against sqlite3.dll then my

Re: [sqlite] How to create a database without sqlite?

2006-04-14 Thread Clay Dowling
Dan Baker wrote: > I been reading this list for several days, but just started using it today. > > I'm using it as an embedded database (on Windows), and want to be able to > create the initial database from within my app -- meaning, I don't want to > ship a database file. > > What is the reco

Re: [sqlite] How to create a database without sqlite?

2006-04-14 Thread Nemanja Corlija
On 4/15/06, Dan Baker <[EMAIL PROTECTED]> wrote: > What is the recommended method for creating a new database file from within > my app? (I > looked for an SQL statement, but failed to find something like "CREATE > DATABASE mydb") Look up the sqlite3_open() in API docs. All you need to do to crea

[sqlite] How to create a database without sqlite?

2006-04-14 Thread Dan Baker
I been reading this list for several days, but just started using it today. I'm using it as an embedded database (on Windows), and want to be able to create the initial database from within my app -- meaning, I don't want to ship a database file. What is the recommended method for creating a n

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Thomas Chust
On Fri, 14 Apr 2006, Will Leshner wrote: On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: I just downloaded the 3.3.5 distribution tarball and confirmed that the problem occurs with a binary built from that codebase as well. I assume you guys are refering to the tip, right. If I download

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-14 Thread John Stanton
Aaron Jones wrote: Well John, I'm crap at both Maths and Programming so you're probably right!!! lol Aaron. On 14/04/06, John Stanton <[EMAIL PROTECTED]> wrote: Robert Simpson wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] You should design your inte

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-14 Thread John Stanton
[EMAIL PROTECTED] wrote: - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Friday, April 14, 2006 1:32 AM Subject: Re: [sqlite] Re: Structured or Object-Oriented I was always impressed with Dijkstra's contention that a programmer's most important quality is a f

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Will Leshner
On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: > I just downloaded the 3.3.5 distribution tarball and confirmed that the > problem occurs with a binary built from that codebase as well. I assume you guys are refering to the tip, right. If I download the "stable" 3.3.5 distribution and build

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Thomas Chust
On Fri, 14 Apr 2006, ThomasChust wrote: [...] I'm using the current CVS version of SQLite 3.3.5 on MacOS X and since a few days (unfortunately I don't remember the exact time of the change in the CVS tree that caused it) the sqlite3 command line program always segfaults upon exit [...] Hello

[sqlite] SQLite3 command line utility crashes on MacOS X

2006-04-14 Thread Thomas Chust
Hello, I'm using the current CVS version of SQLite 3.3.5 on MacOS X and since a few days (unfortunately I don't remember the exact time of the change in the CVS tree that caused it) the sqlite3 command line program always segfaults upon exit with a message from the memory allocation libraries

Re: [sqlite] Structured or Object-Oriented?

2006-04-14 Thread koneill
>- Original Message - >From: "Aaron Jones" <[EMAIL PROTECTED]> >To: >Sent: Friday, April 14, 2006 12:05 PM >Subject: Re: [sqlite] Structured or Object-Oriented? > >Hi John, I fully understand, and if It wasn't for my final degree I would >simply just go with the flow, but I have to choos

Re: [sqlite] How to verify sqlite file?

2006-04-14 Thread Jens Miltner
Am 14.4.06 um 04:30 schrieb Charlie Li: Is there any way to verify a file is sqlite3 file? When I tried to open a non-sqlite file by sqlite_open(), the system crash. I checked the source codes and found no file type checking. The final trace is toward to page.c file. How to revise c

Re: [sqlite] Re: Structured or Object-Oriented

2006-04-14 Thread Aaron Jones
Well John, I'm crap at both Maths and Programming so you're probably right!!! lol Aaron. On 14/04/06, John Stanton <[EMAIL PROTECTED]> wrote: > > Robert Simpson wrote: > >>-Original Message- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > > >>You should design your interface

Re: [sqlite] Structured or Object-Oriented?

2006-04-14 Thread Aaron Jones
Hi John, I fully understand, and if It wasn't for my final degree I would simply just go with the flow, but I have to choose a method and justify why I chose it, which is doing my headin at the moment. lol Thanks for your comments. Aaron. On 14/04/06, John Stanton <[EMAIL PROTECTED]> wrote: > >

Re: [sqlite] Structured or Object-Oriented?

2006-04-14 Thread Aaron Jones
Hi Kevin, My Supervisor just wanted to know so that I could use it as a reason in my justification in choosing a method, it wasn't going to be used as the main reason, just 1 in a list of reasons as I couldn't base my decision solely on "I know OO, so I'll choose that". Your suggestions are reall