Hello,

I am using MSHFlexGrid and following is the code:

Dim strCn As String

strCn = "connection string"

Dim strSh As String

strSh = "SHAPE {SELECT * FROM `Customer`} AS Customers APPEND ({SELECT * FROM `Order`} AS Orders RELATE Cust_ID TO Cust_ID) AS Orders"

With Adodc1
.ConnectionString = strCn
.RecordSource = strSh
End With

Set MSHFlexGrid1.DataSource = Adodc1

But when I run code it gives me following error:

Invalid SQL Statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE'.

What can be done????

Regards,

Prachi