Re: SERIAL seed value

> > At 09:51 PM 5/19/96 GMT, Stuart Browning wrote: > >How can I find out the seed value of a column that is a SERIAL > >datatype from within a C or 4GL program? > > Seed value? I assume you want the value of the last inserted serial value > which is in SQLCA.SQLERRD[2] in 4GL (and SQLCA.SQLERRD[1] in ESQL/C, I think) > I believe he is asking for what the starting value is based on. You can specify, when you create the table, what the starting serial value is. I take this to be the 'seed' value of which Stuart speaks. When I wrote dbdiff2 I looked for this creature and could not find it. My G2 indicated that it was not accessible. If you find it (Stuart) holler, I could stand to know too. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________