>cSQLPassThrough = [SELECT * FROM MyTable ] + ;
> [WHERE MyField = "Adam's Apple" ]
>
>Try doing that one with quotes. It gets ugly.
Well, since you ask! :) (Assuming the backend is SQLServer)
cSQLPassThrough = "SELECT * FROM MyTable " + ;
"WHERE MyField = 'Adam''s Apple'"
I agree that using brackets is a better idea, though! :)
Sylvain Demers