Re: [dabo-users] Warning Python noob needs help

On Dec 29, 2009, at 11:12 PM, Carey Gagnon wrote:

> As the MySQL auto increment number is used as a number that gets put on

> accompanying paper work I would like to extend the message to include the

> last inserted ID.

> I read this thread on *getLastInsertID *

> * *but can wrap my head around getting it in the info dialog so I get

> something like:*

> *def afterSave(self):

> # This will only get called if the save succeeds

> dabo.ui.info("Record successfully saved. Your new number is DC10- ID OF

> LAST INSERTED RECORD HERE ", title="Success")

> self.new()

> self.BuilderName.setFocus()

After a new record is saved, the value of the auto-generated PK should be available in your bizobj via self.getPK(). So your code would read:

def afterSave(self):

newPK = self.getPK()

dabo.ui.info("Record successfully saved. Your new number is DC10- %s" % newPK, title="Success")

self.new()

self.BuilderName.setFocus()

> Just to make things even harder on myself if the ID is a single digit (ie:

> 1) it would need to have 2 zero's in front of it to give me 001

> if it's 2 digits (ie: 12) it would have to have a single zero in front to

> give me 012. And just give the last row ID if it's 3 digits (ie: 356)

That's a built-in Python string method: zfill

stringID = str(integerID)

print stringID.zfill(3)

> We will never have anymore than 999 entries.

Why does my stomach feel uneasy when I read a statement like that? ;-)

-- Ed Leafe

_______________________________________________

Post Messages to: Dabo-users@leafe.com