Relative Content

Tag Archive for javascriptsqlitenode-sqlite3

how to use result set of db.all in db.run command that is just next to it. Given these both are in db.serialize()

`db.serialize(()=>{ const rightjoinpromise=new Promise((resolve,reject)=>{ db.all( ‘select temp_data.colour,temp_data.size,temp_data.price,temp_data.quantity,temp_data.barcode,shoe.shoe_id from shoe right join temp_data on shoe.article_name=temp_data.article_name’, (err, rows) => { console.log(‘in db.all at start’) if (err) { dialog.showMessageBox(mainWindow, { message: `or or here Internal Server Error, ${err.message}`, buttons: [] }) reject(err) } else { console.log(‘in db.all else at start’) if (!rows.length) { console.log(‘No result got from right […]