Zeoslib Portal

I had a similar problem. Try looking into your .dfm files, not only the .pas ones. Fix both and maybe you'll be fine.

Are you sure that exists a mysql port to mac osx10.6? if so, you need to put the client libraries in the search path, don't know if mac has something like that, try to put them in the same folder as your lazarus binaries and your application, just in case.

I think it is possible. You get the datafields, you convert them to something similar to a csv format, you add them to your string stream, repeat as needed, them you save your stream. To load a stream into component you do it in reverse order. This kind of process can be usefull to make database dum...

mmm... A common SELECT statement must be in the form SELECT field1, field2, ..., fieldN FROM tablename WHERE some_condition Anything you put in the field definition will become a field of your result table (take in mind that any query becomes a logical table), any field can be fetched as a .fieldbyn...

Even in BDE you need to close a query before you assign a new sql sequence. IMHO you are asking for a feature no one will implement.

It seems you need to grant permissions to the user you are trying to connect with. An out-of-the-box installation didn't configure your databases to be reachable over local network. From my experience, I can told you this: - Grant privilege over your database as 'user'@'%' (this need to be done for ...

Also, be sure to have the dlls available on your path, or your application folder.

As long as I'm aware, there's no such thing under Zeos hood v6 stable.

You have 2 ways to execute sql statements:
a) Fill the sql property of a zquery and call execsql.
b) Call executedirect from a zconnection.

execsql is a metod from zquery object. just in case. I think you can send every non select in the same query, call execsql and then set your select statment and open it.

Filters must work with any engine, what you need to be aware of is that the engines are not always datatype compatible. I learned that the hard way. From my experience, ADO and MySQL didn't match 100%, SQLite has a relaxed datatype model (means that it only has 4 general datatypes), didn't try any o...

Hi mates, today I had a similar trouble with unknown MySql data types... after a detailed search, I find the damn cause: I had a dated libmysql.dll inside my delphi bin directory. How this happens, I don't know, but after deleting it, I didn't get any more weird errors again and everything else did ...

Prueba cambiandole el nombre a libmysqld.so, fijate bien que sea libmysqld.so.16. Te recomiendo que pongas esa libreria en la carpeta de tu aplicacion para evitar conflictos con otras apliaciones.

are you aware of the dynamic typing of sqlite? that means you can store anything inside any field. also, there are some restrictions related to primary keys. you need to be aware that there are 4 generic datatypes only and a NULL value. more info here.

get a look in this post http://zeos.firmos.at/viewtopic.php?t=2627 you also need to know that not all datatypes can be used in sqlite.

If the error only happens when you wrote your queries in uppercase, then it's an engine configuration issue. You must check how the postgres server is configured, and try to set it to use case insensitive configuration.