Zeoslib Portal

I think that what you are asking is imposible to do with components alone. You must do that in the sql queries, but first you need to instruct your database engine about how to reach remote server from local one (ask your dba, that depends on your data engines). If your servers are homogeneous (same...

I'm aware about the portability issues, that's why I enforce the variable thing with a loader. How the language file is constructed is not the matter, I suggested ini files just because they are standard (I think), but can be any kind of text files (one string per line).

one of my approaches was to use variables and a kind of ini files for each languages with a loader. but you must provide some ini files with your app, if none is provide it defaults to english strings. it even works with resource strings, but it complicates the loader. i think that we can drop the r...

Hi my dear friends, I was trying to build a localization solution. I found it's a bit of pain in the butt. The other thing I try, was to make all languages available on run time to be able to switch upon a conditional property, unfortunately this ends in a big footprint. I also try to build dynamic ...

I had this problem too, long time ago. My solution was to put the share and data folders in the same folder as the application and the dynamic library. You must set the database parameters accordingly to point to the right paths. In the data folder you must have a mysql folder containing this tables...

Which is the SQL engine you are using?
I use filters against MySQL without troubles, but only for strings using quotedstr() function around variables, never tried integers or anything else.
Did you try that instruction in an interactive client first?

You welcome, don't esitate to ask when in troubles. Many in the forums can help you!

I foresee a minor trouble, there are some specific errors por FPC. I'm not used to FPC, neither know if the resource reassignment will work. Anyway will write the helpers for Delphi, maybe you can fix it for FPC.

I recomend you to update to ZeosLib 6.6.6, you will be able to use mysql-5. It's very stable, I use it with delphi from 5 to 2007 without troubles. Also have a look on your delphi installation, it may has an older mysql dll that causes many troubles, just remove or replace it with a newer one. About...

String resources can be loaded from a file (one file for each language, just the Zeos strings, trying to load messages for every every sql engine is an unneeded pain). If no string file available, you use the default language, english. That way you don't overload the lib with unneeded resources, and...

may it be possible to add a language property in the zconnection component?

you welcome. but the one that deserve the credit and our thanks is you, keep doing that excellent work.

What I'm trying to mean, is that the protocols' list need to be simple. For example, in ZeosLib 6.x there are 5 entries for mysql: mysql, mysql-4.1, mysql-5, mysqld-4.1 and mysqld-5. Some other protocols has more entries. What I suggest, is to have a simpliest list: mysql and mysqld, and then intern...

Maybe you are right, but having that huge list of protocols can be confusing. I favor simplicity, instead, may I suggest you to put that on a documentacion topic, as well as the long list of other protocols' versions. Aren't you already looking for connection libraries internally? It can't be too mu...

As far as I know, there's no need for another protocol. MariaDB is 100% binary compatible with MySQL, same names, same libraries, just coded differently. In my tests, I put the MariaDB engine over the old MySQL, and used the same data files without troubles, it worked fine. From the engine side ther...