Re: [sqlite] sqlite 3.0.8 select wierdness

2004-12-10 Thread D. Richard Hipp
Bob Gilson wrote: > > Other databases allow you to pass the buffer size as > a maximum length of the string and truncate at the null. > You can supply a length of -1 and SQLite will figure out the length for itself by looking for the \000. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] absolute vs. relative path to database on Cygwin

2004-12-10 Thread Markus Hoenicka
Christian Smith writes: > This looks like a cygwin and/or your cygwin environment problem. sqlite > works fine with absolute path on my Linux box, with 2.8.15. > > We're using sqlite with absolute paths in production code across Solaris, > Linux, Windows, HP-UX and AIX with no problems. >

Re: [sqlite] commas in columns and temporary tables

2004-12-10 Thread Taj Morton
Dennis Cote wrote: Taj Morton wrote: Dennis, Indeed. Actually, I'm using an OO wrapper around that library, TSQLiteDB (http://homepages.borland.com/torry/db/direct/db_directsql/tsqlite.zip). This link gives me a 404 error so I can't look at the code myself. http://www.torry.net/db/direct

Re: [sqlite] sqlite 3.0.8 select wierdness

2004-12-10 Thread Bob Gilson
D. Richard Hipp wrote: Bob Gilson wrote: > I'm seeing some strange behavior with sqlite 3.0.8. > Has anyone else seen this sort of thing? I attempted to follow all of your instructions carefully, but when I try it, it works fine. I tracked down the strangeness. It was triggered by my usage of the A

Re: [sqlite] commas in columns and temporary tables

2004-12-10 Thread Dennis Cote
Taj Morton wrote: > Dennis, > > Indeed. Actually, I'm using an OO wrapper around that library, > TSQLiteDB > (http://homepages.borland.com/torry/db/direct/db_directsql/tsqlite.zip). This link gives me a 404 error so I can't look at the code myself. > > Here's my TEMPORARY TABLE code: > // DB is a

Re: [sqlite] commas in columns and temporary tables

2004-12-10 Thread Taj Morton
Dennis, From your description it sounds like you are using the Delphi wrapper listed in the wiki as: Delphi class for SQLite. http://www.torry.net/db/direct/db_directsql/tsqlite.zip Indeed. Actually, I'm using an OO wrapper around that library, TSQLiteDB (http://homepages.borland.com/torry/db/d

Re: [sqlite] commas in columns and temporary tables

2004-12-10 Thread Dennis Cote
Taj Morton wrote: > Dennis Cote wrote: > >> Taj, >> >> I'm not sure what wrapper you are using, but the sqlite.dll provided >> by SQLite has two API functions that are used to open and close the >> database connection. You use sqlite3_open() to open the connection, >> and sqlite3_close() to close i

Re: [sqlite] absolute vs. relative path to database on Cygwin

2004-12-10 Thread Christian Smith
On Fri, 10 Dec 2004, Markus Hoenicka wrote: >Hi, > >I've just built 2.8.15 on Cygwin which worked without a hitch (thanks to >those who added Cygwin support in the past). However, I came across a >problem that makes working with databases a bit inconvenient. It seems >like the library does not und

[sqlite] strange error: segmentation fault when called second time

2004-12-10 Thread Sudha C Naidu
hello! here is a strange problem, probably not for others...when i call this func for the first time o/p is ** this file contains an sqlite 2.1 database **,A101 but when called for the second time...o/p is (null),A101   void check_personal_entry(GtkObject *personal_info_window) {

[sqlite] absolute vs. relative path to database on Cygwin

2004-12-10 Thread Markus Hoenicka
Hi, I've just built 2.8.15 on Cygwin which worked without a hitch (thanks to those who added Cygwin support in the past). However, I came across a problem that makes working with databases a bit inconvenient. It seems like the library does not understand absolute paths, only relative paths. You ca