[Solved] SQL not finding results

[ad_1]

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

[ad_2]

solved SQL not finding results