Hi,

I'm using a Cusrsoradapter with ODBC Connection to SQL Server

in SQL Server i have a field "ACode VarChar(50)"

i want to save the data without leading spaces, coz if i dont then all 50 spaces are inserted in the Sql server table. and in relation based tables whenever user leaves blank the VFP send 50 Blank Spaces to the SQL Server and an Error is Generated because of 50 Blank Space Primary key is not found

in the cursoradapter i'm using Autoupdate Functionality and in the ConversionFun property i've written this "ACode RTRIM"

Regards
Anwar