[AccessD] A97 SQL Server

b heygood bheygood at abestsystems.com
Tue May 3 16:38:56 CDT 2011


no, the parameter is a long integer. I just was trying various.....
thx for responding.

bob
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, May 03, 2011 1:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A97 SQL Server

If the parameter in the sp is some sort of string, as suggested by '" & "M"
& "'", try

conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute '" & Trim$(RTE) &
"'"

i.e. embed RTE in single quotes and trim the leading space placeholder for
"+/-"

--
Stuart 

On 3 May 2011 at 11:05, b heygood wrote:

> 'conTest.Execute "sp_Add_FutureServicesOrders_byRoute '" & "M" & "'"
> conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute " & RTE
> 
> 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list