MB Software Solutions General Account wrote: > set iqtyinstock = (select sum(nqty) > from inventory_transactions > where iinventoryid = ROW.iid); > Unknown column 'ROW.iid' in 'where clause' > ---------------------------
I was fumbling around w/ something similar the other day and in my situation it (postgreSQL query builder) acted as though it was being case sensitive. So maybe your "ROW.iid" should be "row.iid". Or vice cersa... Small chance, but worth a try... -- Matthew S. Jarvis IT Manager, MCP Bike Friday - "Performance That Packs!" www.bikefriday.com [EMAIL PROTECTED] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
