Sibylle Koczian wrote: > Hello, > > trying out a dTextBox with decimal values (which works without problems, > thank > you for the quick answers!) I hit a new snag: > > SQLite database, one table, only the three fields mentioned in the UserSQL. > The primary key in this case is of type CHAR(3) and is filled in manually in > the application. No autoincrement, no setting by trigger. Application with > three dTextBox instances for these three fields and buttons for navigating, > New, Save, Cancel, Exit. > > 1. self.DefaultValues = None: > > class BizNum(dabo.biz.dBizobj): > def initProperties(self): > self.DataSource = "numtest" > self.KeyField = "idn"
Please tell us why you would want to have CHAR(3) as your PK. I'm asking because i would use technical PKs whenever possible. If you need CHAR(3) as a unique key for lookups, just add a CHAR(3) field with a unique key constraint in addition to your technical PK of type NUMERIC(18,0) which is a BIGINT for Firebird. If you need this for an existing database, then we have to find out why this doesn't work for you. Uwe _______________________________________________ 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]
