I have three free tempary foxpro tables and I'm trying to use ADO with the MSDataShape provider. But I keep getting the error message "OLE IDispatch exception code 0 from MSDataShape: Data shape command text contains a syntax error at or near position 13 in the command. The text near the error is: "SHAPE (SELECT date FROM tmpf3"..."
SHAPE (SELECT date FROM tmpf3 ORDER BY date) AS a_tmpf3
APPEND ((SHAPE {SELECT date, ctrno FROM tmpf2 ORDER BY ctrno} AS a_tmpf2
APPEND ({SELECT * FROM tmpf1 ORDER BY order, wono} AS a_tmpf1
RELATE "ctrno" TO "ctrno")) AS WorkOrders
RELATE "date" TO "date") AS days
Any Help?
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers