Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
'Tis a bit late of a response, but worth saying. Reports of Delphi's demise have been bandied about for well over a decade. Although it has dropped in market share during that time, it still is a viable and used language. Our firm uses it in one of our key projects because (quite frankly) nothing else will give us the productivity coupled with the performance we need. John Elrick Fenestra Technologies Timothy A. Sawyer wrote: > 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: tsaw...@mybowlingdiary.com > > > -Original Message- > From: "Rajesh Nair" > > 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" > 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: sqlite-users-boun...@sqlite.org >>> [mailto:sqlite-users-boun...@sqlite.org] 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 > > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.9.3/1788 - Release Date: 11/14/2008 > 1:36 PM > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
*Dear Cariotoglou Mike* I was actually waiting for your reply. Ok, No problem. I can understand the work loads. But keep in mind that your utility will be useful to many of the sqlite-users. If you get time ( after two-three months ) please develop it in such a way that I have discribed in previous mail. Myself and someone watching our conversation will be waiting for that. Thanks and Good Luck. Rajesh Nair On Fri, Dec 12, 2008 at 2:21 PM, Cariotoglou Mike wrote: > No I am not in vaccation, I wish! I am rather busy this period, so no, I > will not be able to do wthat you wanted, for the next couple of months or > so... > > > > From: sqlite-users-boun...@sqlite.org on behalf of Rajesh Nair > Sent: Thu 11/12/2008 8:55 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > > Dear Cariotoglou Mike, > Are you in vaccation? I am attaching the previous emails that I have send. > If you are trying or planning to work on the same please inform, so that I > can hope that some thing is going to happen > > -- Forwarded message -- > From: Rajesh Nair > Date: Thu, Dec 4, 2008 at 8:13 PM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > To: General Discussion of SQLite Database > > > Dear Cariotoglou Mike, > > I am using VC++ for last 6 years to develop utilities and some small > projects. Formerly I was using MS-ACCESS and/or some database classes in my > projects. Once I felt the power of sqlite I started using it from 2003 / > 2004. After that I have not used any ADO / ODBC for my databases. I have > felt the easyness of the moto "NO CONFIGURATION" of sqlite. I have > developed > some very use full VC++ classes to handle the sqlite database file. I was > producing reports with my-own list-view control. Now some simple formated > reports are developed but if any changes in the report will result a total > EXE replace. That's why I am trying some external utility that could > support > my EXE to produce simple formated reports. > I noticed that your DLL can open some FR3 or some FRF extention files. > > THE NEED IS THAT REPORT FORMAT WILL BE SAVED AS AN EXTERNAL FILE OF THE > FORMAT THAT YOUR DLL CAN READ AND ALLIGN THE REPORT-VIEWER WINDOW FOR > PRINTING. > > The dataset that you specified can be XML or sqlite database itself. If you > are planning to find some time to support sqlite ( as you found some time > to > develop the Sqlite3Explorer ) then please keep some points in mind while > rebuilding the DLL. > > 1) The dll can be used for both DESIGNING and PRE-VIEWING. > 2) The dll can be used to either DESIGNING or PRE-VIEWING > according to > some parameters passed in to it. ( ie. If the HOST EXE needs > only pre-viewing the > report then the DESIGNER window must not appear. The designer > mode will > be shown on demand specified by a param passed to the DLL) > > If I get such a DLL then I will be using the same for my further projects > and will also gradualy replace the method that I was using to show-report. > If some others those who are using sqlite with VC++ / VB or some other > WIN32 > platform programs may try to use it. > PLEASE INFORM > > Thanks > Rajesh Nair > > > On Mon, Nov 17, 2008 at 5:18 AM, Cariotoglou Mike <[EMAIL PROTECTED]> > wrote: > > > here is an idea : I might be able to modify the dll to accept datasets in > a > > different, "standard" format, like XML. > > this would imply that your product would need to retrieve data in > whatever > > format it needs, transform it to my format, > > pass it to the dll which will do the design and reporting. it will not as > > fast as it is now, but it is definately a solution. you would not have > the > > source of the dll, but you could use it freely, no IR issues. > > > > for this to work , the following assumptions must prove correct: > > > > 1. I originally designed the DLL with portability in mind, so it *coul* > be > > transformed as I described. since that time, otuehr developers have > improved > > it. I need to check that they have not introduced dependencies and design > > decisions that would nullify its portability. > > > > 2. that you (or somebody else) actually would benefit from this approach. > > f.e do you *like* the report designer (as seen and used from > > sqlite3Explorer), or is it just something you came across and thought to > > give a try? > > > > I only point this out, because it will take me at least 10-20 hours to do > > this conversion, and it wou
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
No I am not in vaccation, I wish! I am rather busy this period, so no, I will not be able to do wthat you wanted, for the next couple of months or so... From: sqlite-users-boun...@sqlite.org on behalf of Rajesh Nair Sent: Thu 11/12/2008 8:55 AM To: General Discussion of SQLite Database Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer Dear Cariotoglou Mike, Are you in vaccation? I am attaching the previous emails that I have send. If you are trying or planning to work on the same please inform, so that I can hope that some thing is going to happen -- Forwarded message -- From: Rajesh Nair Date: Thu, Dec 4, 2008 at 8:13 PM Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer To: General Discussion of SQLite Database Dear Cariotoglou Mike, I am using VC++ for last 6 years to develop utilities and some small projects. Formerly I was using MS-ACCESS and/or some database classes in my projects. Once I felt the power of sqlite I started using it from 2003 / 2004. After that I have not used any ADO / ODBC for my databases. I have felt the easyness of the moto "NO CONFIGURATION" of sqlite. I have developed some very use full VC++ classes to handle the sqlite database file. I was producing reports with my-own list-view control. Now some simple formated reports are developed but if any changes in the report will result a total EXE replace. That's why I am trying some external utility that could support my EXE to produce simple formated reports. I noticed that your DLL can open some FR3 or some FRF extention files. THE NEED IS THAT REPORT FORMAT WILL BE SAVED AS AN EXTERNAL FILE OF THE FORMAT THAT YOUR DLL CAN READ AND ALLIGN THE REPORT-VIEWER WINDOW FOR PRINTING. The dataset that you specified can be XML or sqlite database itself. If you are planning to find some time to support sqlite ( as you found some time to develop the Sqlite3Explorer ) then please keep some points in mind while rebuilding the DLL. 1) The dll can be used for both DESIGNING and PRE-VIEWING. 2) The dll can be used to either DESIGNING or PRE-VIEWING according to some parameters passed in to it. ( ie. If the HOST EXE needs only pre-viewing the report then the DESIGNER window must not appear. The designer mode will be shown on demand specified by a param passed to the DLL) If I get such a DLL then I will be using the same for my further projects and will also gradualy replace the method that I was using to show-report. If some others those who are using sqlite with VC++ / VB or some other WIN32 platform programs may try to use it. PLEASE INFORM Thanks Rajesh Nair On Mon, Nov 17, 2008 at 5:18 AM, Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > here is an idea : I might be able to modify the dll to accept datasets in a > different, "standard" format, like XML. > this would imply that your product would need to retrieve data in whatever > format it needs, transform it to my format, > pass it to the dll which will do the design and reporting. it will not as > fast as it is now, but it is definately a solution. you would not have the > source of the dll, but you could use it freely, no IR issues. > > for this to work , the following assumptions must prove correct: > > 1. I originally designed the DLL with portability in mind, so it *coul* be > transformed as I described. since that time, otuehr developers have improved > it. I need to check that they have not introduced dependencies and design > decisions that would nullify its portability. > > 2. that you (or somebody else) actually would benefit from this approach. > f.e do you *like* the report designer (as seen and used from > sqlite3Explorer), or is it just something you came across and thought to > give a try? > > I only point this out, because it will take me at least 10-20 hours to do > this conversion, and it would be a big waste of time (mine) to do this just > as an intellectual exercise. I am not asking for financial compensation > here, just to know that I am actually doing something useful... > > > PS another format that would work, besides XML, and that I already have a > lot of code to support would be the ADO recordset. is this an option for you > ? what language are you planning to use in order to host the DLL, and what > database ? > > > > > From: [EMAIL PROTECTED] on behalf of Rajesh Nair > Sent: Sat 15/11/2008 5:53 AM > 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. C
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
Dear Cariotoglou Mike, I am using VC++ for last 6 years to develop utilities and some small projects. Formerly I was using MS-ACCESS and/or some database classes in my projects. Once I felt the power of sqlite I started using it from 2003 / 2004. After that I have not used any ADO / ODBC for my databases. I have felt the easyness of the moto "NO CONFIGURATION" of sqlite. I have developed some very use full VC++ classes to handle the sqlite database file. I was producing reports with my-own list-view control. Now some simple formated reports are developed but if any changes in the report will result a total EXE replace. That's why I am trying some external utility that could support my EXE to produce simple formated reports. I noticed that your DLL can open some FR3 or some FRF extention files. THE NEED IS THAT REPORT FORMAT WILL BE SAVED AS AN EXTERNAL FILE OF THE FORMAT THAT YOUR DLL CAN READ AND ALLIGN THE REPORT-VIEWER WINDOW FOR PRINTING. The dataset that you specified can be XML or sqlite database itself. If you are planning to find some time to support sqlite ( as you found some time to develop the Sqlite3Explorer ) then please keep some points in mind while rebuilding the DLL. 1) The dll can be used for both DESIGNING and PRE-VIEWING. 2) The dll can be used to either DESIGNING or PRE-VIEWING according to some parameters passed in to it. ( ie. If the HOST EXE needs only pre-viewing the report then the DESIGNER window must not appear. The designer mode will be shown on demand specified by a param passed to the DLL) If I get such a DLL then I will be using the same for my further projects and will also gradualy replace the method that I was using to show-report. If some others those who are using sqlite with VC++ / VB or some other WIN32 platform programs may try to use it. PLEASE INFORM Thanks Rajesh Nair On Mon, Nov 17, 2008 at 5:18 AM, Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > here is an idea : I might be able to modify the dll to accept datasets in a > different, "standard" format, like XML. > this would imply that your product would need to retrieve data in whatever > format it needs, transform it to my format, > pass it to the dll which will do the design and reporting. it will not as > fast as it is now, but it is definately a solution. you would not have the > source of the dll, but you could use it freely, no IR issues. > > for this to work , the following assumptions must prove correct: > > 1. I originally designed the DLL with portability in mind, so it *coul* be > transformed as I described. since that time, otuehr developers have improved > it. I need to check that they have not introduced dependencies and design > decisions that would nullify its portability. > > 2. that you (or somebody else) actually would benefit from this approach. > f.e do you *like* the report designer (as seen and used from > sqlite3Explorer), or is it just something you came across and thought to > give a try? > > I only point this out, because it will take me at least 10-20 hours to do > this conversion, and it would be a big waste of time (mine) to do this just > as an intellectual exercise. I am not asking for financial compensation > here, just to know that I am actually doing something useful... > > > PS another format that would work, besides XML, and that I already have a > lot of code to support would be the ADO recordset. is this an option for you > ? what language are you planning to use in order to host the DLL, and what > database ? > > > > > From: [EMAIL PROTECTED] on behalf of Rajesh Nair > Sent: Sat 15/11/2008 5:53 AM > 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 > > > - Origina
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
Dear Cariotoglou Mike, I am using VC++ for last 6 years to develop utilities and some small projects. Formerly I was using MS-ACCESS and/or some database classes in my projects. Once I felt the power of sqlite I started using it from 2003 / 2004. After that I have not used any ADO / ODBC for my databases. I have felt the easyness of the moto "NO CONFIGURATION" of sqlite. I have developed some very use full VC++ classes to handle the sqlite database file. I was producing reports with my-own list-view control. Now some simple formated reports are developed but if any changes in the report will result a total EXE replace. That's why I am trying some external utility that could support my EXE to produce simple formated reports. I noticed that your DLL can open some FR3 or some FRF extention files. THE NEED IS THAT REPORT FORMAT WILL BE SAVED AS AN EXTERNAL FILE OF THE FORMAT THAT YOUR DLL CAN READ AND ALLIGN THE REPORT-VIEWER WINDOW FOR PRINTING. The dataset that you specified can be XML or sqlite database itself. If you are planning to find some time to support sqlite ( as you found some time to develop the Sqlite3Explorer ) then please keep some points in mind while rebuilding the DLL. 1) The dll can be used for both DESIGNING and PRE-VIEWING. 2) The dll can be used to either DESIGNING or PRE-VIEWING according to some parameters passed in to it. ( ie. If the HOST EXE needs only pre-viewing the report then the DESIGNER window must not appear. The designer mode will be shown on demand specified by a param passed to the DLL) If I get such a DLL then I will be using the same for my further projects and will also gradualy replace the method that I was using to show-report. If some others those who are using sqlite with VC++ / VB or some other WIN32 platform programs may try to use it. Thanks Rajesh Nair On Mon, Nov 17, 2008 at 5:18 AM, Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > here is an idea : I might be able to modify the dll to accept datasets in a > different, "standard" format, like XML. > this would imply that your product would need to retrieve data in whatever > format it needs, transform it to my format, > pass it to the dll which will do the design and reporting. it will not as > fast as it is now, but it is definately a solution. you would not have the > source of the dll, but you could use it freely, no IR issues. > > for this to work , the following assumptions must prove correct: > > 1. I originally designed the DLL with portability in mind, so it *coul* be > transformed as I described. since that time, otuehr developers have improved > it. I need to check that they have not introduced dependencies and design > decisions that would nullify its portability. > > 2. that you (or somebody else) actually would benefit from this approach. > f.e do you *like* the report designer (as seen and used from > sqlite3Explorer), or is it just something you came across and thought to > give a try? > > I only point this out, because it will take me at least 10-20 hours to do > this conversion, and it would be a big waste of time (mine) to do this just > as an intellectual exercise. I am not asking for financial compensation > here, just to know that I am actually doing something useful... > > > PS another format that would work, besides XML, and that I already have a > lot of code to support would be the ADO recordset. is this an option for you > ? what language are you planning to use in order to host the DLL, and what > database ? > > > > > From: [EMAIL PROTECTED] on behalf of Rajesh Nair > Sent: Sat 15/11/2008 5:53 AM > 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
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
here is an idea : I might be able to modify the dll to accept datasets in a different, "standard" format, like XML. this would imply that your product would need to retrieve data in whatever format it needs, transform it to my format, pass it to the dll which will do the design and reporting. it will not as fast as it is now, but it is definately a solution. you would not have the source of the dll, but you could use it freely, no IR issues. for this to work , the following assumptions must prove correct: 1. I originally designed the DLL with portability in mind, so it *coul* be transformed as I described. since that time, otuehr developers have improved it. I need to check that they have not introduced dependencies and design decisions that would nullify its portability. 2. that you (or somebody else) actually would benefit from this approach. f.e do you *like* the report designer (as seen and used from sqlite3Explorer), or is it just something you came across and thought to give a try? I only point this out, because it will take me at least 10-20 hours to do this conversion, and it would be a big waste of time (mine) to do this just as an intellectual exercise. I am not asking for financial compensation here, just to know that I am actually doing something useful... PS another format that would work, besides XML, and that I already have a lot of code to support would be the ADO recordset. is this an option for you ? what language are you planning to use in order to host the DLL, and what database ? From: [EMAIL PROTECTED] on behalf of Rajesh Nair Sent: Sat 15/11/2008 5:53 AM 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-user
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
You can download the program here http://www.realpointscorp.com/MGFAQUERY1.rar I use this program myself in my applications. I have some ideas of how to increase it's functions but I do not want to waste my time if no-one else is interested as I use my application software to provide the extra functions. I am willing to work with anyone who is willing to try this software and give me feedback. Have a super one! Merv Rajesh Nair wrote: > 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 >>>> >>>> >>>> - Orig
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. >>>> >
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. P
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] 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
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
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] Sqlite3Explorer Version 3.0 is available
will do asap > -Original Message- > From: Miha Vrhovnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 5:15 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Sqlite3Explorer Version 3.0 is available > > Hi Mike, > > Thanks for updated version, but still no drag n drop support > for opening database files :( > > Regards, > Miha > > "Cariotoglou Mike" <[EMAIL PROTECTED]> wrote on 29.11.2007 9:09:59: > >New version with a lot of enhancements to the user interface, also > >updated to be compatible with the latest sqlite dll. > > > >information, change list and download here : > > > >http://www.singular.gr/sqlite > > > >(New features are described in the link near the top). > > > >Documentation, such as it is, is out of date :) > > > > > >- > -- > >-- To unsubscribe, send email to > >[EMAIL PROTECTED] > >- > -- > >-- > > > > > > > -- > It's time to get rid of your current e-mail client ... > ... and start using si.Mail. > > It's small & free. ( http://simail.sourceforge.net/ ) > > -- > --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- > --- > > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Sqlite3Explorer Version 3.0 is available
Hi Mike, Thanks for updated version, but still no drag n drop support for opening database files :( Regards, Miha "Cariotoglou Mike" <[EMAIL PROTECTED]> wrote on 29.11.2007 9:09:59: >New version with a lot of enhancements to the user interface, also >updated to be compatible with >the latest sqlite dll. > >information, change list and download here : > >http://www.singular.gr/sqlite > >(New features are described in the link near the top). > >Documentation, such as it is, is out of date :) > > >- >To unsubscribe, send email to [EMAIL PROTECTED] >- > > -- It's time to get rid of your current e-mail client ... ... and start using si.Mail. It's small & free. ( http://simail.sourceforge.net/ ) - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] sqlite3Explorer
maybe... otoh, much of the thing's perceived value comes from things like the datagrid functionality. this is DevExpress, and somehow I doubt they have a version for lazarus. still, might have a look... From: John Elrick [mailto:[EMAIL PROTECTED] Sent: Mon 11/26/2007 1:56 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3Explorer Joe Wilson wrote: > --- Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > >> I wish I could "make it for Unix", but it uses a lot of windows-specific >> things, plus it is done >> in Delphi, and since >> Kylix is practically dead, wlll... >> > > I didn't realize it was written in Delphi. > Yes, that would be a difficult port to UNIX - more like a complete rewite. > Mike, It "might" be worth looking at Lazarus. Depending on the VCL components you are using, the port might be easier than you think...albeit non-trivial John - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3Explorer
Joe Wilson wrote: --- Cariotoglou Mike <[EMAIL PROTECTED]> wrote: I wish I could "make it for Unix", but it uses a lot of windows-specific things, plus it is done in Delphi, and since Kylix is practically dead, wlll... I didn't realize it was written in Delphi. Yes, that would be a difficult port to UNIX - more like a complete rewite. Mike, It "might" be worth looking at Lazarus. Depending on the VCL components you are using, the port might be easier than you think...albeit non-trivial John - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] sqlite3Explorer
--- Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > I wish I could "make it for Unix", but it uses a lot of windows-specific > things, plus it is done > in Delphi, and since > Kylix is practically dead, wlll... I didn't realize it was written in Delphi. Yes, that would be a difficult port to UNIX - more like a complete rewite. There's always the WINE Windows emulator, I guess. Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] [OT] "encrypted" e-mail address (was Re: [sqlite] sqlite3Explorer)
On Sun, 2007-11-25 at 13:56 +0200, Cariotoglou Mike wrote: > no, a mistake. the address IS : > mikecar at singular dot gr (mike will also work) > thanks for pointing out the header problem. I was hoping the mailing > list was "hiding" this info, obviously not Publicly accessible and searchable (read harvestable) web archives of mailing lists will do this, hide email addresses. Usually wherever they find anything vaguely resembling an email address, even if it clearly is none -- including parts of my sig [1]. ;) The mailing list server of course does *not* mangle headers on real mail, which would invalidate it. guenther [1] Which, btw, is not a lame attempt to obfuscate my address. -- char *t="[EMAIL PROTECTED]"; main(){ char h,m=h=*t++,*x=t+2*h,c,i,l=*x,s=0; for (i=0;i>=1)||!t[s+h]){ putchar(t[s]);h=m;s=0; }}} - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] [OT] "encrypted" e-mail address (was Re: [sqlite] sqlite3Explorer)
no, a mistake. the address IS : mikecar at singular dot gr (mike will also work) thanks for pointing out the header problem. I was hoping the mailing list was "hiding" this info, obviously not An unencrypted address was plainly visible in the message headers ("From" and "X-Return-Path"). Following the decryption instructions produces a result which has no "@" character in it; where the header address has "@", the decrypted version has "car&.". Is this an elaborate joke, or what? - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] sqlite3Explorer
ooops mail obfuscation was wrong! it is actually : mike atsign singular dot gr (I used ampersand in the original post which was wrong. well, english is not my native lang...) - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] [OT] "encrypted" e-mail address (was Re: [sqlite] sqlite3Explorer)
Cariotoglou Mike wrote: you can't ?! I overdid it, then :) [snip] From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sat 11/24/2007 7:00 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3Explorer the address follows, obfuscated for the usual reasons. to e-mail me, remove any numeric digits and punctuation from the address that follows, and do the obvious substitutions. hopefully spammers will not... m6_i_ke$car(ampersand)(dot)s#i#n#g#u#l#a#r(dot)gr Nevermind the spammers - I can't break that encryption. An unencrypted address was plainly visible in the message headers ("From" and "X-Return-Path"). Following the decryption instructions produces a result which has no "@" character in it; where the header address has "@", the decrypted version has "car&.". Is this an elaborate joke, or what? - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] sqlite3Explorer
you can't ?! I overdid it, then :) I wish I could "make it for Unix", but it uses a lot of windows-specific things, plus it is done in Delphi, and since Kylix is practically dead, wlll... From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sat 11/24/2007 7:00 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3Explorer > the address follows, obfuscated for the usual reasons. to e-mail me, remove > any > numeric digits and punctuation from the address that follows, and do the > obvious substitutions. > hopefully spammers will not... > > m6_i_ke$car(ampersand)(dot)s#i#n#g#u#l#a#r(dot)gr Nevermind the spammers - I can't break that encryption. Nice software, that sqlite3Explorer, by the way. Do you plan to make a version for UNIX? Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3Explorer
> the address follows, obfuscated for the usual reasons. to e-mail me, remove > any > numeric digits and punctuation from the address that follows, and do the > obvious substitutions. > hopefully spammers will not... > > m6_i_ke$car(ampersand)(dot)s#i#n#g#u#l#a#r(dot)gr Nevermind the spammers - I can't break that encryption. Nice software, that sqlite3Explorer, by the way. Do you plan to make a version for UNIX? Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Sqlite3explorer can't open my DB
ok, fine. what baffled me in the first place was the error message: > 4:malformed database schema - near "to": syntax error this is an sqlite error, not an sqlite3Explorer error, so I wonder whether at some point even sqlite would gag at this field type definition...
RE: [sqlite] Sqlite3explorer can't open my DB
Mr. Cariotoglou, I had two tables with unusual schemas. These schemas were acceptable to SQLite but I perhaps I should not have expected Sqlite3Explorer to allow them. The schemas look like the following example: CREATE TABLE dataset_version ( version_id smallint not null , name varchar(32) not null , version_date datetime year to the second not null , ship varchar(9), lcm varchar(5), creator varchar(32) ); The data type for version date was intended as a comment. I changed it to read: version_date datetime not null , and my problem went away. BTW, I really like Sqlite3Explorer. Thank you for a very good product. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Cariotoglou Mike [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 4:56 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Sqlite3explorer can't open my DB Could you please let me know what the problem was ? I am the author of sqlite3Explorer, and perhaps I could fix it. > -Original Message- > From: Downey, Shawn [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 17, 2005 11:45 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Sqlite3explorer can't open my DB > > Thanks anyway. I solved this myself. > > Sqlite3Explorer is more particular about the table schema > syntax than Sqlite. > > Shawn M. Downey > MPR Associates > 632 Plank Road, Suite 110 > Clifton Park, NY 12065 > 518-371-3983 x3 (work) > 860-508-5015 (cell) > > > -Original Message- > From: Downey, Shawn > Sent: Tuesday, May 17, 2005 12:28 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Sqlite3explorer can't open my DB > > Version 1.4 of Sqlite3explorer could not open my database. > The error message is: > > > > 4:malformed database schema - near "to": syntax error > > > > An older version of Sqlite3explorer worked fine on this > database. I am using sqlite.dll version 3.2.1. Does anyone > else have problems with Sqlite3explorer? > > > > Shawn M. Downey > > MPR Associates > > 632 Plank Road, Suite 110 > > Clifton Park, NY 12065 > > 518-371-3983 x3 (work) > > 860-508-5015 (cell) > > > > > >
RE: [sqlite] Sqlite3explorer can't open my DB
Could you please let me know what the problem was ? I am the author of sqlite3Explorer, and perhaps I could fix it. > -Original Message- > From: Downey, Shawn [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 17, 2005 11:45 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Sqlite3explorer can't open my DB > > Thanks anyway. I solved this myself. > > Sqlite3Explorer is more particular about the table schema > syntax than Sqlite. > > Shawn M. Downey > MPR Associates > 632 Plank Road, Suite 110 > Clifton Park, NY 12065 > 518-371-3983 x3 (work) > 860-508-5015 (cell) > > > -Original Message- > From: Downey, Shawn > Sent: Tuesday, May 17, 2005 12:28 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Sqlite3explorer can't open my DB > > Version 1.4 of Sqlite3explorer could not open my database. > The error message is: > > > > 4:malformed database schema - near "to": syntax error > > > > An older version of Sqlite3explorer worked fine on this > database. I am using sqlite.dll version 3.2.1. Does anyone > else have problems with Sqlite3explorer? > > > > Shawn M. Downey > > MPR Associates > > 632 Plank Road, Suite 110 > > Clifton Park, NY 12065 > > 518-371-3983 x3 (work) > > 860-508-5015 (cell) > > > > > >
RE: [sqlite] Sqlite3explorer can't open my DB
Thanks anyway. I solved this myself. Sqlite3Explorer is more particular about the table schema syntax than Sqlite. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Downey, Shawn Sent: Tuesday, May 17, 2005 12:28 PM To: sqlite-users@sqlite.org Subject: [sqlite] Sqlite3explorer can't open my DB Version 1.4 of Sqlite3explorer could not open my database. The error message is: 4:malformed database schema - near "to": syntax error An older version of Sqlite3explorer worked fine on this database. I am using sqlite.dll version 3.2.1. Does anyone else have problems with Sqlite3explorer? Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell)