>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?

Nevermind I had the incorrect brackets