hi,
if i know ,way i send to UT.
HAVE GRATE DAY.
>You don't say what happens when "sometime work, somtime not "
>
>I suspect that sometimes the numeric part of sticket or eticket does not start at the 4th character, e.g.
>
>if sticket = "wwww60", lnSticket will attempt to be w60, which it can't be as it's supposed to be numeric.
>
>Why not write a small function to strip out and return the numeric part, if this is the case?
>
>>hi,
>>
>>lnSticket = Val(SubStr(csrMyCursor.sticket, 4))=QQQ33 OR WWW60
>>lnEticket = Val(SubStr(csrMyCursor.eticket, 4))=QQQ10 OR TTT20
>>
>>
>>
>>
>>>What's the value for sticket and eticket when you get an error?
>>>
>>>>hi all,
>>>>
>>>>i try this code under ,
>>>>sometime work, somtime not
>>>>lnSticket = Val(SubStr(csrMyCursor.sticket, 4))
>>>>lnEticket = Val(SubStr(csrMyCursor.eticket, 4))
>>>>replace noofticket with lnSticket-lnEticket
>>>>