>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,
OK, that the how. What is happening when you use this? Are the 50 spaces getting pushd back to SQL Server? Is VFP throwing an error?
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao