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