From: gilberto d. s. a. <gs...@gm...> - 2014-07-30 21:04:34
|
weberp on purchase orders when we select some item-class PO_Items.php give this error: http://[our-environment-url]/erp4113/PO_Items.php?identifier=1234567890 Error DB 1064 : Problema apresent. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-255' at line xx Falha SQL no DB : SQL que falhou foi (offset -255) SELECT stockmaster.stockid, stockmaster.description, stockmaster.units FROM stockmaster INNER JOIN stockcategory ON stockmaster.categoryid=stockcategory.categoryid WHERE stockmaster.mbflag<>'D' AND stockmaster.mbflag<>'A' AND stockmaster.mbflag<>'K' AND stockmaster.mbflag<>'G' and stockmaster.discontinued<>1 AND stockmaster.stockid LIKE '%av311%' AND stockmaster.categoryid='AV' ORDER BY stockmaster.stockid LIMIT 255 OFFSET -255 -- gilberto dos santos alves +55.11.98646-5049 sao paulo - sp - brasil |