Open exclusive table cannot use in 2 forms

[Sixon Qjz]

I've open a table in first form, my code is :

First Form load :
select 0
use table1 alias table1 exclusive

then when I click a button in the first form , it runs second form
with a datagrid :

Second form, datagrid init :
select table1
thisform.grid1.recordsourcetype= 1
thisform.recordsource="table1"
the grid cannot bound to the table1, it's blank....

[tom knauf]

Hi,

why do you want to open it in one form exclusive and then again in another
form ?
I cannot think of any senseful use of this.

You should open it non exclusive in both forms or try private datasession.

Regards
Tom

"Sixon Qjz" <sixo...@gmail.com> schrieb im Newsbeitrag
news:26b55b40-09a9-483e...@d9g2000prh.googlegroups.com...

[Bernhard Sander]

Hi Sixon,

I think, your forms use private data session. Then you can't open exclusively
the same table in both forms at the same time because each session knows nothing
from the other session. They behave exactly the same as if two clients in a
network would try to open the same table.
If you need to open the same table in two forms with private data session, both
forms must switch to the same session.

Have a look at DataSession Property, DataSessionID Property and SET DATASESSION
Command in help.

Regards
Bernhard Sander

[Fred Taylor]

Depending on the order and how the forms are opened, if the first form has a
Private Datasession, then the second form can be a Default Datasession and
share the tables from the first. That is if the second form is called up
from the first.

--
Fred

"Bernhard Sander" <fu...@no.spam> wrote in message
news:%23Hs$g7kJKH...@TK2MSFTNGP02.phx.gbl...