>>>what type shall i use in QLserver2008 for VFP memo fields i tried varchar(MAX) but it does not seem to accept carriage returns when entered in SSMS
>>>
>>>
>>>Peter
>>
>>Don't enter values manually in SSMS. Use UPDATE command or INSERT command.
>>
>>Varchar(max) is the correct type to use.
>
>
>I am brand new to this.
>
>how do I connect to my local SQLserver 9i used all defaults on install) from VFp??
>
>thnaks
>
>
>Peter

lnConnection = SQLSTRINGCONNECT("Driver=SQL Server;Server=.\SQLEXPRESS;Trusted_Connection=yes;")
IF lnConnection < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF