Zeoslib Portal

Hi, The settings are: Postgresql : 8.4 Encode: latin1 (on debian) object dbsBanco: TZConnection (V7.1.3a) ControlsCodePage = cCP_UTF8 (not exists Latin1) AutoEncodeStrings = False Properties.Strings = ( 'controls_cp=CP_UTF8') Port = 5432 Protocol = 'postgresql' (or postgresql8) Left = 101 Top = 231 ...

Select...
cast((select f1 from table where cod = a.cod) as varchar(51)) as field_1 (returs string, but size is wrong)
in fields editor on Delphi changed the size property to 51.
that was the solution at the time.

Tks.

Hi,

When trying to connect the following error occurs ZConnection,
on exact time of connection
"Format '% ' invalid or incompatible with argument"
only on Windows XP and Vista.
any idea to solve this?

Tks.

Well, turned par with CAST to VARCHAR (size) and the field editor also put the correct size and it worked!
Tks all !

I'm Sure.
This result should be TwideString (51) not TWideMemo or TWideString (200), do not know why it multiplies the size.

Hi EgonHugeist, Config. DB Encoding - LATIN1 controls_cp=CP_UTF16 TZConnection.ClientCodePage=LANTIN1 sql exemple select a.f1, a.f2, ..., cast((select f1 from table where cod = a.cod) as varchar(50)) as field_1 (returns field_1 type 'memo' with 200 positions, not string) --50 is exactly size of fiel...

Hello guys, when adding fields in ZQuery(add fields) fields with a size of 2 are added with size 4, if 4 = 8 and 50(STRNG) = 200 (MEMO)... each by multiplying the original size of the field. what is the problem? Zeos 7.1.3a PostGreSql 8.1.11 on Debian DB Encoding - LATIN1 Delphi 7 Thank you for your...

Pode ser, valeu.

Obrigado pela resposta. Como a última versão do zeos não vem com a libpq9x.dll imagino que ele ainda não trabalhe
coma as funções da mesma, mas com a versão 8 da dll fica tudo certo.
valeu obrigado pela atenção.

Olá pessoal,
gostaria de saber para que serve a configuração da propriedade do TZconcection
Protocol: postgresql-9, pois mesmo usando a versão 9 do banco ocorre erro (client-library s.), também
não achei uma libpq9x.

Obrigado pela atenção.
Carlos.

Hello folks,

Apparently the location as you typing is ok (version 1411). Now when I add the fileds in fildlist comes all fields readonly = true. Put false for all, will save when the error.
'Cannot update this query type'.

Ok Miab3, com MySQL5 funciona. Mas com o postgresql 8.2 a comobo ficar em um estado muito estranho.Acho que o comportamento errado ocorre apenas com a conexão postgresql.
Tks

Ok Miab3, com MySQL5 funciona. Mas com o postgresql 8.2 a comobo ficar em um estado muito estranho.Acho que o comportamento errado ocorre apenas com a conexão postgresql.
Tks

More,

I tested the package posted by EgonHugeist, and behavior is the same as the video, Revision1403.avi. combo behaving as if no value in the property value data field.

Michael,

In the current version (Revision 1405) nothing works, because the items in the combo can not be selected with the mouse or keyboard. as shown in the video-Problem Revision1403.avi, first combo. It seems that the combo was disabled in this version.