Getting last ID after an insert statement

[soneliso]

I'm using VB.NET and Informix database I'm trying to get last serial id whenever i perform an insert statement. Here is what i have so far Insert into Table1 values (0,"Mouse") SELECT DBINFO('SQLCA.SQLERRD1') FROM systables WHERE tabname = Table1 My problem is, sometimes i get 0 as the ID although the row has been inserted Can someone please help Thanks Read, Read, Read instead of asking Why, When, Who, and How?????