Zeoslib Portal

silvioprog

Hello,

I've implemented the SQLite 3 Run-Time Load Extension[*] in my Zeos copy, and I wan to send it to the Zeos community. So, is there any place to I send a patch with my chances?

Thank you!

[*]

Code: Select all

TZSQLiteConnection.LoadExtension(<ext.dll/ext.so>)

silvioprog

Yes, it's works, this solution fixed the error definitely.

Thanks boys.

silvioprog

If you enable the directive {.$DEFINE MYSQL_STRICT_DLL_LOADING} (in Zeos.inc) your code not works?

silvioprog

Finally, after 3 more weeks...

No problems.

Can you dig deeper into the UncachedGetColumns procedure?

Yes... hmm, but how to I make this?

silvioprog

Hi Mark, excuse for my delay. :) I changed the code for: procedure TZInterbase6PreparedStatement.Prepare; begin LogPrepStmtMessage(lcPrepStmt, SQL); StmtHandle := nil; with FIBConnection do begin StatementType := ZDbcInterbase6Utils.PrepareStatement(GetPlainDriver, GetDBHandle, GetTrHandle, GetDiale...

silvioprog

Hi Mark, Not always 10 seconds, sometimes faster, sometimes slower. Call stack: #0 fpc_raiseexception at :0 #1 CHECKINTERBASE6ERROR({<IZPLAINDRIVER> = {<IUNKNOWN> = {}, }, }, #1#249#1't'#4#152#1#19#4#1#4#1#0'H'#158'X'#234'X'#152'p'#138, LCEXECUTE, 0x0) at C:\Repository\svn\zeos\src\dbc\ZDbcInterbase...

silvioprog

Hi Mark, I put the breakpoint, the error happens before it: http://imagebin.org/112711 The error also happens in Delphi(7): http://imagebin.org/112709 This error is present only in Zeos-7(SVN), in Zeos-6.6.6 is ok. ps. Excuse, I could not translate this part: " Does it always take that long? &q...

silvioprog

In FlameRobin worked perfectly, please see:

http://imagebin.org/112383

silvioprog

Hi Mark, please excuse me

Using this code:

Code: Select all

procedure TForm1.ZSQLMonitor1Trace(Sender: TObject; Event: TZLoggingEvent;
  var LogTrace: Boolean);
begin
  Memo1.Text := Event.AsString;
end;

I receive this:

http://pastebin.com/chfhxazt

It's the information than you need?

silvioprog

Hi Mark,

My SQL:

Code: Select all

SELECT * FROM TABLETEST
ORDER BY OID

My table:

Code: Select all

CREATE TABLE TABLETEST
(
  OID integer NOT NULL,
  FIELD varchar(50),
  CONSTRAINT PK_OIDTABLETEST PRIMARY KEY (OID)
);

silvioprog

Patch to reproduce error in attached.

silvioprog

Steps to reproduce the error: 1. Compile and open the project ; 2. Click in the edit button; 3. Click in the save button; You will see the error as image attachment. In Zeos 6.6.6 is normal, the error is in the current version of SVN. Windows7, Zeos7(SVN), Lazarus 0.9.29 r27109 FPC 2.4.3 i386-win32-...

silvioprog

Hi again guys,

A simple sample in attached.

Thansk

In run: http://imagebin.org/98510

silvioprog

Thanks for the excellent work. I did tests again and the component is working perfectly well. :up: Please, I updated my SVN and did not see the updated files ( ZPgEventAlerter.pas, ZComponentReg.lrs ...). :( Is there any estimate of when the component is released in the palette of Lazarus ? See ZPgE...

silvioprog

I do not understand you, I was shown this early in the thread:

silvioprog Posted: 18.05.2010, 16:48 (No subject)
Double quote ("1") mark in integer field, this works? I uses ('1').

But no problems, serves as a lesson for me.

Zeoslib Portal

Search found 42 matches

Re: 7.2-Beta testers-thread

Error when I try to edit and save data without modification