Hi Ben,
casting the result to a CHAR value did the trick.
Many thanks,
Jona
Search found 5 matches
- 04.07.2008, 09:42
- Forum: MySQL
- Topic: Time conversion > 24 hours returns zero
- Replies: 2
- Views: 762
- 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 ...
- 15.01.2008, 17:01
- Forum: MySQL
- Topic: DBLookupComboBox: variant error
- Replies: 6
- Views: 1962
- 15.01.2008, 10:01
- Forum: MySQL
- Topic: DBLookupComboBox: variant error
- Replies: 6
- Views: 1962
- 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...