-
June 12th, 2010, 07:36 AM
#1
Shape command for MSHFlexGrid
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|