The purpose is only for viewing not altering the data itself.
I can not seem to find the right settings, when I set (see attached example) ZMQueryDataSet2: MasterSource to DataSource1 I get an error: ZMQueryDataSet2: Field not found: "".
I ran the test. Indeed, I had the same error. But this error only occurs in "Debug" mode ! in "Release" mode, everything works well, no errors. That's strange ! Test environment : Lazarus 1.8.0 r56594 FPC 3.0.4 i386-win32-win32/win64TZMSQL-0.1.20.1.zip 2017-12-30 (https://sourceforge.net/projects/lazarus-ccr/files/zmsql/)
Hi scons,Use parameterized queries. Change the SQL for ZMQueryDataSet2 to:
I added a folder for the development version ("trunk") of zmsql to CCR: https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/zmsql/. Use this to get the latest version, new releases will only be published from time to time.