topic Re: Problem in date Range in ILOA table in Application Development and Automation Discussions

Problem in date Range in ILOA table

Former Member — Mon, 23 Jan 2012 13:47:45 GMT

Hello,

I am working on PM module and in ILOA table. When I wish to fetch Records from table I give input selection for the filed MSGRP i.e. ' Voltage Rating'. It fetches wrong values. Suppose I select range for 66 tp 200 then also it fetches values for 400 in MSGRP select option. But when I give single selection, i.e. only 66 ot only 199 it fetches accurate data.

What could be the problem? Could you please advise? Is there any problem in Data Insertion?

But this is a standard table ILOA.

Thanks and Regards,

Harish

Re: Problem in date Range in ILOA table

Former Member — Mon, 23 Jan 2012 14:59:11 GMT

MSGRP is room not voltage and is a character field not numeric.

Rob

Re: Problem in date Range in ILOA table

RaymondGiuseppi — Mon, 23 Jan 2012 15:39:02 GMT

MSGRP is a character field (room, character field). If you have turned the area to put a number, then change the conversion-exit or domain (eg ALPHA) so numbers are correctly sorted.

Regards,

Raymond