John,
apologies for the direct mail but you're the only person that I know of with a possible explanation to my question, I tried out the ADO example in your book Visual Foxpro 6 Enterprise Development ( a credit to all involved ), but I receive the error "OLE Dispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers ?, I have installed version 2.0 of MDAC and believe I have the latest ODBC drivers, the error occurs at the Select portion of the code below
CLOSE ALL
Clear ALL
Clear
LOCAL oConnection,oRecordset,oOrders,oOrderDetails
oConnection = create('adodb.connection')
oRecordset= create('adodb.recordset')
oConnection.Provider = 'MSDataShape'
oConnection.Open('Data Provider=MSDASQL;DSN=Northwind')
oRecordSet.Open("SHAPE {SELECT * FROM CUSTOMERS} AS CUSTOMERS " + ;
"APPEND (( SHAPE {SELECT * FROM ORDERS} AS ORDERS " + ;
"APPEND ({SELECT * FROM ORDERDETAILS} AS ORDERDETAILS " + ;
"RELATE ORDERID TO ORDERID) AS ORDERDETAILS) " + ;
"RELATE CUSTOMERERID TO CUSTOMERERID)",oConnection)
any help would be gratefuly received
Regards and thanks
Pete Kane
Regards,
Peter J. Kane
Pete