I am working with VB6 and SQL 2000. I have two tables with column names "Latitude" and "LATITUDE". I am trying to compare the two columns using the statement:
if (rsTab1!Latitude <> rsTab2!LATITUDE).
The Visual Basic IDE is too smart in that it replaces "Latitdue" with "LATITUDE" or vice versa depending on how I am editing. How do I control this behavior?
Any help is bery much appreciated.