Re: MSSQL: {PROP:Disconnect}

Recently I need to work on this again.  I'm still using C55EE patch F.
I find a method to work around the problem with PROP:Disconnect.


! Connect to the database 1. Can use any table.
TableX{PROP:Owner} = ConnectString2
TableX{PROP:LogonScreen} = FALSE
OPEN( TableX )
CLOSE( TableX )

OPEN( Table1 )
! read/write Table1
CLOSE( Table1 )
! and open/read/write/close Table2, ..., TableN

! ---- This is the work around of PROP:Disconnect problem. ----
! It seems that I must issue PROP:Disconnect for all the tables
! that I worked with before for the database 1.
Table1{PROP:Disconnect}
Table2{PROP:Disconnect}
! ...
TableN{PROP:Disconnect}


! Connect to the database 2. Can use any table.
TableX{PROP:Owner} = ConnectString2
TableX{PROP:LogonScreen} = FALSE
OPEN( TableX )


Hope this is helpful for those who have the same problem as mine.
Regards!
Ming Zhu