Any one seen this BUG in Matrix Items.

Posted by Jason on May 30, 2005, 5:04 pm

Please log in for more thread options

Hi All,

I have come across what I think is a bug in RMS Matrix Items occurring when
the description of the dimensions contain a single inverted comma (').

Take this example:-

Matrix Item called: Magazine
ItemLookupCode: MAG
Single Dimension called: Title
Add any item and set the Title column to somethin like: Jason's Adventures.
Save the Matrix Item.

Sell the Item MAG in POS, The matrix selection screen appears - choose the
Item Jason's Adventure, then crash with this error and POS Closes.

"Run-time error '3001' Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another."

Now edit the item Matrix item and change the description of Jason's
Adventure by removing the single (').
Start POS again and resell the item - this time works OK.

Is this a Bug?

Regards,

Jason.

Posted by Antonio Mazzeo on May 30, 2005, 10:50 am

Please log in for more thread options

Jason wrote:

> Is this a Bug?

Yes, is a bug of the SQL statement.. I tried with hotfix 1.2.0183 and
the bug is present..

How can to know the address to post the bug?

Antonio