Zeoslib Portal

Hi, According to PG documentation, see this: http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS PostgreSQL is going to stop tolerate escaping characters in literal strings. Currently I got warnings about this (nonstandard using of backslash as escaping character) an...

I use ZeosLib since 3-4 years: Delphi 7/10/BDS06 + MySQL + PostgreSQL. Having 8 offices countrywide, a centralized DB server (Postgresql) with some 300K max rows in a single table I still did not experience any crucial problem using Zeos. I firmly recommend Zeos for production environment, even 6.6....

Just to note that Field.Required property should play its role here. I mean at some stage of the logic it is important if that property is True or False. Honestly, this issue is kinda foggy and must be treated very carefully and must cover every single hypothesis (combination of server+driver+user)....

This is a pretty old thread but I'd like to add my 0.02: It might be connected to the AutoGeneratedValue TField property. As far as I can see Zeos does not implement this feature. Quote form Delphi 10 Help: TField.AutoGenerateValue Property Indicates whether the field values can be generated by the ...

[quote="bangfauzan"]Try to reset your such properties, and run again. Make sure that the first thing you do is setting sorttype property, then sortedfields.[/quote] I think this requirement (to set something in a certain order) is a bad behaviour! Either both should be set at once (one fun...

Oops.. sorry... SortedFieldDirs

I am little bit lost here. I did not test all of this "sorted fields" issues but looking at the source I am under impression that the only construction possible is like this: .... ORDER BY Field1,Field2,Field3,Field4 ASC but what about this one: .... ORDER BY Field1 ASC, Field2 DESC, Field...

Hi, As far as I am aware if you connect the DB at Design Time (for example if you set a ZConnection's property Connected=true) you need all DLLs in Windows Sytem32 directory. At run time they must be either in Win/system32 or in the current (executable program) directory. Suggestion: Copy all DLL to...

Never used Zeoslib testing suite but will give it a try. I am using Zeos since 3-4 years with D7 and Postgresql. The reason I come back here was because an upgrade is underway: PostgreSQL 7.4 -> 8.1.5 and D7-> BDS 2006. I'll take the oportunity to ask all people here if the ZeosLib for BDS 2006 (Del...

I got the same "Range check error" and instead of {$R-} I suggest the folowing: --- C:/Temp/Zeos/src/plain/ZPlainPostgreSqlDriver.pas (revision 162) +++ C:/Temp/Zeos/src/plain/ZPlainPostgreSqlDriver.pas (working copy) @@ -992,7 +992,7 @@ decoded:=ZPlainPostgreSql8.PQunescapeBytea(pansichar...

Hi, Here is: D7, Postgresql 7.4.x, Zeoslib 6.5.1 I use "6.5.1-alpha" since it was released, in a real, real, production environment. No problems at all, at least problems one would expect from "alpha"s. I'd say that current "alpha" is rather "gamma" by means o...