Zeoslib Portal

Sorry, I'm not quite sure what you are trying to do. I see problem like this:
select from KEYWORDLIST
everything that contains REQUIREDKEYWORD
and not contains any of the NEGATIVEKEYWORS

Am I right?

btray77 , It seems that you have some syntax errors in SQL (KEYWORD instead KEYWORDS). Try this: Select * From KeywordList As K Left Join NegativeKeywords As NK On NK.keywords = K.Keywords Left Join RequiredKeywords As RK On RK.Keywords = K.Keywords Where NK.Keywords Is Null And ( Not Exists ( Sele...

TZStoredProc.ParamByName('MyDATE').asString:= '' behaves correctly - it raises conversion error because empty string can't be converted into date (and empty str is not null either).
For NULLs , there is Clear method e.g. TZStoredProc.ParamByName('MyDATE').Clear

Hi Mark,

I've been worried that bug tracker is "lost". Meantime, I figure out how to use it.

After looking at the demo. ? I'm guessing the ZQuery1AfterPost procedure and then call ZQuery1.Refresh; Yes, something like procedure TForm1.ZQuery1AfterPost(DataSet: TDataSet); begin DataSet.DisableControls; try DataSet.Refresh; finally DataSet.EnableControls; end; end;

carlocat,

i did some tests with your example and can confirm same problem in Delphi2007 (so, it's not D2009/10) issue. Problem disappears when ZQuery1.Options[doDontSortOnPost] := false so I think this bug is not directly related to Bookmars.
Can someone else confirm this?

Hi,
If you mean ssh tunnel with php, all you need to do is to setup port forwarding and connect ZConnection to local (forwarded) TCP port. From ZEOS point of view, there is not difference between forwarded port to database and "direct". This is networking problem.

btray77,
FB2.1 supports UPDATE OR INSERT statement so this is quite easy to solve (see attached example).
Take a closer look at ZUpdateSQL1.InsertSQL|ModifySQL props.

Hi,

Since v8.2, postgresql client library on linux comes with different version (and name) :
<= pg 8.1 - libpq.so.4
>= pg 8.2 - libpq.so.5

New library is backward compatible so it's easy to add support for it. Patch against /branches/testing rev. 803 is attached.

Everyone are probably aware of this or .. not.. ?

Hi,
try to put in ZConnection.properties

sslmode=require|prefer|allow

Wild_Pointer , the connection handle should only be stored on Connection class. Other classes should get this handle via get method. TZPostgreSQLConnection has method function GetConnectionHandle: PZPostgreSQLConnect so why not use it? That sounds like elegant solution. I'll try your patches. what ...

It is same problem Yapt was talking about. Please see more on http://zeos.firmos.at/viewtopic.php?t=2 ... ht=quantum

Rev.779 doesn't completely solve problem (Lazarus64 wont work). I posted (maybe) final solution here: http://zeosbugs.firmos.at/file_download ... 0&type=bug. More info: http://zeosbugs.firmos.at/view.php?id=216

yapt , I investigated this further and (maybe?) solved problem completely. Attached pactch against rev776 solves all my problems and maybe yours also. Please try it. Modifications from last patch are included in file. P.S. Also corrected possible problem with unassigned ApplicationHandleException p...