Does a table automatically open exclusive during an SQL

Does a table automatically open exclusive during an SQL

• Amritha

  >>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.

  
  
  

• Russell81

  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.
  
  
• Does a table automatically open exclusive during an SQL