Runtime ERROR 3001 with SHAPE SELECT QUERY

5 pts.
Tags:
Runtime Errors
Visual Basic 6.0
Visual Basic runtime errors
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
ASKED: March 7, 2011  2:17 PM
UPDATED: March 7, 2011  2:21 PM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following