Skip to Content
0
Former Member
Apr 21, 2009 at 01:24 PM

error ORA-01722: invalid number

212 Views

Crystal 10. I got error ORA-01722: invalid number. I know that problem when I added {?sunitcode} parameter. The field t.sunitcode CHAR(8 BYTE) and {?sunitcode} in Crystal like string.

Need your help!

select 
    slastname, 
    sfirstname, 
          scode,
     sunitcode,
         saddr1,
         saddr2,
           scity,
         sstate,
     szipcode,
      psaddr2,
      psaddr1,
  hmyperson,
       amount
 from (SELECT  t.slastname  slastname, 
               t.sFirstName sfirstname, 
               t.scode         scode,
               t.sunitcode   sunitcode,
               t.saddr1        saddr1,
               t.saddr2        saddr2,
               t.scity            scity,
               t.sstate          sstate,
               t.szipcode     szipcode,
               p. saddr2      psaddr2,
               p. saddr1      psaddr1,
               t.hmyperson    hmyperson,
               sum(tr.stotalamount) - sum(tr.samountpaid) amount
        
FROM Tenant T, trans tr , property p
WHERE p.hmy = t.hproperty
  and t.hMyPerson = tr.hperson
  and tr.itype = 7 
  and tr.bopen = -1
  and t.hproperty = tr.hprop
  and tr.hprop = {?hprop} 
  and  t.sunitcode = {?sunitcode}


  GROUP BY t.sunitcode,
t.scode,t.sfirstname,t.slastname,t.saddr2,t.scity,t.sstate,t.szipcode, t.saddr1, p.saddr2, p.saddr1, t.hmyperson ) t
where amount>1000
ORDER BY t.scode