Zeoslib Portal

Hello, mdaems,

I have never used test suite so could you please give some reference how to start that?

Also I wanted to ask if there is a detail documentation on what should happen on ExecPorc method?


Wild_Pointer

Hello stepel , I use Delphi 2006 and latest build zeos 7 from svn. I checked and it works ok in folowing case: connection made, query executed, connection broken (I use CurrPorts for that), query executed and exception raised, connection reconnected, query executed (successfully). My guess is you di...

Hello stepel , please tell me if I understand the problem correctly. You have a program witch connects to Postgresql server. After connection is made you restart Postgresql server and then try to reconnect. That's when you get the AV Exception. One question: do you try (and fail) to execute some que...

rchaves , First: There is no problem with your english. Second: if you want filter all fields then you should write "field1 like '%AAA%' OR field2 like '%AAA%' OR ..." (in case you want records having at least 1 field with value like '%AAA%' When you click on grid title you can change the...

h.o.o.k, You can add ZSQLMonitor to your project so see what SQL is send to the server. Maybe this will help you.

Hello h.o.o.k , I don't know how it is in Oracle, but in postgresql procedure either procedure is executed whole or not at all... It is hard to believe, that the Oracle server would interpret query differently just because it was issued by Zeos components :). So maybe the procedure myPROC should be ...

For postgresql: var j : TJpegImage; begin if not od.Execute then Exit; j := TJpegImage.Create; try j.LoadFromFile(od.FileName); if not (qfoto.State in [dsInsert, dsEdit]) then qFoto.Edit; qFotofoto_nuotrauka.Assign(j); j.Free; except ShowMessage(RS_FILE_IS_NOT_JPEG); end; od is opendialog there...

Hello, I tried to implement the opening of postgresql stored functions. It seems to work ok for me. On the other hand I'm not sure if ZStoredPorc.ExecProc is working properly for me. Should the output parameter be filled after calling ExecPorc? With what value if the function returns dataset? Anyway...

vfclists , you can TZConnection.Ping to see if the connection is down, but checking it every time before executing query is not efficient. In stead you could try sometring like that: procedure OpenQuery(AQuery: TZQuery; ARetries:Integer); var _RetriesLeft: Integer; begin _RetriesLeft = ARetries; Wh...

Hello marcov , there is nothing wrong with insert into B (datafield1,datafield2) values (value1,value2) ; insert into AB (AID,BID) values (selectedAID, currval('B_id_seq')); because according to postgresql manual currval returns "the value most recently obtained by nextval for this sequence in ...

You tried ZConnection.ExecuteDirect(CREATE TABLE FOO.... ); and got error ? That's strange. People are using it to create databases and other objects... http://zeos.firmos.at/viewtopic.php?t=2627&highlight= I never tried it on firebird, and never with version 6.6.4. I know it works on postgresql...

akli_agha,

please see http://zeos.firmos.at/viewtopic.php?t=2761&highlight=

good luck!!

akli_agha,
Try using TZConnection.ExecuteDirect instead.

carlocat , Removing the field it works. do you mean that then you remove field1 from TZQuery.SortedFields the record jumping stops ? Have tried using zeos not form testing branch ? Anyway I've tried editing fields and didn't observe the behavior you did. Would you please provide a simple test case?...

h.o.o.k , what programming tool do you use? There have been problems with lazarus users because of the way lazarus does string to float conversions if I remember right. The indication of this would be different result when decimal separator is point and comma. Also please provide the table structur...