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 problems have all been related to the Objective-C / Cocoa interface that I have been working on. It is a small project with a small database consisting of 4 tables, one of which is a startup table with two integers. Those two integers correspond to primary keys of two other tables with the AUTOINCREMENT, precisely because I do not want recycling of id numbers. Originally, I had written Obj-C code to update the startup table integers whenever an UPDATE or INSERT was performed on the two tables with the AUTOINCREMENT id numbers, then I thought it would be much more efficient to have the triggers do the job, and result in less code in the actual front end. Well, all was working fine until I installed the triggers. My Obj-C code did indeed update the startup table, and then correctly read those integers to present the proper data to the GUI. After installing the triggers, and commenting out the relevant Obj-C code, it did not matter whether I did the INSERT or UPDATE via my GUI or via the command line; the startup table was consistently correct (i.e., the triggers were working), but my Obj-C code kept returning the integer 2, even when the startup table contained a 17. It was even more maddening when the same behavior was exhibited after dropping the triggers and un-commenting the Obj-C code. I ended up having to erase the database file completely and write a new one to get everything to function correctly as the original had. Yes, I am a beginner with both Obj-C and SQLite (6 months or so with both), so it is certainly possible that there is something involved with the timing of my commands within my Cocoa project that is doing this. The weird thing is that even when I shut down the sample app (running inside of XCode), and then re-launched it to read the tables fresh on startup, I would still consistently get a 2, regardless of what integer was actually residing in the startup table. In case you are wondering, I use 3 different Macs, depending on where I am during the month, and I want the startup table so that the database file can move from machine to machine, and my app will always have the same data and setup. The file will eventually reside on a flash drive, although for development purposes, right now I am keeping it on my desktop(s). Thank you again. > Craig Smith [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 due respect, I find this hard to believe. As far as I can tell, this is a physical impossibility in SQLite's data structures. Can you show a small sample that demonstrates the problem? How do you create the table, insert rows, and read them back in a way that suggests to you there are duplicate rowids? Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 other tools which will require ODBC/ ADO. I have tested OOFile but was not worth enough. So please share what you have with all of us. I am tired of searching such a thing. Rajesh Nair - Original Message - From: "Merv" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database"Sent: Saturday, November 15, 2008 9:03 PM Subject: 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 705-646-1076. > Have a super one! > Merv > > Rajesh Nair wrote: >> 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 >> then >> just view and print". Do you have any link which could help all of us. >> >> >> >> - Original Message - >> From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> >> To: "General Discussion of SQLite Database" >> Sent: Saturday, November 15, 2008 10:24 AM >> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >> >> >> >>> If you want something that is Windows based like you describe, why not >>> use >>> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so >>> if >>> you need to revise you may have a problem finding a resource. Also >>> consider the platform independence if that is a concern >>> Timothy A. Sawyer, CISSP >>> Managing Director >>> MBD Solutions >>> Phone: (603) 546-7132 >>> Web: http://www.mybowlingdiary.com >>> Email: [EMAIL PROTECTED] >>> >>> >>> -Original Message- >>> From: "Rajesh Nair" <[EMAIL PROTECTED]> >>> >>> Date: Sat, 15 Nov 2008 09:23:46 >>> To: General Discussion of SQLite Database >>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >>> >>> >>> Thanks >>> >>> So I can't use it... Ok ... But I got some source code of FastReport ( >>> some >>> ealier version ) from the internet and it is in Dephi/Pascal. I don't >>> know >>> both of the tools. Can you use the same code to build a dll which can be >>> used with other windows programing languages? ( So that no one can raise >>> their finger aganist me or YOU ). >>> >>> I don't want a very efficient-high-end report designer like FastReport. >>> My >>> clients require very simple reports, which does not contain much >>> caculations >>> etc If you can help me please. It won't be just for me. Those who >>> are >>> using SqLite with windows will be happy with a simple report deisgner >>> and >>> viewer. Also my company is not willing to puchase any product for just >>> reporting, since our programs are supplied freely along with some of our >>> products. So an extra cost is not feasible. >>> >>> A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS >>> >>> >>> - Original Message - >>> From: "Cariotoglou Mike" <[EMAIL PROTECTED]> >>> To: "General Discussion of SQLite Database" >>> Sent: Friday, November 14, 2008 7:14 PM >>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >>> >>> >>> I am the author of sqlite3Explorer. Sorry I did not answer you previous post, reason is I did not motice it... :( I don't think what you want is feasible. the reason is this: the Dll expects a "dataset" which sqlite3Explorer builds internally, and the report engine takes it from there (Design, run, export etc). the dll itself does not contain data retrieval code, and relies on the host for this. this is ok, but the catch is here: the dataset format that the dll understands is a proprietary format developed by and only used by the company I work for. the dll engine is one the prime design/execute engines for our commercial projects. thus I cannot open-source it. and, since the dataset format in question cannot be produced without having access to the proprietary libraries we use here, what you want cannot be done. sorry... > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair > Sent: Friday, November 14, 2008 2:12 PM > To: General Discussion of SQLite Database > Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer > > Hi all >
[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: http://www.nabble.com/rowid-for-my-first-2-rows-is-always-the-Same.-tp20522218p20522218.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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? > > Cheers, > > Daniel Brown | Software Engineer > "The best laid schemes o' mice an' men, gang aft agley" > That'd definitely be my recommendation. I use ActiveTcl for all of my Tcl development, which happens to be Windows XP based and often incorporates SQLite. Jeff ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 Engineer "The best laid schemes o' mice an' men, gang aft agley" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 there is no WHERE clause, the UPDATE attempt should just fail. Any hints would be appreciated. -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 documentation about simply using PRIMARY KEY instead of INTEGER PRIMARY KEY, but then I lose my AUTOINCREMENT ability. Does anyone have a solution that both provides AUTOINCREMENT (or a reasonable facsimile) to a PRIMARY KEY field and allows the usage of triggers on those tables? Thank you very much. Craig Smith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 705-646-1076. Have a super one! Merv Rajesh Nair wrote: > 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 then > just view and print". Do you have any link which could help all of us. > > > > - Original Message - > From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> > To: "General Discussion of SQLite Database"> Sent: Saturday, November 15, 2008 10:24 AM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > >> If you want something that is Windows based like you describe, why not use >> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if >> you need to revise you may have a problem finding a resource. Also >> consider the platform independence if that is a concern >> Timothy A. Sawyer, CISSP >> Managing Director >> MBD Solutions >> Phone: (603) 546-7132 >> Web: http://www.mybowlingdiary.com >> Email: [EMAIL PROTECTED] >> >> >> -Original Message- >> From: "Rajesh Nair" <[EMAIL PROTECTED]> >> >> Date: Sat, 15 Nov 2008 09:23:46 >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >> >> >> Thanks >> >> So I can't use it... Ok ... But I got some source code of FastReport ( >> some >> ealier version ) from the internet and it is in Dephi/Pascal. I don't know >> both of the tools. Can you use the same code to build a dll which can be >> used with other windows programing languages? ( So that no one can raise >> their finger aganist me or YOU ). >> >> I don't want a very efficient-high-end report designer like FastReport. My >> clients require very simple reports, which does not contain much >> caculations >> etc If you can help me please. It won't be just for me. Those who are >> using SqLite with windows will be happy with a simple report deisgner and >> viewer. Also my company is not willing to puchase any product for just >> reporting, since our programs are supplied freely along with some of our >> products. So an extra cost is not feasible. >> >> A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS >> >> >> - Original Message - >> From: "Cariotoglou Mike" <[EMAIL PROTECTED]> >> To: "General Discussion of SQLite Database" >> Sent: Friday, November 14, 2008 7:14 PM >> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >> >> >> >>> I am the author of sqlite3Explorer. Sorry I did not answer you previous >>> post, reason is I did not motice it... :( >>> >>> I don't think what you want is feasible. the reason is this: the Dll >>> expects a "dataset" which sqlite3Explorer builds internally, and the >>> report engine takes it from there (Design, run, export etc). the dll >>> itself does not contain data retrieval code, and relies on the host for >>> this. >>> >>> this is ok, but the catch is here: the dataset format that the dll >>> understands is a proprietary format developed by and only used by the >>> company I work for. the dll engine is one the prime design/execute >>> engines for our commercial projects. >>> thus I cannot open-source it. and, since the dataset format in question >>> cannot be produced without having access to the proprietary libraries >>> we use here, what you want cannot be done. >>> >>> sorry... >>> >>> -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair Sent: Friday, November 14, 2008 2:12 PM To: General Discussion of SQLite Database Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer Hi all How can I use the mkFrxEngine.DLL supplied along with the Sqlite3Explorer. The dll is a report designer and viewer. Please help me to use that dll if any one knows. I asked the same before 10-14 days ago, but didn't get any reply. If even the author of the same is reading this please help me. I want to use it as a report viewer for my sqlite3 database. -- Regards Rajesh Nair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>
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 LCMapString(LCMAP_UPPERCASE) on Win32. That would bring the Sqlite behaviour in line with the handling in the application program itself (provided that it uses OS APIs and not ICU). (2) I'm under the impression, that the problematic cases (german sharp-s, turkic i) are few compared with all the cases where a simple lookup would things make work. If I'm not mistaken, a lookup table of 2048 entries handling all 2 byte UTF-8 characters would already cover all the joint character repertoire of all ISO-8859-* (and their MSFT counterparts). Thai (in ISO 8859-11) is using three byte UTF-8 but doesn't have upper/lower case. Regards, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 profiling:/usr/src/sqlite3:Cannot create directory profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip and how can I remove it? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 then just view and print". Do you have any link which could help all of us. - Original Message - From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database"Sent: Saturday, November 15, 2008 10:24 AM Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > If you want something that is Windows based like you describe, why not use > Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if > you need to revise you may have a problem finding a resource. Also > consider the platform independence if that is a concern > Timothy A. Sawyer, CISSP > Managing Director > MBD Solutions > Phone: (603) 546-7132 > Web: http://www.mybowlingdiary.com > Email: [EMAIL PROTECTED] > > > -Original Message- > From: "Rajesh Nair" <[EMAIL PROTECTED]> > > Date: Sat, 15 Nov 2008 09:23:46 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > Thanks > > So I can't use it... Ok ... But I got some source code of FastReport ( > some > ealier version ) from the internet and it is in Dephi/Pascal. I don't know > both of the tools. Can you use the same code to build a dll which can be > used with other windows programing languages? ( So that no one can raise > their finger aganist me or YOU ). > > I don't want a very efficient-high-end report designer like FastReport. My > clients require very simple reports, which does not contain much > caculations > etc If you can help me please. It won't be just for me. Those who are > using SqLite with windows will be happy with a simple report deisgner and > viewer. Also my company is not willing to puchase any product for just > reporting, since our programs are supplied freely along with some of our > products. So an extra cost is not feasible. > > A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS > > > - Original Message - > From: "Cariotoglou Mike" <[EMAIL PROTECTED]> > To: "General Discussion of SQLite Database" > Sent: Friday, November 14, 2008 7:14 PM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > >>I am the author of sqlite3Explorer. Sorry I did not answer you previous >> post, reason is I did not motice it... :( >> >> I don't think what you want is feasible. the reason is this: the Dll >> expects a "dataset" which sqlite3Explorer builds internally, and the >> report engine takes it from there (Design, run, export etc). the dll >> itself does not contain data retrieval code, and relies on the host for >> this. >> >> this is ok, but the catch is here: the dataset format that the dll >> understands is a proprietary format developed by and only used by the >> company I work for. the dll engine is one the prime design/execute >> engines for our commercial projects. >> thus I cannot open-source it. and, since the dataset format in question >> cannot be produced without having access to the proprietary libraries >> we use here, what you want cannot be done. >> >> sorry... >> >>> -Original Message- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair >>> Sent: Friday, November 14, 2008 2:12 PM >>> To: General Discussion of SQLite Database >>> Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer >>> >>> Hi all >>> >>> How can I use the mkFrxEngine.DLL supplied along with the >>> Sqlite3Explorer. >>> The dll is a report designer and viewer. Please help me to >>> use that dll if any one knows. I asked the same before 10-14 >>> days ago, but didn't get any reply. If even the author of the >>> same is reading this please help me. I want to use it as a >>> report viewer for my sqlite3 database. >>> >>> >>> -- >>> Regards >>> Rajesh Nair >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 logical transaction, where every webpage >> contains another part of the data to be changed. In that >> case a memory database wouldn't work because it would >> disappear between page requests. > > More accurately the memory database has the same > lifetime of the database connection in that process, > and depending on how PHP is hosted there could be > multiple different processes involved in requests, and > processes could exit after processing a number of > requests. (It is important to clarify that SQLite > doesn't spuriously disappear in memory databases :-) Very true. To clarify some more: In general a database connection (and thus an SQLite memory database) is lost as soon as PHP has processed the request and sent a response page. >> That would work. I would use the main database all the way >> though, > > The OP is trying to prematurely optimize access away from > a potentially busy/locked main database :-) I secretly hope a complicated design pattern scared him away from doing that ;) >> One common design pattern > >It may be worth starting a section of the wiki with >various design patterns for common tasks. Yes, but I don't think the SQLite wiki is the appropriate place, as this is a generic session and transaction management (OLTP) issue, which has more to do with application frameworks than with a specific database engine. The SQLite wiki could contain links to relevant fora, but I wouldn't know one from the top of my head. Searching newsgroup comp.lang.php would be a good start. >Roger -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users