Zeos for Lazarus is officially ported!

[Anonymous]

edit file ZAbstractRODataset.pas

uses Math, ZVariant, ZMessages, ZDatasetUtils, ZStreamBlob, ZSelectSchema,
  ZGenericSqlToken, ZTokenizer,
  {$IFNDEF FPC}
  DBConsts,
  {$ENDIF}
  ZGenericSqlAnalyser ;

[romekf]

edit file ZAbstractRODataset.pas

uses Math, ZVariant, ZMessages, ZDatasetUtils, ZStreamBlob, ZSelectSchema,
  ZGenericSqlToken, ZTokenizer,
  {$IFNDEF FPC}
  DBConsts,
  {$ENDIF}
  ZGenericSqlAnalyser ;

after that we have the following error
Error: Identifier not found 'SNotEditing' line 1210

[romekf]

There are two steps to solve this problem:
1. in section uses add: {$IFDEF FPC}dbconst{$ELSE}DBConsts{$ENDIF};
2. add to pp\units\i386-win32\fcl\dbconst.pp following three lines
  SNotEditing              = 'Not in edit mode';
  SFieldTypeMismatch       = 'Field ''%s'' is not of the expected type';
  SFieldSizeMismatch      = 'Size mismatch for field ''%s'', expecting: %d actual: %d';
  after that you have to compile unit db.pp

[Anonymous]

Thank you, it works.

[sidon]

Hi,  
I'm trying to install the zeoslib in lazarus, I get the zeos code through the CVS repository and lazarus in snapshot site (0.9.7 beta) I got to compile all packages, less the zcomponents, the following errors/warnings occurs :
 
Errors:
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(261,15) Error: There is no method in an ancestor class to be overridden: "TZAbstractRODataset.CheckFieldCompatibility(TField, TFieldDef)"
 
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(345,14) Error: Not all declarations of "GetFieldData" are declared with OVERLOAD
 
All:
"Compile IDE (without linking)" completed
C:\lazarus\components\zeosdbo_rework\src\component\ZSqlStrings.pas(63,5) Warning: Constructor should be public
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(57,19) Hint: Type "TUpdateStatus" redefinition
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(244,15) Warning: An inherited method is hidden by "TZAbstractRODataset.SetFieldData(TField, Pointer, Boolean)"
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(261,15) Error: There is no method in an ancestor class to be overridden: "TZAbstractRODataset.CheckFieldCompatibility(TField, TFieldDef)"
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(334,14) Warning: An inherited method is hidden by "TZAbstractRODataset.Locate(const AnsiString,const Variant, TLocateOptions):Boolean"
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(336,14) Warning: An inherited method is hidden by "TZAbstractRODataset.Lookup(const AnsiString,const Variant,const AnsiString):Variant"
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(345,14) Warning: An inherited method is hidden by "TZAbstractRODataset.GetFieldData(TField, Pointer, Boolean):Boolean"
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(345,14) Error: Not all declarations of "GetFieldData" are declared with OVERLOAD
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(349,14) Warning: An inherited method is hidden by "TZAbstractRODataset.UpdateStatus:<enumeration type>"
C:\lazarus\components\zeosdbo_rework\src\component\ZAbstractRODataset.pas(379,1) Fatal: There were 2 errors compiling module, stopping
____
 
There is a fix?

[Stevie]

Hello,

due to be compatible to lazarus - which still has some missing pieces :-( - I added the used DBConsts to ZMessages.pas.
Sorry for that trouble with non-compileable sources, but at the moment I am working with delphi 2005 and unfortunately I did not check any changes with lazarus if it works on delphi. I will do so in future, so you can get the latest version running on your lazarus. ;-)

Regards
Stevie

[Edwin]

When I connect a Data Control (TDBGrid/TDBEdit) to an active TZQuery I get an 'Unknown Run-Time error : 202'. I use a recent Lazarus and Zeos.
Can this be fixed?

Thanks,

Edwin

[Stevie]

Hi Edwin,

the bug has been fixed.

Regards

[Edwin]

Thanks for your reply Stevie....
but it's not working, still the same error.

Edwin

[Edwin]

A bit too fast....
It is working now.
Thanks Stevie.

BTW, is the problem with the master-detail relation through the Datasource property (so with a :Param in the SQL) of ZQuery going to be solved or do I really have to use the Mastersource property (Query opens a lot slower)?.

[barko]

Stevie,
i have firebird database with field size VARCHAR(32000) in it... if i read from this field with zeosdbo my progy crash... if i change size of this field to size VARCHAR(254), it's all ok... i'm compiling with fpc 2.0.1 and latest lazarus from cvs... zeosdbo is from cvs (latest)...

[Stevie]

Hi Barko,

this is a limitation of zeos (and a known bug, see the knownbug-file). Don't know when it will be fixed. :-/

[Anonymous]

I can't find FindNearest / FindKey function in TZQuery/TZTable. Why ?

[Stevie]

I can't find FindNearest / FindKey function in TZQuery/TZTable. Why ?

Because these methods are not implemented yet ;-)

[dougie]

Hi All,

What must I download to enable me to connect to a MS-SQL 2000 database?

Thanks

Dougie