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...
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 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...
Are there any compiler directives to disable TZQuery, TZTable, TZStoredProc, TZSQLMetadata, TZSQLProcessor, TZSQLMonitor, TZSequance components ? (I need only TZConnection, TZReadOnlyQuery, TZUpdateSQL)