ZMSQL lazarus / 16-Databases ---------------------------------------------------------------------- scons · 2017-10-24 11:58 Hi all, I see on the Wiki of ZMSQL that there is an updated version (0.1.20) but it is not available in the download link nor in the Online Package Manager (1.8.0RC5). Is this available somewhere else ? Thanks ---------------------------------------------------------------------- tatamata · 2017-11-02 15:10 Edgar Fernando Rodriguez Pacheco (edgarrod71@gmail.com) is working on the new version of ZMSQL. As far as I know, he had some problems with compiling the package. You could contact himm dirrectly on e-mail: edgarrod71@gmail.com ---------------------------------------------------------------------- scons · 2017-11-11 10:00 Ok, It is not really super urgent, but I wanted to try the new veriosn since I had some issues with 0.1.19. Thanks for your reply Mr. tatamata ---------------------------------------------------------------------- apexcol · 2017-12-29 03:21 Edgar finished his duty for this year, now it has improvements... executable size is lighter and queries are a little faster.  It has new functions like AddRecord and a better Post on the memory dataset.  you can find all improvements on every edgarrod71@gmail.com comment.  Some I forgot to put.  I'm so sorry for documentation, I hate to document.  Any questions, feel free to contact.  In next message I'll pass the source code... ---------------------------------------------------------------------- apexcol · 2017-12-29 03:24 ***************** SOURCE CODE ************** in attachment, of course ---------------------------------------------------------------------- wp · 2017-12-29 09:01 To anybody interested in checking out this package, before waisting your time: This is a CodeTyhon version, it will not compile with Lazarus. ---------------------------------------------------------------------- apexcol · 2017-12-29 09:30 Don't be so rude, nor so discriminatorial! . I tested this code on Lazarus also, ---------------------------------------------------------------------- wp · 2017-12-29 09:48 What is rude in my response? Sorry if you feel offended. But the package does NOT compile with Lazarus: the package has the extension .ctpkg, Lazarus uses .lpk -> I renamed it to lpk, ok - maybe not needed.the package uses other packages not in the standard Lazarus distribution:   - lz_dbexport --> replace it by lazdbexport   - lz_sdf --> replace it by lazSDF   - lz_sqldb --> replace it by SQLDBLaz   - adFCL --> no idea what this is... Tried to use the standard FCL, but this is already contained.trying to compile: --> errorQuoteCompile package pl_zmsql 6.0.1: Exit code 1, Errors: 1, Warnings: 2 Warning: windres: can't open file `TOQBLinkForm': No such file or directory Warning: windres: preprocessing failed. QBLnkFrm.pas(58,0) Error: Error while compiling resources -> Compile with -vd for more details. Check for duplicates. This is when I gave up. ---------------------------------------------------------------------- Soner · 2017-12-29 13:25 Nice to see that you integrated my changes to jansql so they aren't lost. Tatamata made great job with zmsql but zmsql can be much more faster at least 2 or 4x. He copies the results(TjanRecordXYZ) from jansql to tbuffereddataset. JanSql is very fast, when JanSql can create tbuffeddataset without TjanRecordLists it would be fast. I am thinking to separate JanSql/zmsql to engine (tdatabase) , ttable, tsql like bde. But I am very busy at moment. ---------------------------------------------------------------------- JuhaManninen · 2017-12-29 16:08 Quote from: apexcol on December 29, 2017, 10:30:45 amI tested this code on Lazarus also, How exactly did you test it? I also want to know. ---------------------------------------------------------------------- taazz · 2017-12-29 16:18 doesn't Avra has a tool that converts from typhoon to lazarus package? I think its called ct2laz that should get you started but if my magic ball works correctly (they do have a temper the freaking things) the message posted by WP seems to intigate that the package depends on some sort of port of the Open Query Builder to lazarus or something along those lines. ---------------------------------------------------------------------- wp · 2017-12-29 17:46 It compiles now and can be installed. It was the extension of the form files which had to be renamed to .lfm (was: .frm). [EDIT] Now with simple demo taken from the old CCR version. ---------------------------------------------------------------------- apexcol · 2017-12-29 18:06 Not installing it but using the units... may another tool help you?  https://forum.lazarus.freepascal.org/index.php/topic,28897.15.html ---------------------------------------------------------------------- apexcol · 2017-12-30 01:21 Here, exclusive for Lazarus users (those that don't want to modify nothing... ) Go to the project site and download TZMSQL (latest version), then download this file and Unzip this file inside the directory, there's a lpk file.  Compile, install, enjoy. ---------------------------------------------------------------------- tatamata · 2017-12-30 07:02 Great job, apexcol! Can somebody put this version (ver 1.20.1) to the Lazarus CCR (https://sourceforge.net/projects/lazarus-ccr/files/zmsql/)? ---------------------------------------------------------------------- balazsszekely · 2017-12-30 07:40 According to the lpk file the license is free, however if I open the ReadMe.txt different units have different licenses and they are not free at all. Ok, the package can be used even in commercial application but still not free. Now what is the real license? Can I add it to OPM? ---------------------------------------------------------------------- tatamata · 2017-12-30 07:58 Quote from: GetMem on December 30, 2017, 08:40:22 amAccording to the lpk file the license is free, however if I open the ReadMe.txt different units have different licenses and they are not free at all. Ok, the package can be used even in commercial application but still not free. Now what is the real license? Can I add it to OPM? GetMem, for which units you think that they are not free? I am the original zmsql developer, and for my part it is free completely. I am not aware that any other part of the package is not free. ---------------------------------------------------------------------- balazsszekely · 2017-12-30 08:12 According to ReadMe.txt: QuoteWritten by Zlatko Matic (matalab@gmail.com or matic.zlatko@gmail.com) Modified LGPL and MPL 1.1 license: static and dynamic linkin both allowed, even in commercial applications. Please see the individual licenses in the source files for details Contains: ZMSQL units, including zmbufdataset.pas, zmconnection.pas, zmquerydataset.pas, zmreferentialkey.pas: FPC modified LPGL JanSQL units, including JanSQL.pas, janSQLExpression2.pas, janSQLStrings.pas, janSQLTokenizer.pas by Jan Verhoeven: Mozilla Public License Version 1.1 (MPL) mwStringHashList.pas by Martin Waldenburg: Mozilla Public License Version 1.1 (MPL)LGPL in plain english: QuoteThis license mainly applies to libraries. You may copy, distribute and modify the software provided that you state modifications and license them under LGPL-2.1. Anything statically linked to the library can only be redistributed under LGPL, but applications that use the library don't have to be.  You must allow reverse engineering of your application as necessary to debug and relink the library.MPL 1.1 in plain english: QuoteA weak copyleft license that (unlike version 2.0) is incompatible with the GPL. You must include a notice (specified in Exhibit A of the Fulltext), in each source file. This license allows you to license binaries under a proprietary license, as long as the source code is available under MPL.Those licenses are not free as "free as a beer". PS: It's not nitpicking from my part, it can be any license as far as I'm concern. I just want to know if the license info in the lpk file is the correct one. If you say it's free, I will add it as free to OPM. ---------------------------------------------------------------------- tatamata · 2017-12-30 08:35 Quote from: GetMem on December 30, 2017, 09:12:23 amAccording to ReadMe.txt: QuoteWritten by Zlatko Matic (matalab@gmail.com or matic.zlatko@gmail.com) Modified LGPL and MPL 1.1 license: static and dynamic linkin both allowed, even in commercial applications. Please see the individual licenses in the source files for details Contains: ZMSQL units, including zmbufdataset.pas, zmconnection.pas, zmquerydataset.pas, zmreferentialkey.pas: FPC modified LPGL JanSQL units, including JanSQL.pas, janSQLExpression2.pas, janSQLStrings.pas, janSQLTokenizer.pas by Jan Verhoeven: Mozilla Public License Version 1.1 (MPL) mwStringHashList.pas by Martin Waldenburg: Mozilla Public License Version 1.1 (MPL)LGPL in plain english: QuoteThis license mainly applies to libraries. You may copy, distribute and modify the software provided that you state modifications and license them under LGPL-2.1. Anything statically linked to the library can only be redistributed under LGPL, but applications that use the library don't have to be.  You must allow reverse engineering of your application as necessary to debug and relink the library.MPL 1.1 in plain english: QuoteA weak copyleft license that (unlike version 2.0) is incompatible with the GPL. You must include a notice (specified in Exhibit A of the Fulltext), in each source file. This license allows you to license binaries under a proprietary license, as long as the source code is available under MPL.Those licenses are not free as "free as a beer". PS: It's not nitpicking from my part, it can be any license as far as I'm concern. I just want to know if the license info in the lpk file is the correct one. If you say it's free, I will add it as free to OPM. It is free. Thanks. ---------------------------------------------------------------------- balazsszekely · 2017-12-30 09:15 @tatamata QuoteIt is free. Thanks.Ok then. I will add it to OPM soon. Thanks. ---------------------------------------------------------------------- tatamata · 2017-12-30 09:56 Meanwhile, apexcol, could you please update the zmsql wiki (http://wiki.lazarus.freepascal.org/ZMSQL) with the description of improvements you and Soner have done? ---------------------------------------------------------------------- wp · 2017-12-30 12:51 Quote from: tatamata on December 30, 2017, 08:02:37 amGreat job, apexcol! Can somebody put this version (ver 1.20.1) to the Lazarus CCR (https://sourceforge.net/projects/lazarus-ccr/files/zmsql/)? Done: https://sourceforge.net/projects/lazarus- ccr/files/zmsql/TZMSQL-0.1.20.1.zip/download I also added the two demos and converted the help file janSQL.hlp which is not readable any more today to chm. ---------------------------------------------------------------------- tatamata · 2017-12-30 13:05 Quote from: wp on December 30, 2017, 01:51:02 pmQuote from: tatamata on December 30, 2017, 08:02:37 amGreat job, apexcol! Can somebody put this version (ver 1.20.1) to the Lazarus CCR (https://sourceforge.net/projects/lazarus-ccr/files/zmsql/)? Done: https://sourceforge.net/projects/lazarus- ccr/files/zmsql/TZMSQL-0.1.20.1.zip/download I also added the two demos and converted the help file janSQL.hlp which is not readable any more today to chm. Thank you, wp! ---------------------------------------------------------------------- balazsszekely · 2017-12-30 21:25 I added ZMSQL to OPM. Thanks for your contribution. ---------------------------------------------------------------------- scons · 2017-12-31 09:28 Thanks for these updates ! ---------------------------------------------------------------------- avra · 2018-01-01 11:05 Quote from: taazz on December 29, 2017, 05:18:05 pmdoesn't Avra has a tool that converts from typhoon to lazarus package?Yes, ct2laz is updated now and should be able to convert any CT 6.30+ package to Lazarus. ---------------------------------------------------------------------- hmprof · 2018-01-02 14:44 Thank you for this update.  Is it possible to add a published property named FieldDelimiter to the TZMQueryDataSet component?  This new property can be used for the children's components FCSVExporterExport and FSdfDatasetImport. Schematically: Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i TZMQueryDataSet     FCSVExporterExport.FieldDelimiter := Self.FieldDelimiter;       ...    FSdfDatasetImport.Delimiter := Self.FieldDelimiter; NB: This new property would replace the constant C, see below. Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i unit ZMQueryDataSet;.. const  C: Char = ';';   FSdfDatasetImport.Delimiter := C;      ....   FSdfDatasetImport.Delimiter:= C;      with FCSVExporterExport do begin    ...     FormatSettings.FieldDelimiter:= C; ---------------------------------------------------------------------- wp · 2018-01-09 11:04 This feature has been added to the trunk version of zmsql at https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/zmsql/. ---------------------------------------------------------------------- hmprof · 2018-01-13 07:46 Quote from: wp on January 09, 2018, 12:04:40 pmThis feature has been added to the trunk version of zmsql at https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/zmsql/. @wp Thank you very much for this new feature. That's cool ! ---------------------------------------------------------------------- scons · 2018-01-13 15:58 Quote from: wp on January 09, 2018, 12:04:40 pmThis feature has been added to the trunk version of zmsql at https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/zmsql/. Thanks Mr. wp ---------------------------------------------------------------------- scons · 2018-01-13 16:01 Quote from: Soner on December 29, 2017, 02:25:45 pmTatamata made great job with zmsql but zmsql can be much more faster at least 2 or 4x. He copies the results(TjanRecordXYZ) from jansql to tbuffereddataset. JanSql is very fast, when JanSql can create tbuffeddataset without TjanRecordLists it would be fast. I am thinking to separate JanSql/zmsql to engine (tdatabase) , ttable, tsql like bde. But I am very busy at moment. Can someone confirm this ? Might be interesting.