Zeoslib Portal

Sorry for the delayed response, it seems to be working, I replaced all the search_path lines with the direct query from the connection and been testing to see if there's any issue. I still haven't found any. Thanks for the attention! Altho I prefer the other way, concatenating commands in the query,...

will that work in a multi-layered system?
Since the executedirect will be ran directly on the database before the query gets assembled and executed, some other query might be ran in the meantime, won't that cause issues?

I tried adding it but the error is still thrown. The code that I'm doing that is throwing the error is in the image below: https://prnt.sc/agusyUNZB9B_ procedure TLicenca.LimparAuth; var teste: string; begin with FQuery do begin SQL.Clear; if not Schema.IsEmpty then SQL.Add('SET search_path = ' + Qu...

sorry for late response, been trying to apply what you suggested but still doesn't work. Tried applying directly as a param of ZConnection, tried applying it as a properties attribute of ZQuery, tried doing this in runtime but still didn't work. Same error happens what am I doing wrong? I'm trying t...

Hi, I'm updating my system from Zeos 7.2.14 to latest 8.0.0 release and my queries are throwing this error now with PostgreSQL 15. The queries requires a schema so before any SQL query I concatenate SET search_path = %s; so, for an example, I concatenate queries like: Query.SQL.Add('SET search_path ...

Hi there people, I'm having some troubles with ZeosLib. I've made all the instructions to compile it, but still I didn't make it. The package that I'm using is the latest version from svn, the package Delphi16 which I suppose that is the version of XE2. I'm using a Windows 7 64bits and DelphiXE2. I'...