>Hi
>
>I'm using cursoradapter to access MSDE databases.
>I have a field type int with identity true and need to retrieve the value from that field when insert a new record, for use in a related table.
>I don't wanna use stored procedures or ODBC.
>
>TIA

Rodrigo,
use @@IDENTITY

try this

INSERT INTO CA_your_file (field2, field3) VALUES;
                         (value2,value3)

TABLEUPDATE(0,.f.)

SQLEXEC( sqlHandler,"select @@IDENTITY AS Id","cur_identity")
insert_identity = cur_identity.Id

In addition
take a look at Message #1029049