Re: IUS HTML Serial Value

Is not there MI_OID variable, that contain object ID inserted row. Try this: <?MISQL SQL="insert into mytab values (0,'hello');"> <?/MISQL> <?MIVAR NAME=last_serial_val>$MI_OID<?/MIVAR> At least, it was in Web Blade version 2.2. > Informix: 9.12.uc1 > Blade: web.3.30.uc6 > > In my HTML page, can I retrieve the value of the last serial insert just > made ? > > IE: > > <?MISQL SQL="insert into mytab values (0,'hello');"> > <?/MISQL> > > where the table has a serial value for the first column. > > What I then wish to do is: > > <?MIVAR > NAME=last_serial_val>$something-or-other-to-get-me-the-serial-value-just-inserted</?MIVAR> > > etc > > Can this sort of thing be done ?? > > Cheers, > > Rick. > > -- > Rick Ward > Senior DBA > Great Universal Stores Home Shopping > MANCHESTER, UK > > All views and comments in this e-mail are expressed by myself only, and > are not necessarily representative of my employer, Great Universal > Stores. > > -- Dmitry V. Belochkin phone: +7 8452 512828 INTERCOM Company, Saratov http://www.intercom.ru/~db