>Having problems with saving data to SQL Server through a remote view. In this case, for character fields, whenever we have special characters like "@' &" etc, the entire record doesn't get saved into the database.
>Hope someone could shed some light.
>Thanks in advance
>Yau
Use AERROR() to get ODBC error:
IF NOT TABLEUPDATE(1, .t., [YourRVAlias])
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.