For Programmers: Free Programming Magazines  


Home > Archive > Clarion > December 2004 > Re: MSSQL: {PROP:Disconnect}









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: MSSQL: {PROP:Disconnect}
blackpuppy

2004-12-30, 8:55 pm

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

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com