[Des DC]

Hi all,
I facing a problem while using if else statement.
here my code

stringvar halfshare := ToText({DataNormal.IsHalfShare});
stringvar margin := ToText({DataNormal.Margin});

if halfshare = "0" then
margin & "      " & "S"
else if halfshare = "1" then
margin & "      " & "H"
else 
margin & "      " & "R";

I have declaring the variable as above. But my output is only display the last statement which is

margin & "      " & "R"

.
Can anyone tell me where is my problem/error?

[_HAWK_]

If the isHalfShare is a boolean the result is 'True' or 'False' and would explain the results your getting. So try to change the '0' and '1' to true and false.

[Des DC]

_HAWK_,the data for my database in {DataNormal.IsHalfShare} is 0,1,2. So i want it to display in word. that is
0->S
1->H
2->R

But now what i get is 10.00 R even my {DataNormal.IsHalfShare} value is 0.
10.00 is the margin value.

_HAWK_,the data for my database in {DataNormal.IsHalfShare} is 0,1,2. So i want it to display in word. that is
0->S
1->H
2->R

But now what i get is 10.00 R even my {DataNormal.IsHalfShare} value is 0.
10.00 is the margin value.

[_HAWK_]

Ok, what is the datatype, Int? Try comparing the datatypes directly without converting. CStr({field}) is also available.

[Des DC]

yes. the datatype is Int.
I tried cstr({DataNormal.IsHalfShare})
it will display 10.00 0.00.

[_HAWK_]

I am not familiar with Access, but that does not look right - 10.00 0.00 is not an Int or a Float value. If it is just 10.00 then ToText({DataNormal.IsHalfShare}, 0) would give you the whole number - no decimals.

[Des DC]

_HAWK_,my database is MySQL.
Yes. The margin datatype is decimal,but datatype for IsHalfShare is Int.
I'm still try and error to find out my problem.