Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem in date Range in ILOA table

Former Member

‎2012 Jan 23 1:47 PM

0 Likes
701

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

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

Reply
2 REPLIES 2
Read only

Former Member

‎2012 Jan 23 2:59 PM

0 Likes
563

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

Rob

Read only

RaymondGiuseppi
Active Contributor

‎2012 Jan 23 3:39 PM

0 Likes
563

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