>Hi,
>
>I have a single user DOS application which I am now allowing to have a second user with read only rights. Some temporary tables created with sql selects (a cursor won't do since I need to chage some fields) have fixed names and sometimes lead to "sharing violation" errors in Windows 95. Since the goal is not to have to change too much of the code, I need to trap these errors, but don't know how to do it does anybody know how ?
>
>TIA,
>
>Alex

You can do it by creating Error Procedure trapping.

1. Issue ON ERROR DO errorproc WITH MESSAGE, ERROR() on you main program.
2. Your errorproc should be like this:

Procedure errorproc
PARAMETERS cmessage, nerror

* Where:
* nerror is error no. returned when error occurs.

DO CASE
CASE nerror = some_value
DO ACTION HERE
CASE nerror = some_value
DO ACTION HERE
....
ENDCASE

HTH