>>When updating SQL Server database with a duplicate value in a unique column I get error 1526 (using VFP function
>>AERROR(aErrorInf )). This number seems to be specific to SQL Server and not to VFP. Does it change from version to version of SQL? The reason I am asking is I want to "translate" this number into a meaningful message to a user.
>
>If that is ODBC error AERROR() returns this:
>1 Numeric. Contains 1526.
>2 Character. The text of the error message.
>3 Character. The text of the ODBC error message.
>4 Character. The current ODBC SQL state.
>5
Numeric. The error number from the ODBC data source.>6 Numeric. The ODBC connection handle.
>7 The null value.
>
>Run this in SSMS:
>
>SELECT * from sys.Messages WHERE Language_Id = 1033
>
>And you will get all error messages SQL Server returns in English.
Thank you very much for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham