Re: [sqlite] INTEGER PRIMARY and Triggers

On Nov 16, 2008, at 2:14 AM, [EMAIL PROTECTED] wrote: > Do you mind specifying what are the "odd things" that happen? > > I have used TRIGGERs on tables with INTEGER PRIMARY KEY and have had > no odd things happen at all. Right. I should have put more details up originally. Actually, the

Re: [sqlite] rowid for my first 2 rows is always the Same.

"LordEricO" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > For some reason, the rowid of the first the 2 rows in my table always > matches. Whether it's one and one, two and two, 20 and 20 etc... No > matter if I delete one of the rows. > Do you know why that would be? With all

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

Hi Merv Thanks for your sharing If you can share it through this dissussion forum then that will be counted as a great work from you. Because those who are using Sqlite with windows and visualstudio 6 will face the problem of reporting. They have to depend up on Crystall Reports or some

[sqlite] rowid for my first 2 rows is always the Same.

For some reason, the rowid of the first the 2 rows in my table always matches. Whether it's one and one, two and two, 20 and 20 etc... No matter if I delete one of the rows. Do you know why that would be? Eric -- View this message in context:

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Brown, Daniel wrote: > Good afternoon list, > > If I would like to use the TCL based tests on my version of SQLite on > Windows XP what would be the recommend TCL distribution to use? Would > ActiveTCL (http://tinyurl.com/5wl6uv) be compatible with the SQLite TCL > scripts on Windows XP? > >

[sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Good afternoon list, If I would like to use the TCL based tests on my version of SQLite on Windows XP what would be the recommend TCL distribution to use? Would ActiveTCL (http://tinyurl.com/5wl6uv) be compatible with the SQLite TCL scripts on Windows XP? Cheers, Daniel Brown | Software

[sqlite] TRIGGER to disallow updates on condition

I want to create a TRIGGER (or some kind of constraint) that would croak when an update is attempted without a WHERE clause (to prevent accidental updates of the entire table). If a conscious update of the entire table is requested then one could just add a WHERE 0=0 kind of a dummy clause, but if

[sqlite] INTEGER PRIMARY KEY and triggers

I am addicted to using INTEGER PRIMARY KEY AUTOINCREMENT as the id fields in my SQLite projects, yet I would like to try some triggers as well. Of course, every time I add a trigger that accesses a table with these types of id fields, all sorts of odd things happen. I read in the

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

I have a program for Windows that may help you. It is not open-source but it is free to use and distribute. It has a simple report function that I am willing to modify based on input from users. We can continue to communicate this way or you can contact me directly at the above address or call

Re: [sqlite] bug? like-search with german umlaut is case-sensitive, should not be

I'm aware that ICU is able to provide a very general solution, but I'm wondering about two other options: (1) Just as an OS abstraction layer is in place for I/O, wouldn't it be possible to use an OS abstraction layer for L14N? So that for example uppercasing is forwarded to

[sqlite] How to remove SQLite profiling

Hello! Start console SQLite $ sqlite3 SQLite version 3.6.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .q profiling:/usr/src/sqlite3:Cannot create directory profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip What is strings

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

Thank You.. Java report builders are available on sourceforge.net and i have gone through it long before. What I am looking is the one which any one can use with VisualStudio 6 or ealier products. It should be handy. Not a complecated one. Simple like "just design and port the report file and

Re: [sqlite] Non-exclusive reserved lock?

On Sat, 15 Nov 2008 02:32:21 -0800, Roger Binns <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Kees Nuyt wrote: >> I assume the OP wants to collect updates from more than one >> webpage into one