Re: [sqlite] How to realize the ROWID in a view?

Thanks for you reply. I Just want to get a sequence number in a view, that is not the ID field in the table foo. Table foo is a sample of mine. In fact, my table is not only the id and x field. And the x field could be duplicate in the table foo. Could you help me to finish that? Thanks.

[sqlite] SQLite_Exec16 - suggestion

Full UTF-16 support functions are present, except SQLite_Exec16. As I havely using UTF-16 and scripts (UPDATE and INSERT), I created such addon to SQLiteAPI as Delphi function). However, it may be worted to be natively supported from SQLiteAPI, instead to be simulated. Sasa -- www.szutils.net

Re: [sqlite] lemon segfault

Michael Somos wrote: I found the following for "lemon" in the sqlite-3.3.6 distribution : === lemon -x Lemon version 1.0 lemon /dev/null Segmentation fault gdb ./lemon GNU gdb 6.4 Copyright

Re: [sqlite] How to realize the ROWID in a view?

PY uttered: Hi All, I have a problem about the ROWID in a view. I want to simulate a ROWID in a view just like the same purpose in a table. For Example: Create Table foo(id INTEGER PRIMARY KEY AUTOINCREMENT, x TEXT); insert into foo(x) values('X'); insert into foo(x) values('Y'); insert into

Re: [sqlite] How to realize the ROWID in a view?

It's been a while since I did it, but I think I just listed the fields to display and included that field name PY ([EMAIL PROTECTED]) wrote: > > Hi All, > > I have a problem about the ROWID in a view. I want to simulate a ROWID in a > view just like the same purpose in a table. > > For Example: >

[sqlite] How to realize the ROWID in a view?

Hi All, I have a problem about the ROWID in a view. I want to simulate a ROWID in a view just like the same purpose in a table. For Example: Create Table foo(id INTEGER PRIMARY KEY AUTOINCREMENT, x TEXT); insert into foo(x) values('X'); insert into foo(x) values('Y'); insert into foo(x)

Re: [sqlite] SQLite 3.3.6 - possibly memory leak

I've seen a few issues myself, but they all appeared to be related to the memory management thing. If you're using VC, try putting this into your code: #define CRTDBG_MAP_ALLOC #include #include // and then in your main function: _CrtSetDbgFlag ( _CRTDBG_ALLOC_MEM_DF | _CRTDBG_LEAK_CHECK_DF

Re: [sqlite] MacOS X build failure

Kon Lovett uttered: Hi, The following occurs building the CVS head w/ gcc 4.0.1 on MacOS 10.4.6: ./libtool --mode=compile gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I../sqlite/src -DNDEBUG -DSQLITE_ALLOW_XTHREAD_CONNECT=1 -I/usr/local/include -DTHREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=1

Re: [sqlite] SQLite 3.3.6 - possibly memory leak

Sasa Zeman uttered: I working with my own SQLite wrapper for Delphi, with the statically linked SQLite 3.3.6. File variant works fine: SQLite3_Open('Test.sqb',db); SQLite3_Exec(db,'DROP TABLE TEST',NIL,NIL,ErrMsg); ... However memory variant rise a memory leak report:

[sqlite] SQLite 3.3.6 - possibly memory leak

I working with my own SQLite wrapper for Delphi, with the statically linked SQLite 3.3.6. File variant works fine: SQLite3_Open('Test.sqb',db); SQLite3_Exec(db,'DROP TABLE TEST',NIL,NIL,ErrMsg); ... However memory variant rise a memory leak report: SQLite3_Open(':memory:',db);