<No Subject Supplied>
This is not a feature supported by Online 5.X. If you need this feature in
5.X you have to use a trigger which sees this assigned valued, set it to a
global
variable in the calling stored procedure.
Standard disclaimers apply.
robert_wines@emsinfo.com
Robert
>> I use Online 5.07. I tried it but it didn't work.
>> The error is:
>> 674: Procedure (dbinfo) not found.
>> 111: ISAM error: no record found.>> Is there any solution other than an upgrade?
Guillermo Labatte
labatteg@frcu.utn.edu.ar
} Michael J. Erikson wrote:
} > AndreasSeibt wrote:
} >
} > I have to write a stored procedure which inserts a record into a table.
} > This record has a field of Type SERIAL as primary key. I need the value
of
} > the primary key directly after inserting the record for subsequent
} > processing. Is there any way to get this value?
} >
} > I use INFORMIX-Online 7.23.
}
} To get the Serial value after an insert use the following
}Define Value Integer;
}Let Value = dbinfo("sqlca.sqlerrd1");
}This will set Value to be the value of the last Serial column inserted.
}
}Hope this helps.
} Michael J. Erickson
}
--OAA01133.880490756/ns.emsinfo.com--