The SET ANSI_WARNINGS setting controls if this warning is generated.

>Hi everybody
>
>I'am receiving from ODBC folowing message
>
>"String or binary data would be truncated", I have checked aError array and have got SQL STATE CODE 22001 - String data truncated (on right) on insert or update.
>
>Code is very simple:
>sSelect = "Insert into Table (Opis1) values('a') "
>a=sqlexec(gnHandle,sSelect)
>
>Mistery is that I get this message only if back end is MS SQL Server 2000. If i run same app. with MS SQL server 7.0 same code works normal.
>
>Regards
>
>Toni