Search found 5 matches

by Jona
04.07.2008, 09:42
Forum: MySQL
Topic: Time conversion > 24 hours returns zero
Replies: 2
Views: 762

Hi Ben,

casting the result to a CHAR value did the trick.

Many thanks,
Jona
by Jona
03.07.2008, 16:02
Forum: MySQL
Topic: Time conversion > 24 hours returns zero
Replies: 2
Views: 762

Time conversion > 24 hours returns zero

Hi All, I've tested following query on the MySQL Query Browser: SELECT SEC_TO_TIME(86500); which returns 24:01:40 (as it should be). Now if I set up a simple Delphi form with following components: ZConnection --> ZQuery --> Datasource --> DBGrid and execute the same query it returns 00:00:00 in the ...
by Jona
15.01.2008, 17:01
Forum: MySQL
Topic: DBLookupComboBox: variant error
Replies: 6
Views: 1962

I've managed to fix the problem. Seems it's related to building the application with or without runtime packages.
If the 'build application with runtime packages' option (in project options) is checked the DBLookupCombobox works flawless.

Best regards,
Jona
by Jona
15.01.2008, 10:01
Forum: MySQL
Topic: DBLookupComboBox: variant error
Replies: 6
Views: 1962

Hi Mark,

attached source code from a small sample application + DB create and some instructions.

Thanks,
Jona
by Jona
14.01.2008, 15:07
Forum: MySQL
Topic: DBLookupComboBox: variant error
Replies: 6
Views: 1962

DBLookupComboBox: variant error

Hi everyone, I'm using Delphi 7 + Zeos 6.6.1 beta + MySQL5 and have a table TC where field TCTypeID refers to a value in table TCType. On a form I've added a DBLookupCombobox and set it's parameter like: DataField = TCTypeID DataSource = DSTC ListSource = DSTCType ListFieldName = TCType KeyFieldName...