>
> Do you use the MySQL database on dabodev.com? 

Yes:

> That's because dDropdownList.Choices expects a list of strings. The exception 
> is raised at "Self.Choices = pks", right? So pks contains the (integer) pkid 
> values, as expected. So why you get the error you do when you change back 
> again I still can't understand.
Yes. I understand why I get the type error when I make the change. When 
I put it back to Self.Choices = names, then I get the problem of not 
being able to save the record. It tries to save the clientname from the 
dropdownlist as the pkid field in the database. It looks to me that it 
ignores  the self.valueMode = "Key" setting.

I did spend some time searching through the code to see where this 
option might get applied, but thought that by the time it assigns this 
value it has already been set to the name. So it appears to me that 
either the cnxml set-up is being interpreted incorrectly or I have a 
mismatch in the code somewhere. But the code is copy/pasted from the 
guide. It all works except for the save when it returns the following 
message from the database. This looks like a standard warning from 
MySQL. So Dabo is expecting to write the record.

> db\dCursorMixin.py:302: Warning: Incorrect integer value: 'Mom's 
> > Friendly Robot Company' for column 'clientfk' at row 1
> >  res = self.superCursor.execute(self,sql)

Thanks for taking a look. I'm mystified as well.

John Aherne





_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]

Reply via email to