How to get the exact integer value from the sys form

[Former Member]

HI.

See the image

Actually we are seeing this from at inventory module

through the program i opend a  screen ...(another form).after that

i opened the this screen(in image)(systemform)

My requirement is just copy this whscode values form system form to

in my screen

i am able to get the values

but here is the problem..

in system form 01 ,02,03,04 are there

but in my screen i am getting 1,2,3,4

but i need only 01, 02 like this type

how can i get exact values

Through the query i am getting exact values but

i want to copy from form to my form..

Need some suggestions..

[edy_simon · Accepted solution]

Hi Seenu,

It is not a integer value, it is actually a string type.

Regards

Edy

[Former Member · Accepted solution]

Hi..Edy ok

May i know how  Can I get these exact values......

[Former Member · Accepted solution]

Hi Seenu,

     Based from your question, you already get the values. Right?

in system form 01 ,02,03,04 are there
but in my screen i am getting 1,2,3,4
but i need only 01, 02 like this type
how can i get exact values

So instead of using integer, changed it to string.

Regards,

[Former Member · Accepted solution]

Hi..

I had took udf type is alphanumeric i think it is a string (combinaiton of inte and character)

If it is wrong

Which type should i take.............

[Former Member · Accepted solution]

Hi Seenu,

     If you want to get all the warehouses of the specific item. Just do this query.

SELECT * FROM OITW

Regards,

[Former Member · Accepted solution]

Hii.. Bryan i all ready mentioned

I tried through the query i got the exact info

but is it possible through the form to form

if you say no..

I close the post....

[Former Member · Accepted solution]

Hi Seenu,

     If your field is UDF, then you can create Formatted search on it.

Regards,

[edy_simon · Accepted solution]

Hi Seenu,

Please check your code.

When you read from the system form, your variable storing the  value should be a string also.

ie

Dim sWhsCode as string

sWhsCode = form.items.item("28").Specific.GetCellSpecific("1",1).String

It should give you sWhsCode = '01'

Regards

Edy

[Former Member · Accepted solution]

Thanks Edi Working...Good.......