[sqlite] Re: Report writer
On Sunday 14 March 2004 10:17 am, Will Leshner wrote: > What kind of features are you looking for in such a report writer? My program is a membership management database. The db has a list of people, with various information about them distributed over several tables. For example, the 'people' table has the basic information that most people have (name, address, spouse name, 'flags'). The 'phones' has phone numbers, phone type and id which points back to the people db. Same with the 'emails' and 'notes' tables. Of course, there are other tables as well, but these are the ones to be concerned with at present. In my scenario, I have two basic reports that need to be handled: a 'list' and a 'detail'. A 'list' is just like it sounds: a listing of people. It might have various amounts of data from other tables, depending on what's needed. 'detail' is also just like it sounds: a dump of a particular person's data. This one is probably ok to hard-code (which is what I am doing now). The request I keep getting is for the user of the db to be able to create arbitrary reports. I need to find out exactly how far that goes; but the idea might be they want to be able to see only people with emails, and display name and email only. The program I wrote allows the user to create 'filtered' lists, which are quite sophisticated -- but the only two reports I allow at present are a 'list' containing name, addr, phone and a detail which has all the information. I'm looking to see if anyone has a more generic solution I could put into my program to allow my users some flexibility. At this point, *any* flexibility would make them happy... Thanks for any pointers, Ron -- My GPG public key is at http://ronware.gotdns.com/ fingerprint: 4E91 06E9 2020 114C 8BCD 55B2 0816 60AF 2B3D 4C51 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Report writer
On Mar 14, 2004, at 10:03 AM, Ron Aaron wrote: Does anyone have a generic report writer which could be used with SQLite? I keep getting requests for the ability to have 'user created' reports, and I don't want to rewrite something someone else has done already if possible. I also can't afford a commercial solution, as this is for non-profit organizations. What kind of features are you looking for in such a report writer? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Report writer
Hi all - Does anyone have a generic report writer which could be used with SQLite? I keep getting requests for the ability to have 'user created' reports, and I don't want to rewrite something someone else has done already if possible. I also can't afford a commercial solution, as this is for non-profit organizations. thanks! -- My GPG public key is at http://ronware.gotdns.com/ fingerprint: 4E91 06E9 2020 114C 8BCD 55B2 0816 60AF 2B3D 4C51 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Ann: SQLite Analyzer v 2.2.0 released
Hello! SQLite Analyzer v 2.2.0 released. What's new in the version 2.2.0: - Index management. - Trigger management. - Database creating. - Database integrity checking. Download url http://www.kraslabs.com/sqlite/files/sqlanlz.exe Screenshots http://www.kraslabs.com/sqlite/screen.html Member of sqlite list group have 20% discount. -- Best regards Sergey Startsev SQLite Analyzer - GUI tool to manage SQLite databases. http://www.kraslabs.com/sqlite/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] "Cannot start transaction in transaction"
Aha! So 2 possible solutions: 1/ If an error occurs in my "EndTransition();" I should submit "commit;" to 'sqlite'. 2/ I should write each insert in a separated line with sqlite_exec (excluding begin/commits) Thx Richard! At 13:32 14/03/2004, you wrote: Steven Van Ingelgem wrote: I have a database (duh :p)... There are a few things inside... Now I add a row: 10:33:59: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '', '', '');commit; ' --> columns are duplicate (that's normal because the data is already in there & the index are set on each field). Then I redo the exact same insert: 10:34:00: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '', '', '');commit; ' --> "Cannot start a transaction within a transaction" Ok, I do understand that you can't start a transaction in another transaction, but as far as I know I did open & close it only once for each query, right? My best guess is that somewhere the transaction isn't closed (internally)... When the first INSERT failed, execution of the SQL stopped. So the first COMMIT never occurred. So the first transaction was still active when you tried to start the second one. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] G00fy, (aka KaReL, aka Steven) Main Webpage : http://komma.cjb.net CQ Database : http://lid.fragland.net/ ICQ #: 35217584
Re: [sqlite] "Cannot start transaction in transaction"
Steven Van Ingelgem wrote: I have a database (duh :p)... There are a few things inside... Now I add a row: 10:33:59: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '', '', '');commit; ' --> columns are duplicate (that's normal because the data is already in there & the index are set on each field). Then I redo the exact same insert: 10:34:00: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '', '', '');commit; ' --> "Cannot start a transaction within a transaction" Ok, I do understand that you can't start a transaction in another transaction, but as far as I know I did open & close it only once for each query, right? My best guess is that somewhere the transaction isn't closed (internally)... When the first INSERT failed, execution of the SQL stopped. So the first COMMIT never occurred. So the first transaction was still active when you tried to start the second one. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] "Cannot start transaction in transaction"
Steven Van Ingelgem wrote: I have a database (duh :p)... There are a few things inside... Now I add a row: 10:33:59: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '', '', '');commit; ' are you sure the commit is done after the INSERT failed? This would explain that sqlite still has a transaction open on your next "BEGIN". /eno - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] "Cannot start transaction in transaction"
I have a database (duh :p)... There are a few things inside... Now I add a row: 10:33:59: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '','', '');commit; ' --> columns are duplicate (that's normal because the data is already in there & the index are set on each field). Then I redo the exact same insert: 10:34:00: Transition: 'BEGIN ON CONFLICT FAIL; INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, CountryCode, Phone, Fax, Remark) VALUES('1', '1','','','1', '1000', '1', 'B ', '','', '');commit; ' --> "Cannot start a transaction within a transaction" Ok, I do understand that you can't start a transaction in another transaction, but as far as I know I did open & close it only once for each query, right? My best guess is that somewhere the transaction isn't closed (internally)... How can I solve this problem? Thx! G00fy, (aka KaReL, aka Steven) Main Webpage : http://komma.cjb.net CQ Database : http://lid.fragland.net/ ICQ #: 35217584