>I am using VFP 7 and SQL Server 2000. Foxpro does not have a varchar datatype and I am using varchars in SQL Server. I want to be able to trim the trailing spaces. Is there anyway to have foxpro pass a field to SQL Server and have it convert to a varchar. Does VFP 8 have a varchar datatype?
Tracey,
With SQL Server, you can change the ANSI_PADDING setting for the ODBC connection. This will configure how VFP sends trailing spaces for Varchar fields.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao