issue in data type in QTP

[galstar]

Hi,

I am facing an issue in QTP script.
I have a variable 'a' which contains a value of integer type.
Now i am adding this value in datasheet as

Code:

datatable.value("name",1)=a

but the value of 'a' is getting entered as a string, i want it to enter as integer.

Plz anybody help me out to resolve this.

Regards,
Galstar

[MVChowdary]

Use the CInt function. can you tell me what is the value are you using

[KVK]

Hi Galstar,

How are you entering value into the variable "a" ?

If you do it the below way, if will take as string

a = "123"

If you do it in the below way, it will take as integer

a = 123

Correct you code accordingly and let me know if it works

Thanks
Vinod

[galstar]

Hi Vinod,

Actually,i am accessing a value of price from DB.and that returns 29.
but the value in DB is 29.00.I want it same as 29.00.
and then saving that value to 'a'.Then i thought to change the datatype of column of datasheet to number so that assigned value 29 to datasheet get changed to 29.00.
value of 'a' is integer but when i am assigning it to datasheet it is behaving as string.Due to this when entered in datasheet it is not getting changed to 29.00.

Please tell me the solution or any other way to peform it.

Regards,
Galstar

[KVK]

Hi Galstar,

You have to change the data type of the datatable manually, here are steps,

1.Select the column of the datatable and right click
2. Click on Format and Custom Number--> Select Type as "0.00" and click on OK

There is another way to avoid this manually by entering the data as ="29.00" in the datatable cell. check the below code

Code:

DataTable.Value(2,1) = "="&chr(34)&"29.00"&chr(34)

Let me know if this works for you

Thanks
Vinod

[nandu]

Hi..

if Data table contains a value like 29 => it treats as String 29
you need to add single Quotation preceeding to 29 like '29 then it treats as numeric 29 in Data table..

This is how Data table functioning with Numbers..