Zeoslib Portal

Jan, sure, thanks for looking into it. This example project (TestZeos.zip) exhibits the problem. I have provided the mariadb "create" statement and 2 insert statements that you can use to setup a database ("testzeos") on a Mariadb server (here Mariadb 10.3.38) in a Memo-component...

Zeos 7.2.14 Stable, MariaDB, Rad Studio 11.2 These are preliminary test results showing a possible bug for a query with a wildchart. I have a table with 99 columns, and a ZQuery : select * from leveranc where stamnr=:stamnr This table leveranc has a primary key stamnr. I use an update object that ha...

I am also building for C++builder. For the ZDbcAdo error, the reason appears to be that not all .pas files are included in the project files (I have only tested this in the packages/Delphi10.2 - directory). To fix : I have opened the project group, changed the options for each of the projects to &qu...

I use a TZStoredProc component to call a stored procedure which returns a result set. The MySQL user has no privileges on the mysql-system-tables. TZStoredProc by default reads the mysql.proc-table on opening, but this of course results in "SELECT command denied to user '...'" This can be ...

Database : MySQL For TZReadOnlyQuery, not in TZQuery, sorting on a DATE field does not work correctly. So this problem is different from my topic posted yesterday "Sorting of TWideMemo-field" The reason seems to be in ZDbcMySqlResultSet.pas, in method "GetTimestamp", which is cal...

Jan, thank you for your response. About your remark Just make sure that the MemoFields are retrieved as Widestrings Since all this happens in ZDbcCache, as far as I understand, everything has already been retrieved at that point. So what I did (and what seems to work in my setup) is : 1) Taking the ...

Database used : MySQL. When in a TZQuery, the field name of a ftWideMemo-column (from a MySQL TEXT datatype) is assigned to SortedFields, sorting does not work. It did work in 7.1.4 though, and it also works in a TZReadOnlyQuery. The problem can be tracked down to the following code in ZDbcCache, I ...

I tested zeoslib 7.2.1-rc in our project, and noticed that handling of enum columns is broken compared to 7.1.4-stable. Enum-fields should translate to WideString (and did so in 7.1.4), but in 7.2.1-rc *and* also in the current svn-version of testing-7.2 (= r3986 ), in the file dbc/ZDbcMySqlUtils.pa...

I don't know if this helps (it's not completely the same), but this works for me in BDS 2006 (used extensively) : // I do not assign a different stringlist to ->Script, as you do in your last example ZSQLProcessor1->Script->Clear(); ZSQLProcessor1->DelimiterType = dtDefault; ZSQLProcessor1->Script->...

I suggest you search your whole harddisk (specifically c:\users\public documents\rad...\...\bpl) for old versions of your bpl's. Not only your user-dir, but whole harddisk. I have just built and installed revision 809 (from svn://zeos.firmos.at/zeos/branches/testing) in rad studio 2010. I used the d...

Mark, (zonderdank - gij merci),

the diff is against rev. 710. I have added some comment, feel free to remove if it's too long.

Hi, again, first I should correct what I stated in my first post from 24/9: Both a String and a UnicodeString are translated to UnicodeString by dcc when generating hpp files for c++builder 2010 as I said before. But it's not the packed record TZVariant that is the problem. I thought that for TZVari...

Hi, all, Mark, you suggested : Would providing the edited *.hpp header in the zeoslib distribution be useful and practical? Would this not be quite cumbersome to maintain ? I found this link http://edn.embarcadero.com/article/10281 , which at first sight explains the translation of C-headers to pasc...

First, I want to confirm that the patch by cariad above (with the VER210-section in zeos.inc, and the modified tfieldtypes-array in the $IFDEF VER210 in ZAbstractRODataSet.pas) is also necessary for compilation and installation in c++builder 2010, which then goes fine with the projects in the packag...