NeoX Posted August 8, 2005 Report Share Posted August 8, 2005 (edited) 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? Edited August 8, 2005 by NeoX Link to comment Share on other sites More sharing options...
v3rb0 Posted August 8, 2005 Report Share Posted August 8, 2005 neesu oraclists, bet minu varbut ka: * lieto `outer join .. on .. ' plikaa outer vietaa * nevajag komatus pirms `outer` * `function` varetu but reservets vaards. * starp `tablename tablename_alias` ieliec `as` Link to comment Share on other sites More sharing options...
NeoX Posted August 8, 2005 Author Report Share Posted August 8, 2005 (edited) Viss kaartiibaa. Risinaajumu atradu. Atlika izdzeest visas taas saites un sho to pielabot. Straadaa 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, condition.comment, condition.condsetid FROM condition condition,function, actions, 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 " Protams, lai viss buutu 100% pareizi taas saites buus jaauztaisa oraaculam saprotamaa veidaa. Edited August 8, 2005 by NeoX Link to comment Share on other sites More sharing options...
Recommended Posts