Re: [sqlite] Sqlite causes exit error under symbian!

--- StevenLiu <[EMAIL PROTECTED]> wrote: > here is my code : > > sqlite *db; > char *zErrMsg = 0; > db = sqlite_open("test.db", 0, ); > sqlite_close(db); > db = NULL; > delete db; ^ Maybe leave that bit out. That's for deleting objects allocated with 'new', not SQLite handles.

RE: [sqlite] ANN: Sqlite3Explorer

Hi, For designing wxWidgets forms like Delphi, you can use my program IDE wx-devcpp from http://wxdsgn.sf.net . Although it is still in beta stage, you can still able to create a decent application with it. -Guru Kathiresan > -Original Message- > From: Leif Jensen [mailto:[EMAIL

Re: [sqlite] ANN: Sqlite3Explorer

Have you heard about wxWidgets (www.wxWidgets.org) ? A great free GUI library (and much more) that works on Windows, Linux and Mac (at least). Using that and your app. would do too ;-). I have just made a database application with these that runs on both Linux and Windows using SQLite3.

[sqlite] Index not used with "between"

Using the following: create table t_history(time real, ...); create index i_time on t_history(time); select count(*) from t_history where time between julianday('2004-04-01','utc') and julianday('now'); It seems the index is never hit. When using >= and <=, the index works. Is there a reason

[sqlite] Sqlite causes exit error under symbian!

my sqlite version 2.8.11 , all of the function are ok , but my program will always reporting me an error : Application Error : unknown software exception (0x8003) , position :0x6001c966 when exiting if i use the function sqlite_open() , it seems like something wrong when dealing with memory

Re: [sqlite] test errors on OSX

The fix is to NOT disable twolevel namespaces, but to fix SQLite's Makefile.in to not hoark the linking of the testfixture. Once this is fixed, all of the unit tests pass all of the time on Mac OS X. Thanks very much for diagnosing the problem. I took a look at the Makefile and I see that

Re: [sqlite] Are there any open source or free ERD tools for sqlite?

On Mon, 4 Apr 2005, Can Xue wrote: Subject: [sqlite] Are there any open source or free ERD tools for sqlite? As title. Thanks. Have you looked at: http://sqlfairy.sourceforge.net/ It comes recommended, but I haven't used it yet myself. cheers!

Re: [sqlite] ANN: Sqlite3Explorer

Serge Liber wrote: Hi, When starting sqlite3Explorer an error message appears: "The procedure entry point GdiGradientFill could not be located in the dll GDI32.dll" How can I proceed? I use NT4+sp6 This is a nasty one, I had it too. It has to do with a not consistently supported API, which

RE: [sqlite] ANN: Sqlite3Explorer

[EMAIL PROTECTED] it seems the new controls I used require this function, which only exists in win2k+. sorry for this, I think I will rebuild *without* the devexpress controls, for more genral purpose use.. > -Original Message- > From: Serge Liber [mailto:[EMAIL PROTECTED] > Sent:

Re: [sqlite] ANN: Sqlite3Explorer

Hi, When starting sqlite3Explorer an error message appears: "The procedure entry point GdiGradientFill could not be located in the dll GDI32.dll" How can I proceed? I use NT4+sp6 Serge Liber New version is out. Since the problem with size limits was not lifted from contrib, I created a home

Re: [sqlite] Desperate newbie: .def problem??

Clay Dowling wrote: Bill Henderson said: I have the Dev-Cpp IDE installed and have successfully compiled and linked several test programmes and am satisfied that dev-cpp is functioning correctly. Bill, You need to generate the libsqlite3.a library, which you can do with dlltool. I don't

Re: [sqlite] About field sizes...

> What effect has dimension on field size? ... See and . The dimension(s) has no effect on the actual storage. > And why is it valid when you mention "date" ... ? The type in a create statement serves only to

Re: [sqlite] How to do: move to Next/Prev record?

在 Mon, 04 Apr 2005 21:11:44 +0800，Tim_Anderson <[EMAIL PROTECTED]> 写 道: -Original Message- From: liigo [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 12:52 To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to do: move to Next/Prev record? > Not sure exactly what you mean here. The

Re: [sqlite] About field sizes...

Igor Gorbounov said: > I've seen in some sources that folks write something like this: > create table MyTable( >event varchar(200), >event_date date); > > What effect has dimension on field size? The syntax reference mentions > some "number" > near field type, but it is not

Re: [sqlite] Desperate newbie: .def problem??

Bill Henderson said: > I have the Dev-Cpp IDE installed and have successfully compiled and > linked > several test programmes and am satisfied that dev-cpp is functioning > correctly. Bill, You need to generate the libsqlite3.a library, which you can do with dlltool. I don't remember the

Re: [sqlite] How to do: move to Next/Prev record?

liigo said: > this a a way, but maybe not the best one. > > when the result set is very large, it will cost a very large memery. (?) When the result set is very large you'd best be using a forward-only recordset, so that really isn't an issue. It may be best in fact to only implement the

RE: [sqlite] How to do: move to Next/Prev record?

> -Original Message- > From: liigo [mailto:[EMAIL PROTECTED] > Sent: 04 April 2005 12:52 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to do: move to Next/Prev record? > > Not sure exactly what you mean here. The Sqlite API lets you step > > forward through a result set, but

[sqlite] Are there any open source or free ERD tools for sqlite?

As title. Thanks.

Re: [sqlite] How to do: move to Next/Prev record?

在 Mon, 04 Apr 2005 19:03:59 +0800，Tim Anderson <[EMAIL PROTECTED]> 写 道: -Original Message- From: liigo [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 08:58 To: sqlite-users@sqlite.org Subject: [sqlite] How to do: move to Next/Prev record? When wrap sqlite to anothe language, How to do:

[sqlite] Desperate newbie: .def problem??

I have the Dev-Cpp IDE installed and have successfully compiled and linked several test programmes and am satisfied that dev-cpp is functioning correctly. However, upon attempting to compile and link a test programme which uses sqlite3 I have run into trouble. The programme (below) compiles

RE: [sqlite] How to do: move to Next/Prev record?

> -Original Message- > From: liigo [mailto:[EMAIL PROTECTED] > Sent: 04 April 2005 08:58 > To: sqlite-users@sqlite.org > Subject: [sqlite] How to do: move to Next/Prev record? > > > When wrap sqlite to anothe language, > How to do: move to Next/Prev record? Not sure exactly what you

Re: [sqlite] How to create Auto Increment Field in SQlite

Hain Thanks Very Much Sir!!! Thanks Once Again Alok Gupta - Original Message - From: "Witold Czarnecki" <[EMAIL PROTECTED]> To: Sent: Monday, April 04, 2005 4:01 PM Subject: Re: [sqlite] How to create Auto Increment Field in SQlite >

Re: [sqlite] How to create Auto Increment Field in SQlite

http://www.sqlite.org/autoinc.html try INTEGER PRIMARY KEY (no interger :-) Best regards, Witold - Original Message - From: "alok" <[EMAIL PROTECTED]> To: Sent: Monday, April 04, 2005 12:21 PM Subject: [sqlite] How to create Auto Increment Field in SQlite I am

[sqlite] How to create Auto Increment Field in SQlite

I am knocking my head on door for doing this I try to create table with this feature Create table min1(slno interger auto_increment,name char(100)); but table doesn't create. any help or link relate to this is very helpful Thanks Alok Gupta

[sqlite] How to do: move to Next/Prev record?

When wrap sqlite to anothe language, How to do: move to Next/Prev record?