Open a SQL Table AS using a Connection String and using a Handle
The Help shows doing this ...
Open "MSSQLDRVrdsys@SERVER=(local);Trusted_Connection=yes;DATABA SE=MSSQLOrder180|options|intfile=Ordsys.int" as OrdSys
This is all well and good if albeit a bit overly complicated. But the above will not work as below :
Code:
Handle hoTable
move 0 to hoTable
Open "MSSQLDRV:ordsys@SERVER=(local);Trusted_Connection=yes;DATABASE=MSSQLOrder180|options|intfile=Ordsys.int" as hoTable
IMHO - we should be able to do the above ?
Chuck Atkinson
"No matter how confounding the case, Bob Worsley always finds the quaesitum."