select linkfile.*, aNodes.x as x1, aNodes.y as y1,; bNodes.x as x2, bNodes.y as y2,; abs(aNodes.x-bNodes.x) as dx, abs(aNodes.y-bNodes.y) as dy,; ' ' as stddir, ; ' ' as lh_node,; .f. as _used ; from linkfile ; left join (lcNodefile) aNodes on linkfile.A == aNodes.n ; left join (lcNodefile) bNodes on linkfile.B == bNodes.n ; where st_name <> ' ' ; order by st_name ; into cursor crsOriginalLinks readwritebut when I change the 5th line to
select linkfile.*, aNodes.x as x1, aNodes.y as y1,; bNodes.x as x2, bNodes.y as y2,; abs(aNodes.x-bNodes.x) as dx, abs(aNodes.y-bNodes.y) as dy,; ' ' as stddir, ; min(linkfile.A,linkfile.B) as lh_node,; .f. as _used ; from linkfile ; left join (lcNodefile) aNodes on linkfile.A == aNodes.n ; left join (lcNodefile) bNodes on linkfile.B == bNodes.n ; where st_name <> ' ' ; order by st_name ; into cursor crsOriginalLinks readwriteI get an error on the changed line that says "Function name is missing ')'." Any suggestions as to what is happening and how to fix it?