db()->sql - execute now

Freedy

Hi,

Is there a way to make db()->sql commands execute now? Instead on waiting on ->process?

allan

If you are calling $db->sql() yourself it will execute immediately.

Can you show me your script please?

Allan

Freedy

->on( 'preEdit', function ( $e, $id, $values ) { $result = $e->db()->sql("INSERT INTO orders (OrderID, TotalUnits, Date) VALUES ('".$newWO."', .$numUnits."', ".$curDate."')"); some other code which depends on the above being executed. }

Freedy

after some digging I found it get executed by
if ( $this->_transaction ) { $this->_db->commit();

allan

Thanks for posting back - good to hear you got it working.

Allan