I have a sql statement in VB6 (com objects) that will not work. Does anyone know if the Right outer join that I'm using here is ok in VB6?
When I run this in Toad I get back a record, however when I put it in vb as this
lsSQL = "select al.Nbr_license, al.return_received, p.resident, p.name_first, p.initial1, p.name_last FULLNAME, " & _
"p.addr1, p.addr2, p.addr3 ADDRESS, al.trap_line_id, al.fur_area_id, " & _
"al.nf_beaver_trapline , al.gen_trap_license, al.nf_renew_trapline, al.lab_beaver_license, fmz.fur_area_desc, tl.trap_line_name, al.rowversion " & _
"from dba_wims.application_licens al, dba_wims.person p, dba_wims.fur_manage_zones fmz, dba_wims.trap_line tl " & _
"Where p.person_id = al.person_id " & _
"AND fmz.fur_area_id(+) = al.fur_area_id " & _
"and tl.nbr_trap_line(+)= al.trap_line_id " & _
"and tl.nbr_fur_area(+) = al.fur_area_id " & _
"and al.Nbr_license = " & nbr_license & " "
I get an error
/trapperReturn.asp, line 96
I looked up this error and it says data type mismatch but I'm only selecting.