Zeoslib Portal

Cnliou,

Thank you very much - it's works!

By the way: it's sad to said but PostgresQL team since few versions doesn't take care about previous version compatibility, remember enabling strong type checking in 8.xx?

Thank you once again!

Confirmed: under Sqlite3 the above code works perfectly giving expected results.
Well, so it looks like it's time to bug hunt for me!

I've tested this code against MySQL 5.1 working on Linux server (withe the sdame client written in DelphiXE running on Windows XP) and everything works fine. So it looks like it's Postgres releated problem. Just too be sure I'll test it with sqlite and then will start digging in the code looking for...

Well, as I've wrote above: query works fine and inserts data without any errors or warnings. The problem is that when I use ParamByName the apostrophs inside the parameter string are not quoted as double apostrophe ('' ) but as ASCII literal: '\047' (just four ASCII chars, not char with \047 code!)....

Tested also on SVN rev. 956 - same behavior

OK, the following code is the minimal code example to reproduce bug in ParamByName: junk := 'aaa''aaa'; sql.sql.Clear; sql.sql.Add('insert into dziennik(login,wpis,data) values ('+quotedstr(junk)+', :WPIS, NOW())'); sql.Prepare; sql.ParamByName('WPIS').AsString := junk; sql.ExecSQL; Inserting string...

Any ideas? Patches? Criticism?

Hello, I've got PostgresQL 9.1 running on Linux machine, and I'm connecting to it using Delphi XE with Zeos 7.0.0-dev. My Database works in UTF8, additionally I'm setting the following properities in TZConnection: con.Properties.Add('codepage=utf8'); con.Properties.Add('lc_all=Polish_Poland.utf8'); ...

Does it mean it's the end of the Zeos project...?

Thank you Wild_Pointer!

Hello, I'm connecting to Postgres 8.4 database which sometimes is unavailable. I've no problem with servicing such a situation with 'try ... .finally' however I'm unable to find TZConection's property which hold potential error number or error message (like pg_last_error or pg_result_error in PHP). ...

Well, I'm using threads. What will be ZConnection behaviour in this case? Will it be "blocking queue"?

OK. Doesn't it hurt TZconnection performance?

Hello, I've finished coding stored procedures in my database and now it's time for user interface. I'm coding it in Delphi 7 with (surprise!) ZeosLib ;-) The question is: which model is better from the performance and interoperability point of view? 1) One TZconnection component on the form, reused ...

Jeah, sure! But I'm migrating to Zeos quite big BDE based application (162.000 lines of code) and in few places it uses TTable, mainly for data insertion. I'm planning migration to pure-sql, but as for now I must have it up and running ASAP.