Siva
This is an error return by the SQL Server. You can catch this error using the AERROR() function.
>Hi Every body
>
>We are working VFE 6.0 with SQL Server using remote views. While adding records, in case if primary key violates system displaying
>the following message.
>
>" Violation of primary key constraint 'constraint name'. Cannot
>insert duplicate key in object 'table_name' "
>
>We try to find the error number in "Error" method. But Error method is not invoking. We beleive this is the ODBC error. How to catch such error.
>
>Please advise.
>
>Thanks
>V. Siva Nagi Reddy
Ricardo Parreira
PHC
Portugal