Runtime ERROR 3001 with SHAPE SELECT QUERY

5 pts.
Tags:
Runtime Errors
Visual Basic 6
Visual Basic Runtime
I'm having problems with my grouping. I finally found a way to use MSDataShape but now I'm having trouble with my query. I got this query from the DataEnvironment Groupings. I wanted to integrate in it vb6 code so that I could easily change conditions. Here's my query: SHAPE {SELECT itemname, tobedeliveredqty,employee_name, branch_name, branch_order.branch_order_id, branch_order_date FROM branch_order INNER JOIN branch_order_particulars ON branch_order.branch_order_id = branch_order_particulars.branch_order_id INNER JOIN itemlist ON branch_order_particulars.itemno = itemlist.itemno INNER JOIN employee ON branch_order.employee_id = employee.employee_id INNER JOIN branch ON branch_order.branch_id = branch.branch_id WHERE (branch_order_particulars.branch_order_id = (SELECT MAX(branch_order_id) FROM branch_order))} AS branchsrf COMPUTE branchsrf BY 'branch_order_id','branch_order_date','branch_name','employee_name'

Software/Hardware used:
vb6

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: