Inventory build grid stored proc  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

Inventory build grid stored proc

Postby perry » Thu Oct 05, 2017 2:44 pm

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>
Perry Ma
S. Programmer
Lonicera Pty Ltd
http://www.lonicera.com.au
perry
Frequent Contributor
Frequent Contributor
 
Posts: 173
Joined: Mon Oct 27, 2008 2:26 pm
Topics Solved: 15

Re: Inventory build grid stored proc  Topic is solved

Postby Mike.Sheen » Sun Oct 08, 2017 2:40 pm

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
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2444
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 756


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 5 guests

cron