Page 1 of 1

Inventory build grid stored proc

PostPosted: Thu Oct 05, 2017 2:44 pm
by perry
Hi
v7.0.175 (and v7.0.157)

I found a weird problem today, that if the build grid stored proc is missing a column with key of "Quantity", Jiwa throws an error if there is any data row returned.
"Object reference not set to an instance of an object", Module: get_GridText

i.e. you must have below column in the final grid XML definition
<Column><Name>Quantity</Name><Key>Quantity</Key><Visible>TRUE</Visible><Type>CellTypeNumber</Type><MaxLen>255</MaxLen><Width>12</Width><Hidden>FALSE</Hidden><AllowSort>TRUE</AllowSort><LockColumn>TRUE</LockColumn><ShowTotal>FALSE</ShowTotal></Column>

Re: Inventory build grid stored proc  Topic is solved

PostPosted: Sun Oct 08, 2017 2:40 pm
by Mike.Sheen
Hi Perry,

Thanks for the bug report. There are 8 grids on the inventory maintenance form which uses the old method of building a grid from xml and that expect a quantity column to be present - it needs this to perform total calculations which are displayed in a label below the grid.

Your work-around is to include a quantity column, and if not desirable to display it, set it to hidden (ie: <Hidden>TRUE</Hidden>).

Logged as DEV-6298.

Mike