Re: NewEra, Supertables, and SERIAL

Gregory Lynn Wood (lynnwood@crash.cts.com) wrote: : I have a table that contains a serial for its primary key. : When I set up a supertable in newera and go to insert a : new row, it leaves this column blank. If I try to apply the : row, it does not add that row, but it also does not return : any error. : If I enter a value in that column and then apply, it add the : row. : How do I get it to assign this number automatically, since : it is a serial. You can assign 0 to serial field when new row is created. But after inserting this row into DB table new generated value isn't updated automatically in your supertable. : Greg