>But I was wondering, in general, if there is another place in the program that could potentially cause a problem. I am trying to make my application completely error free :)
>Thank you.
In general you are on the right track.
The problem can raise on any DBX based command at any time, depending on your program. A grid getting focus, a timer fireing, a function that does not reset to the right area. A inserted SQL SELECT.
There are only two ways
SELECT infront of everything DBX
But again it might fail too because the shift can happen between two comand lines
Use SQL commands to do the work. They clearly adress tables
Note that stuff like
REPLACE ... IN Alias will not solve the problems. It has it's own traps.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]