Hi!

Shouldn't it be following?

EXEC spCompanyInsert @CompanyID = 1, @PrincipalBusinessDescription = "Blah Blah Blah"



>I am fairly new to SQL Server, and am having trouble using VFP 6.0 SP4 to insert a record into a SQL Server 7.0 table. I am using SQLExec to call a stored procedure, spCompanyInsert. The Company table has a text field, PrincipalBusinessDescription, which is giving me trouble.
>
>I am building a string in VFP for the SQLExec call: [EXEC spCompanyInsert @CompanyID = 1, PrincipalBusinessDescription = "Blah Blah Blah"]. When I issue the SQLExec, SQL Server bombs. I think I need to use ' rather than " to delimit the parameters, but sometimes my memo field contains a '.
>
>My questions are:
>
>1. Should I be using a Text fiel in SQL Server? I upsized from a VFP database, and the source field was a memo field.
>2. Is using a stored procedure the best way to handle inserting and updating records, or shoudl I just issue the INSERT from VFP?
>3. When I am building my SQL string in VFP, what do I do if one of the parameters to the sproc contains a '?
>
>TIA