Search found 2 matches
- 25.10.2006, 09:45
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery problem Delphi 6
- Replies: 4
- Views: 1038
TZquery and dates in MySQL.
I dont know exactly the answer but try to use parameters like "SELECT * from table where date_field=:dDate and time_field=:tTime; var myDate:Tdate; myTime:TTime; myDate:=strtodate(edit1.text). query.parambyname('ddate').asdatetime:=myDate; Anyway I think you have to pass the date in the correct...
- 15.10.2006, 15:37
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: BigLuis
- Replies: 0
- Views: 485
BigLuis
I´m testing rev 113 in Delphi 6 and when I try to execute a store procedure in MySQL 5 on localhost with the component TZQuery with the statement = CALL sp_list_per () appear a error "procedure sp_list_per can´t return a result set in the given context". When a try it with the component TZ...