Search the web
Sign In
New User? Sign Up
qodbc · QODBC ODBC Driver for QuickBooks
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Problem Updating ItemService   Message List  
Reply | Forward Message #1297 of 1356 |
Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an
error when m
odifying a ItemService. Cannot use SalesOrPurchaseMod aggregate when
the item i
s reimbursable. , SQL state S0000 in SQLExecDirect in
E:\WWW\processes\qb_connec
t.php on line 182


I'm not sure why this would happen, I'm only modifying the Description
and Price. Some products are fine, others have this SQL error.

Any clues?

Thanks
Matt




Thu Jan 4, 2007 2:36 am

praefex
Offline Offline
Send Email Send Email

Forward
Message #1297 of 1356 |
Expand Messages Author Sort by Date

Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an error when m odifying a ItemService. Cannot use SalesOrPurchaseMod aggregate when the item...
praefex
Offline Send Email
Jan 4, 2007
2:40 am

You will have to provide a loop to check for which Price "field" is applicable to that item. If an item is performed or bought from a subcontractor it changes...
Chuck Vigeant
txbtech
Offline Send Email
Jan 4, 2007
5:52 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help