Lieta taada, ka vajaga front-endu porteet no informix datu baazes uz oracle datu baazi. Viss jau taa kaa buutu izariits bet nestraadaa dazji kveriji. Siikaak skaidrojot no informix 7.3 uz oracle8.
Kverijs shaads:
sql = "SELECT condition.condid, condition.priority, condition.priority as priority1, condition.ifauths, b1.name as b1, condition.iftrans, b2.name as b2, condition.functionid, function.funcno, condition.actionid, actions.descr, condition.eqsign, condition.eqsign as b3, condition.comments, condition.condsetid FROM condition condition, OUTER actions actions, OUTER function function, boolean b1, boolean b2 WHERE condition.actionid = actions.actionid AND condition.functionid = function.functionid AND condsetid = '" + condsetid + "' AND condition.ifauths = b1.id AND condition.iftrans = b2.id ";
Kas oraaculam te nepatiik? Visas taas tabulas un lauki eksistee. Varbuut kaut kas pie taa: from condition condition ? un tas condsetid tiek padots pa adresi - ar to viss ir OK.
Luudzu, ja kaads zin kas tur par vainu, tad paliidziet! Paldies!
update: droshvien pie taa FROM savaadaak vajag, un tie OUTER tjipa saites noraada, mosh oraaclulam vajag taas saites ar laukiem noraadiit?