>>Hi, when I insert a record into my table made in sqlserver, the field named IdCustomer (integer identity in sql-server) return in my vfp form 0, there is a way to return the new number from sql when i execute a APPEND BLANK and not 0?
>>
>>THANK,
>
>What you use to insert records in SQL Server?

I have a remote view, and make something like this...

Select tblCustomer
Append Blank
-put the customer name, address, phone number, etc.
then ;
tableupdate(.t.)


-the IdCustomer field return 0, the table is BufferMode 5, when i exectute a tableupdate(), the idcustomer still is 0