Zeoslib Portal

Yesterday I reinstalled my Windows XP, Delphi 2006, everything, but I've the same problem again....

I've found a bug - StrToFloat doesn't work on NULL values... StrToFloatDef is a better choice... function TMysqlResult.asExtended: Extended; Begin Result := StrToFloatDef(self.FRawString,0); End; function TMysqlResult.asDouble: Double; var full64: Extended; Begin full64 := StrToFloatDef(self.FRawStr...

WOW!

BindColumn rulez i'm not tested yet, but i'll thank you very much!

Have somebody some experience with the MyDAC component pack ? (http://crlab.com/mydac)

it's simple... this code on 15400 records (all columns and rows needed) :

<----------------- 0 second
sql.Open;
<----------------- 1 second
While not sql.Eof Do
Begin
sql.Next;
End;
sql.Free;
<----------------- 10 second

When I change the Delphi code to this :

sql.Open;
While not sql.Eof Do
Begin
sql.Next;
End;
sql.Free;

my program is not faster - Zeos is toooooo slow....

Hello! 1st : sorry for my bad English... Please give me some hint about this problem: :cry: Tables: create table DEF_OBJECT ( ID INTEGER not null, OBJECT_TYPE_ID INTEGER not null, LAST_DETAIL_ID INTEGER not null, INACTIVE TINYINT UNSIGNED not null default 0, INTEGRATED TINYINT UNSIGNED not null defa...

I've checked TZQuery, but there is no RequestLive property. Only hidden in the source code

I'm using TZReadOnlyQuery.... I think it's faster because it's "read only". or not ?

Hi!

I need all 90.000 records, and all columns. This is a table with GPS navigation coordinates , and I use very complex calculations with Delphi.

I've the following piece of code (MySQL 5.0.15 and Delphi 2006). The result is about 90.000 records. #1 execution time is about 2 seconds. #2 execution time is about 15 minutes. Why??? :cry: //#1 list.sql.text := 'SELECT * FROM POSITION_001 ORDER BY D_SECONDS;'; list.open; //#2 while not list.eof do...

thank you

Are there any compiler directives to disable TZQuery, TZTable, TZStoredProc, TZSQLMetadata, TZSQLProcessor, TZSQLMonitor, TZSequance components ? (I need only TZConnection, TZReadOnlyQuery, TZUpdateSQL)

Thank you very much!

How can U install Zeos under D2006 ??? I've "invalid pointer operation" message