Zeoslib Portal

Hello, You didn't write what database server do you use. I had the same problem. I found solution for PostgreSQL. There have to be made changes in ZPostgreSqlToken.pas: procedure TZPostgreSQLQuoteState.GetQuotedString(Stream: TStream; QuoteChar: Char; EscapeSyntax: Boolean; var Result: String); cons...

OK, here is a solution for PostgreSQL. There have to be made changes in ZPostgreSqlToken.pas: procedure TZPostgreSQLQuoteState.GetQuotedString(Stream: TStream; QuoteChar: Char; EscapeSyntax: Boolean; var Result: String); const BackSlash = Char('\'); var ReadChar: Char; LastChar: Char; QuoteCount: In...

Found it. It's not about nested brackets. It's a problem with escape character "\". Examples (for PostgreSQL): SQL.Text:='select field1|| ''\\n'' ||field2 from tab where 1=1 and (field3 iLike :param)'; Everything is OK with Params but I get "\n" string in the result text. SQL.Tex...

I have the same problem with version 7.2 3929. Or maybe not the same but I have the same error. For "and (I.nazwa iLike :nazwaFiltr)" everything works fine, but for "'and ((B.nazwa iLike :nazwaFiltr) or (B.skrot iLike :nazwaFiltr)) '" I've got "Parameter not found". May...

Hi, For now I've noticed difference beetwen field types for "SR.opis": - without parenthesis: TWideMemoField - with parenthesis: TWideStringField with Size=0 I'm still looking for some solution. Is it good idea to ignore only parenthesis with "select" clause (or all FSectionNames...

I'm using ZeosLib (rev 806) with Delphi 2010 and PostgreSQL 8.4.3. I've noticed strange behaviour during using joins in queries. Fields of "text" type shows strange characters when I use parenthesis with join in query. Example: select SR.*,STA.opis as status_opis, R.nazwa as rodzaj,P.data_...