Search found 9 matches

by hffranzin1
31.07.2024, 21:53
Forum: ZeosLib 7.3/8.0 Forum
Topic: pooled.? PostgreSQL
Replies: 4
Views: 296

Re: pooled.? PostgreSQL

I don't know how to do this, but I copied the components here below... the way I'm using them in my project object ZConection: TZGroupedConnection ControlsCodePage = cGET_ACP ClientCodepage = 'LATIN1' Properties.Strings = ( 'codepage=LATIN1' 'timeout=30' 'Undefined_Varchar_AsString_Length=100' 'RawS...
by hffranzin1
24.07.2024, 01:54
Forum: ZeosLib 7.3/8.0 Forum
Topic: pooled.? PostgreSQL
Replies: 4
Views: 296

Re: pooled.? PostgreSQL

Hi, thanks for the comprehensive explanation.
However, I put pooled.postgresql, and the properties, but without success.
when I put pooled.postgresql it returns an error in any SQL that has (quotes) in the SQL
by hffranzin1
20.07.2024, 13:24
Forum: ZeosLib 7.3/8.0 Forum
Topic: pooled.? PostgreSQL
Replies: 4
Views: 296

pooled.? PostgreSQL

Hello, I'm in an ERP refactoring project, and I came across the need to use several simultaneous connections at random times, and I saw that ZEOS has the pooled.postgresql part, but I would like some guidance on how to use it correctly. . I tried several ways and was unsuccessful... finally I'm usin...
by hffranzin1
18.07.2024, 04:46
Forum: ZeosLib 7.3/8.0 Forum
Topic: Reconnection?
Replies: 5
Views: 217

Re: Reconnection?

I found it, I was checking the postgresql configuration file, and the "enconding_client" line was commented out, I uncommented it and put LATIN1.
And it worked..!!!
Thank you very much !
by hffranzin1
17.07.2024, 15:27
Forum: ZeosLib 7.3/8.0 Forum
Topic: Reconnection?
Replies: 5
Views: 217

Re: Reconnection?

Hello, I understood, I set a 'Timer' running the ping, and the reconnection performed correctly, but it returns invalid characters... In BeforeReconnect I forced the ClientCode to 'LATIN1' but I still wasn't successful Example, return after reconnect NOVA PETRÓPOLIS MONTANHÃO MAUÁ The Correct NOV...
by hffranzin1
16.07.2024, 04:58
Forum: ZeosLib 7.3/8.0 Forum
Topic: Reconnection?
Replies: 5
Views: 217

Re: Reconnection?

Hello, It's certainly something I'm doing wrong, but I don't understand where... Connected in a "normal" way -- Zconnection.Connect; However, when the network goes down, the following message comes back to me. - The connection has not yet been opened Zeos However, Zconnection is true conne...
by hffranzin1
14.07.2024, 01:36
Forum: ZeosLib 7.3/8.0 Forum
Topic: Reconnection?
Replies: 5
Views: 217

Reconnection?

When I lose connection for some reason, I can't get Zconnection to reconnect again...

I tried to use the onlost event but I was unsuccessful

can you help me ? I'm using PostgreSQL as a database and Zeos 8
by hffranzin1
14.07.2024, 01:33
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable ?
Replies: 3
Views: 220

Re: ZMemTable ?

Thank you very much, that's exactly what I wanted to know, how to load data from a query to Zmemtable
by hffranzin1
12.07.2024, 16:18
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable ?
Replies: 3
Views: 220

ZMemTable ?

How does ZMenTable work?

I didn't find any documentation about it...

Thanks