Jump to content
php.lv forumi

No Informix uz Oracle


NeoX

Recommended Posts

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 by NeoX
Link to comment
Share on other sites

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 by NeoX
Link to comment
Share on other sites

×
×
  • Create New...