William Bryant wrote:
> For what it is worth I'm having the same new record failure issue on a
> table where the
> primary key is a varchar variable. Same trace data.
>
> If I create a similar table but use an auto_increment integer for the
> primary key,
> new records can be inserted without error.
If your backend table doesn't automatically generate the pk, you need to
do it yourself at the Dabo bizobj level. Otherwise, here's what you are
in effect doing:
create table test (pk_id varchar(48) primary key default '', test_name
char(48));
-- the following call works, because there's no pk with the '' value yet
insert into test (test_name) values ("Paul");
-- but the next one fails:
insert into test (test_name) values ("Ed");
--
pkm ~ http://paulmcnett.com
_______________________________________________
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/dabo-users/[EMAIL PROTECTED]
