Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subtract
Message
From
07/03/2006 06:17:29
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01101978
Message ID:
01101999
Views:
13
hi,
i try as under, it works, i try to do it inside mygrid
a=SUBSTR("abc800",4)&&field(Sticket)char type
b=SUBSTR("abc500",4)&&field(Eticket)char type
c=VAL(a)-VAL(b)     &&field(noofticket)numaric type
? c
PS Why did you get rid of your photo?I'm going fat now so...
thanks

>Any help with what? You surely know you can't subtract a char field from another? - you'll get oprator/operand mismatch.
>Furthermore, the line "NOOFTICKET= Sticket- Eticket=60" is like saying subtract a logical field from a char field, as Eticket=60 would yield .F. even if you DIDN'T get oprator/operand mismatch.
>
>So what are you trying to achieve?
>
>PS Why did you get rid of your photo?
>
>>hi all,
>>
>>any idea, help
>>
>>Sticket=ABC100 CHAR TYPE
>>
>>Eticket=abc40  CHAR TYPE
>>
>>NOOFTICKET NUMARIC TYPE
>>
>>NOOFTICKET=  Sticket- Eticket=60
>>
>>THANKS
Previous
Reply
Map
View

Click here to load this message in the networking platform