FrontAccounting forum — Manufacturing Reports - Print Work Orders - DATABASE ERROR

Re: Manufacturing Reports - Print Work Orders - DATABASE ERROR

null@example.com (itronics) — Wed, 28 Sep 2011 17:30:11 +0000

Oh, I see the problem now. The false error is raised when there is no work order in a system . I will fix this misleading message in next minor release. Thanks for pointing this out.
Janusz

Re: Manufacturing Reports - Print Work Orders - DATABASE ERROR

null@example.com (Apple) — Wed, 21 Sep 2011 04:06:24 +0000

Hi itronics,
Thank you for your reply.

I noticed this was due to no data is returned by the report's underlying recordset.

Can we display a message of "No record to display." instead of display "Database Error...". to the user.

If I were to set a test condition to intercept the above error, may I know where shall I set it because I can't figure out any underlying SQL from rep409.php.

Please advise. Thank you very much.

Re: Manufacturing Reports - Print Work Orders - DATABASE ERROR

null@example.com (itronics) — Mon, 19 Sep 2011 21:35:42 +0000

No idea. Seems you have invalid record with id '0' in your workorders table.

Manufacturing Reports - Print Work Orders - DATABASE ERROR

null@example.com (Apple) — Tue, 13 Sep 2011 05:53:02 +0000

This is the message that prompt out when accessing "Print Work Order" under "Manufacturing Reports"

DATABASE ERROR : Could not find work order 0
sql that failed was : SELECT wo.*,st.description As StockItemName,l.location_name, l.delivery_address,l.email, l.contact FROM workorders wo, stock_master st, locations l WHERE st.stock_id=wo.stock_id AND l.loc_code=wo.loc_code AND wo.id='0' GROUP BY wo.id

Please help.