Recid in Stored Procedure

[Ruslan Zasukhin]

On 20/9/07 5:21 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>> Seems to be impossible now.
> 
> Do you mean that in the next line of this sp
> 
> create or replace procedure spBuildUserTypes()
> begin
> insert into tbl_typelists(created_by,typelistname) values
> ('spBuildUserTypes','usertypes')
> 
> end
> 
> I cannot put a select statement to obtain the recid of the record
> created in the previous line ?
> 
> or maybe I should modify our after insert trigger to have a line
> 
> set @last_recid = new.recid ?
> 
> Would that work ?

Ivan says - yes should work.

Although we need implement at last of end kind of last_recid() for SQL.
I think we already have such request in Manits


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]