Now that our users are starting to really use the SLX Ticket system, we get an error when we email someone the ticket and "Send SLX". It says there is an error in the TICKET: TICKET ACTIVITY SUPPORT script.  We have SLX 7.2 lan.

I chased it down to the following block of code:

    If (aRate <> "") Then
       dbRate = ((aRate / 60) * intTimeSpec)
       outLabor = intTimeUnits * dbRate
       outFee = outlabor
    End If

If I replace the aRate with a 1, 0, or 1.5 it works just fine. Once I put the aRate variable back in, it crashes.

The aRate is passed in from another method that gets it straight from the database field RATE in the TICKETACTIVITY table -- which is a NUMBER datatype (Oracle 9i database). The intTimeSpec is an integer.

so if the database value is a NULL This will blow up.....also if aRate = "      " this will blow up....

msgbox out the variable type and value just prior to the If statement....just because the db field is a number doesn't mean the vbScript subfield type is numeric.....same with intTimeSpec......