def edit(self, cmb1, cmb2, itemType):
#rint'editing type:',itemType
nextItem = ''
self.restore_id, restoreString = fetch.cmbIDV(cmb1)
if not self.restore_id:
# prepare data for new entry
if itemType=='country':
self.nextItemID = 0
else:
#rintitemType
nextItemID, nextItem = fetch.cmbIDV(cmb2)
if not nextItemID:
fetch.msg('Please Select A Follow On Item')
return
dlg = DlgAddrItemEditor.create(None)
try:
dlg.displayData(self.restore_id, itemType, nextItem)
if dlg.ShowModal() == wx.ID_OK:
itemName = dlg.itemName
if not itemName: return
# prevent duplicate name if country
# prevent duplicate name where next item same
# warning of other duplicate names -if not kelurahan
if self.restore_id: # editing an item
if itemName == restoreString:
return
else:
sql = "UPDATE addressItems \
SET itemName ='%s' \
WHERE %id = %d" % (itemName, self.restore_id)
#rintsql
cmb1.SetValue(itemName)
else: # insert a new item
#
sql = "INSERT INTO addressItems \
(itemName, itemType, nextItemID) \
VALUES ('%s', '%s', '%s')" % (
itemName, itemType, self.nextItemID)
#rintsql
finally:
dlg.Destroy()
def edit(self, cmb1, cmb2, itemType):
self.restore_str = fetch.cmbValue(cmb1)
nextItem = fetch.cmbValue(cmb2)
if not nextItem: return
nextItemID = fetch.cmbID(cmb2)
dlg = DlgAddrItemEditor.create(None)
try:
dlg.displayData(self.restore_str)
if dlg.ShowModal() == wx.ID_OK:
itemName = dlg.itemName
if self.restore_str: # update an edited item
if itemName and itemName != self.restore_str:
# test to make sure name is unique
#rint'save ', itemName
#rint'next item id ='
cmb1.SetValue(itemName)
else: # insert a new item
sql = "INSERT INTO addressItems (itemName, itemType, nextItemID) \
VALUES ('%s', '%s', '%s')" % (itemName, itemType, self.nextItemID)
finally:
dlg.Destroy()
def edit(self, cmb1, cmb2): self.restore_str = fetch.cmbValue(cmb1) nextItem = fetch.cmbValue(cmb2) if not nextItem: return sql = "SELECT " # warning - how may records will be effected if not self.restore_str: return dlg = DlgAddrItemEditor.create(None) try: dlg.displayData(self.restore_str) if dlg.ShowModal() == wx.ID_OK: itemName = dlg.itemName if itemName and itemName != self.restore_str: # test to make sure name is unique #rint'save ', itemName #rint'next item id =' cmb1.SetValue(itemName) finally: dlg.Destroy()
