XOInstance (OpenInsight 32-Bit)
At 19 NOV 2010 03:08:51PM Jim Vaughan wrote:
The following code connects to a ODBC datasource called CUSTOMER.
hXO=XOInstance ("CUSTOMER")
The source name was setup using the File/New menu in the Client / Server Workspace.
Is it possible to setup the connection name programmatically or do you have to use the Client / Server Workspace?
At 19 NOV 2010 07:29PM Jim Vaughan wrote:
Searching on here I found this in response to the same question asked by me back in 2002. Is the below still correct?
Sprez:
Well, regretfully a qualified answer. We do not make extensive use of datasets as we have mentioned in previous postings, finding that we had problems with ] 10 joins on a single window. Instead we use queries to execute our own SELECTs INSERTs and UPDATEs etc. It is our belief that you cannot create a dataset on the fly as they are stored as specially compiled composite document types to make interpretation by the DSO API easier. We are prepared to stand corrected on this.
I
At 22 NOV 2010 11:47AM Bob Carten wrote:
We have not changed XoInstance, DSO or QryMethod, so those Sprezz comment still applies.
The SQL Connector (DSBFS) employs supporting routines (DSBFS_CONNECTION, DSBFS_IO, DSBFS_EXEC_SQL ) to create connections, pass sql, return recordsets as RM/@FM delimited blocks of text. The plan is to provide functions to let you programmatically create connections and execute SQL on the fly using these routines.