Re: Problem with description field

2017-05-09 Thread Paul Foxworthy
Hi Skip, Try it with Derby instead of Postgres. Postgres handles large text differently from other databases, arguably better. Maybe OFBiz isn't doing the right thing for Postgres. What's the Postgres data type for the description columns? Cheers Paul Foxworthy On 10 May 2017 at 10:33, Skip w

Re: Problem with description field

2017-05-10 Thread Arun Sankar
Subject: Re: Problem with description field Hi Skip, Try it with Derby instead of Postgres. Postgres handles large text differently from other databases, arguably better. Maybe OFBiz isn't doing the right thing for Postgres. What's the Postgres data type for the description columns? Ch

Re: Problem with description field

2017-05-10 Thread Jeremy Olmstead
This is a long shot but, in your statement below, description is spelled incorrectly... Looking at the table with pgAdmin (I am using postgres), I find the field DESCRITPTION as expected, but it is empty. On Tue, May 9, 2017 at 7:33 PM, Skip wrote: > I have a problem with a field named "descrip

RE: Problem with description field

2017-05-10 Thread Skip
user@ofbiz.apache.org Subject: Re: Problem with description field Hi Skip, Try it with Derby instead of Postgres. Postgres handles large text differently from other databases, arguably better. Maybe OFBiz isn't doing the right thing for Postgres. What's the Postgres data type for the desc

RE: Problem with description field

2017-05-10 Thread Skip
;descAgain" gets written correctly, but "description" ends up blank. A strange problem. Skip -Original Message- From: Arun Sankar [mailto:arunsanka...@outlook.com] Sent: Wednesday, May 10, 2017 6:11 AM To: user@ofbiz.apache.org Subject: Re: Problem with description field

RE: Problem with description field

2017-05-10 Thread Skip
Message- From: Jeremy Olmstead [mailto:jolmste...@gmail.com] Sent: Wednesday, May 10, 2017 11:00 AM To: user@ofbiz.apache.org Subject: Re: Problem with description field This is a long shot but, in your statement below, description is spelled incorrectly... Looking at the table with pgAdmin (I

Re: Problem with description field

2017-05-11 Thread Taher Alkhateeb
ck a product where a single inventoryItem exists that can fullfil the > request and the results are the same. > > Thanks again for thinking about this very strange issue. > > Skip > > > > -Original Message----- > From: Jeremy Olmstead [mailto:jolmste...@gmail.co

RE: Problem with description field

2017-05-11 Thread Skip
tools immediatly following the database write, the description field (and the description field alone) is blank. A strange problem. Thanks again. Skip -Original Message- From: Taher Alkhateeb [mailto:slidingfilame...@gmail.com] Sent: Thursday, May 11, 2017 3:05 AM To: user@ofbiz.apache.org Subject:

RE: Problem with description field

2017-05-11 Thread Skip
quantity. It is not the Product.packageQtydescription field prim-key field="packageId" relation type="one" title="VMPackProduct" rel-entity-name="Product" key-map field-name="productId" relation entity -Original Message- From: T

Re: Problem with description field

2017-05-12 Thread Arun Sankar
a persists in postgres. Regards, Arun Sankar From: Skip Sent: Friday, May 12, 2017 12:55:01 AM To: user@ofbiz.apache.org Subject: RE: Problem with description field Hi again Taher I wanted to add one more interesting observation. As a test, I added a field &q

Re: Problem with description field

2017-05-12 Thread Taher Alkhateeb
; > descriptionThis is the aisle number the product was actually installed > in.description > field > field name="vendQty" type="fixed-point" > descriptionThis is the quantity dispensed with each transaction and is > the pack quantity. It is not the P

RE: Problem with description field

2017-05-12 Thread Skip
: user@ofbiz.apache.org Subject: Re: Problem with description field Hi Skip, I don't if you have tried this but I have a suggestion. Why don't you put a debug point in org.ofbiz.entity.jdbc.SQLProcessor class at executeUpdate() method(as per my version of Ofbiz 12). At the l