|
D
Dynamiccomp author
I have the following SQL query, and was trying to change one of the records and I am receiving the following error above. SQL Query SELECT
sub_2.Number,
sub_2.`Rider Name`,
sub_2.`Horse Name`,
sub_2.`Division Name`,
CASE
WHEN sub_2.div_rank = 1 THEN sub_2.`Dressage Time`
ELSE TIME_FORMAT(ADDTIME(`dressage TIME`, SEC_TO_TIME( TIME_TO_SEC(sub_2.`Ride Intervals`) * (sub_2.div_rank-1) )),"%H:%i:%s")
END AS `Dressage Time`,
sub_2.Ring ,
sub_2.`Dressage Judge`,
sub_2.`Dessage Day`,
sub_2.`SJ Time` ,
CASE
WHEN sub_2.div_rank = 1 THEN sub_2.`XC Time`
ELSE TIME_FORMAT(ADDTIME(`XC Time`, SEC_TO_TIME( TIME_TO_SEC(sub_2.`XC Ride Interval`) * (sub_2.div_rank-1) )),"%H:%i:%s")
END AS `XC Time`,
sub_2.`XC Day` ,
sub_2.`SJ Day`,
sub_2.`SJ Judge`
FROM
(SELECT * , @r := CASE WHEN @u = sub_1.`Ring`
THEN @r + 1
WHEN @u := sub_1.`Ring`
THEN 1
END AS div_rank
FROM
(SELECT r.Number,r.`Rider Name`, r.`Horse Name`,
r.`Division Name`,d.`Dressage Time`,d.`Ride Intervals` ,
d.Ring ,
d.`Dressage Judge`,
d.`Dessage Day`,
d.`SJ Time`,
d.`XC Time`,
d.`XC Ride Interval`,
d.`XC Day`,
d.`SJ Day`,
d.`SJ Judge`
FROM `Ride Times` r
LEFT JOIN `Time Setup` AS d ON d.`Division Name` = r.`Division Name` ) sub_1 ,
(SELECT @r := 0) ra ,
(SELECT @u := 0) u ) sub_2I figured it was because of my SQL code, but any idea why I wouldn't be able to edit any field? |
|