This is or was an issue with the
With Adoquery2 do
begin
...
end
when using name
in the sql, it was really getting adoquery2.name
not the var name. I fixed this by changing name
to Cname
had no more issues after that.
1
solved SQL not finding results