Getting id of last inserted row

[error1408]

Hi, i have two tables with a 1:n relation. I insert a new row in the first table without knowing the id of it, because of a trigger in the table. Now i want to insert a bunch of rows in the second table, but i need the id of the before inserted row because of the foreign key. How could i do that?:confused: I use a firebird embedded db with .net + C#

[kubben]

In MS SQL Server you can call the function SCOPE_IDENTITY() and it will return the identity of the row you just inserted. Hope that helps. Ben

[Marcus J Smith]

Just set a parameter equal to @@IDENTITY.

---

CleaKO

"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

[error1408]

I found a solution select gen_id(, 0) from rdb\$database @cleako Could you post an small example? I'm new to programming with databases. Thank you