Re: [WebERP-developers] purchase orders error when select item

[gilberto d. s. a. <gs...@gm...>]

thanks. i see your code change http://sourceforge.net/p/web-erp/code/6741/.


2014-07-31 6:24 GMT-03:00 Phil Daintree <ph...@lo...>:

>  I think I may have fixed this not long ago - I think it was because
> there had been paging previously but a new search left the paging
> unchanged. From memory it only occurred after browsing through an item
> search then doing another search ?
> This was the diff
>
> https://sourceforge.net/p/web-erp/code/6741/
>
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 31/07/14 09:04, gilberto dos santos alves wrote:
>
>
> 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
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil