Help me system.gui.confirm

Ignition
1

Hello Team,

I’m starting use Ignition system but I don’t know how to configure a button with a question without skip question.

I have this code

if system.gui.confirm(u’Are you sure?’, ‘Confirm’):

np = event.source.parent.getComponent(‘PartNumber’).text
e = event.source.parent.getComponent(‘Estacion’).selectedStringValue
de = event.source.parent.getComponent(‘Descripcion’).text
tp = event.source.parent.getComponent(‘TipoSurtido’).selectedStringValue
m = event.source.parent.getComponent(‘Monitor’).selectedStringValue
pdd = event.source.parent.getComponent(‘PDD’).text
pdm = event.source.parent.getComponent(‘PDM’).text

system.db.runPrepUpdate(“Insert Into [dbo].[masterdata] (Numero_Parte_Sap,Estacion,Descripcion,Tipo_Surtido,Monitor,PDD,PDM) values (?,?,?,?,?,?,?)”,[np,e,de,tp,m,pdd,pdm])
system.gui.messageBox(“Masterdata item Added”)
system.db.refresh(event.source.parent.getComponent(‘Table’),“data”)

but when I press the button, show me a pop up but if I press YES insert the record a is all fine, but if I press No
also insert the record in database and I don’t want that.

2

Your formatting was lost when pasted into the forum, but is all of your code indented to follow the if statement? Like this:

if system.gui.confirm(u'Are you sure?', 'Confirm'):
	np = event.source.parent.getComponent('PartNumber').text
	e = event.source.parent.getComponent('Estacion').selectedStringValue
	de = event.source.parent.getComponent('Descripcion').text 
	tp = event.source.parent.getComponent('TipoSurtido').selectedStringValue
	m = event.source.parent.getComponent('Monitor').selectedStringValue
	pdd = event.source.parent.getComponent('PDD').text
	pdm = event.source.parent.getComponent('PDM').text

	system.db.runPrepUpdate("Insert Into [dbo].masterdata values (?,?,?,?,?,?,?)",[np,e,de,tp,m,pdd,pdm])
	system.gui.messageBox("Masterdata item Added") 
	system.db.refresh(event.source.parent.getComponent('Table'),"data")
1 Like
3

Thanks my friend, Appreciate your support