Zeoslib Portal

hum.. good point! This surely needs some testing and documentation exploring. I found something in documetation of MySQL and Firebird. MySQL: the "SET NAMES xxx" command is sent to server just after connecting (look for "set names" on this page: http://dev.mysql.com/doc/refman/5...

About DBC encoding, there are some DBs which define at column level, so we get a default database encoding, a table encoding, a column encoding, a client connection encoding AND resultset encoding override. I beleive that most of those DBs will convert all data to client encoding before sending it ...

I use Zeos with Firebird 2.1. Recently I switched from "stable" Zeos to trunk version and it works well.

If you want to try Zeos 7, go to svn version, don't download the alpha release from last year.

Works now! Thank you! Did you do the 'clean' lazarus build? I tried many things before posting here... I built Lazarus with "make clean all" from command prompt, erased the lazarus configuration folder, then added zeos components as the only third party components and tried to rebuild with...

Zoran , In my opinion zeoslib *SHOULD* behave consistent on the TZQuery level. And the way it works for FB seems to be the only one that's right when the exact nature of the query isn't predictable. Yes, I found this in Delphi manual (bottom of this page ): Tip: When you do not know at design time ...

Since yesterday (rev. 857), Zeos components from trunk cannot be installed in Lazarus. The strangest thing is that the compilation of Zeos package goes well, but Lazarus itself fails to compile with Zeos components installed. See attached image. I had to switch to previous trunk revision (849) and e...

Now, could you tell if I can rely on this? Is this behaviour of TZQuery consistent? I mean, will the Zeos Query always behave so, in any protocol? Eh... No. I tested today with Oracle... Zeos behaves very diferently comparing to Firebird... :( 1. EZSQLException is raised with "ORA-24333: zero ...

Yes! The command had been already executed! I didn't notice it at first because I had put later in my code to roll back the transaction, because of raised exception. Thank you, Mark! Now, could you tell if I can rely on this? Is this behaviour of TZQuery consistent? I mean, will the Zeos Query alway...

That would be a quite acceptable solution... if it worked. However, it does not. :( For test I used Firebird2.1 protocol. SQL statement "alter table TABLE1 add column2 varchar(2)". Then if I just call ZQuery1.ExecSQL, it works well. But, if I try Open and then, in case it fails, ExecSQL, t...

Is there a way to determine if the sql command returns the resultset?

Testing if the word "select" is in command is not reliable. Especially because I don't even know which protocol (which dbms, with its SQL dialect) will be used.