Zeos for Lazarus is officially ported!

[hombergs]

I did a small test using the firebird 1.5 employee sample database,  it seems to have problems with some numeric fields? check for example the DEPARTMENT and SALARY_HISTORY tables, here is a link to the lazarus project: http://mx.geocities.com/jesusrmx/lazarus/zeos_fbbrowser.tgz

I found the problem.
When you use the EditFormat (TDbEdit) or DisplayFormat (TDbGrid Column) propertie the Access Violation will not occur.
So i will get deeper into it.

[Stevie]

Think I found the bug and submitted it to the FreePascal-Bugtracker (http://www.freepascal.org/bugs/edit.php3?ID=3957)

[hombergs]

Bug ID 3957 is fixed in the CVS.

[jesusr]

great, it works. I tried to install in windows, had some minor problems and it's working ok too.

The kind of problem is as follow for several files:

Index: ZDbcMetadata.pas
===================================================================
RCS file: /cvsroot/zeoslib/zeosdbo_rework/src/dbc/ZDbcMetadata.pas,v
retrieving revision 1.39
diff -c -r1.39 ZDbcMetadata.pas
*** ZDbcMetadata.pas   4 May 2005 16:22:40 -0000   1.39
--- ZDbcMetadata.pas   11 May 2005 04:57:54 -0000
***************
*** 47,53 ****
  {$ENDIF}
  {$IFDEF VER130BELOW}
    {$IFDEF WIN32}
!     Comobj,
    {$ENDIF}
  {$ENDIF}
    Classes, SysUtils, Contnrs, ZSysUtils, ZClasses, ZDbcIntfs, ZTokenizer,
--- 47,53 ----
  {$ENDIF}
  {$IFDEF VER130BELOW}
    {$IFDEF WIN32}
!     //Comobj,
    {$ENDIF}
  {$ENDIF}
    Classes, SysUtils, Contnrs, ZSysUtils, ZClasses, ZDbcIntfs, ZTokenizer,

I didn't offer the patch because I know too little about zeoslib internals

[Edwin]

Hi,

Good work! I just downloaded the latest CVS.
Three questions:
1. I am trying to set a master-detail relation between two queries by using a Param in the SQL statement of the detail query. In Delphi this works but in Lazarus the detail query is empty. How can I solve this (I'd rather not use the 'Mastersource' option)?
2. Is there a problem with the Date type because all the years are displayed as 1899?
3. Is there ever going to be a Field Editor (like in Delphi)?

Thanks,

Edwin

[Anonymous]

Hi,

I've got a problem with using zeoslib with sqlite and mysql. Storing data works just fine, but to retrieve information from the database I have to use a construction with "ZQuery1.Open" which produces an exception regardless in what situation.
The error code returned by the debugger is: "Project project1 raises exception class EZSQLException."

Thanks in advance

[janhsh]

I've got a problem with installing  zeoslib

in zcompatiblity.pas  on line 170

  LText := PChar(S);

--> error "Illegal type conversion Shortstring to ^Char"

Thanks in advance

[Stevie]

Did you check out the lazarus-versions of packages also?
Either you did not or you deactivated the "Delphi comapatible"-Compilerswitch. (-Sd)

[romekf]

I've got another problem with instaling zeoslib

in zdbconnection.pas line 331

Analyser := TZGenericStatementAnalyser.Create;
Argument can't be assigned to

[Stevie]

Do you have the latest version of lazarus???
I had this error with one version weeks ago, but it is already fixed.

[romekf]

Now i have the latest version of lazarus and instaled zeoslib:)
I have one more question: where is fields editor or something similar to add at design time fileds to TZquery?

Best regards
Romek

[Anonymous]

Why is the master-detail relation through the Datasource property (so with a :Param in the SQL) of ZQuery not working?

Thanks,

Edwin

[Stevie]

@romekf: This should be implemented by lazarus i.e. the lcl.

@Guest: I think, this is also a problem with missing implementation within the lcl (db.pas)

[Edwin]

@Stevie: Thanks for your reply.
I don't think it is a problem within the lcl, because using UIB (with TFBDataset) it is working!

Another thing: what is wrong with the Date field (everything is 30/12/1899)?

By the way, I'm using Firebird 1.5.


Thanks,

Edwin

[Anonymous]

I tired to compile the lastest cvs snapshot, but I've got the following messange:
/usr/lib/lazarus/zeos/src/component/ZSqlStrings.pas(63,5) Warning: Constructor should be public
/usr/lib/lazarus/zeos/src/component/ZAbstractRODataset.pas(57,19) Hint: Type "TUpdateStatus" redefinition
/usr/lib/lazarus/zeos/src/component/ZAbstractRODataset.pas(261,15) Error: There is no method in an ancestor class to be overridden: "TZAbstractRODataset.CheckFieldCompatibility(TField, TFieldDef)"
/usr/lib/lazarus/zeos/src/component/ZAbstractRODataset.pas(334,14) Warning: An inherited method is hidden by "TZAbstractRODataset.Locate(const AnsiString,const Variant, TLocateOptions):Boolean"
/usr/lib/lazarus/zeos/src/component/ZAbstractRODataset.pas(379,1) Fatal: There were 1 errors compiling module, stopping

I removed the "override" from the end of the
procedure CheckFieldCompatibility(Field: TField; FieldDef: TFieldDef); override; line, but
when I tired to compile the stuff the next error is
/usr/lib/lazarus/zeos/src/component/ZStreamBlob.pas(1,1) Fatal: Can't find unit DBConsts