rpp


I have tried to create an application that uses SELECT statements to populate controls on the form. After the SELECT statement runs, the table remains open, exclusively, is there a way to preform the SELECT and have the table open SHARED




Re: Does a table automatically open exclusive during an SQL

Budoi


If you didn't specify an INTO clause, then you're probably using a cursor which resides only in the memory of the machine that issued the SELECT command. You could try the INTO TABLE clause that will create a table on disk which you can share.





Re: Does a table automatically open exclusive during an SQL

AndyKr

>>After the SELECT statement runs, the table remains open, exclusively

This suggests that you are using the SELECT to create a cursor - that is always local to the user's workstation and is always opened exclusively. So the answer to your question is "NO" you cannot open it shared.

However, if you are using a Query and you want the data to be visible to other users, you should probably make this into a Local View (which can be used to update the underlying data tables - which ARE opened shared) and so other users will be able to access the changes made through the view. The documentation on Local Views in the help file is quite good, and you can use the View Designer to help create the views, and set their properties.