General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>
>>My work around is to open the database shared before opening any tables. This works great. I tried it just to see, and when it worked I was surprised. I had always been under the assumption that set exclusive affected both databases and tables.
>
>In my apps, I always open the DBC before any table. However, I do not see the same type of behaviour as you do. I can open a table that is part of a DBC, but the DBC opens shared if I have EXCLUSIVE off. I only get the behaviour if exclusive is on.
>
>If you are using your own form class with private DS, do you have all the necessary SET commands in the form's LOAD method? Also, if you open tables in a DE environment, you need to start with the usual SET commands.
>
>set talk off
>set exclusive off
>set multilocks on
>set deleted on
>
>Just to cover everything, a list of all SET commands that are scoped to every data session can be found in VFH Help under SET DATASESSION.
Thank you! I will check the link and start doing more research. I am still learning how this app is set up, because I was not on the original development team.
Thanks!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only