>Give each user a local copy of the DBC. Deploy your views as .PRG files. When ever you need to use the view, you run the .PRG then USE the view.
>This will allow you to update the .PRGs without the user having to logout. You should also mark the DBC and the PRGs as readonly so they won't get use locks on them.
Allowing me to update the .PRGs or you're saying DBCs?
>Um... well, this is probably due to your code, I can't see this 'spontaniously' happening. But, once again, making the DBC read-only should keep changes from happening.
>You may want to turn DBC events on and see if you can capture what is changing the primary key setting.
Yes, we will go with CursorAdapters once VFP8.0 becomes available to us. But still, we need to maintain, and from time to time update those existing DBCs.
Do you have any idea if Stonefield DB Tool Kit addresses some of these concerns?
Thanks Bob.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."