>>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.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham