My guess would be there is a problem with how VFP is passing the parameters. Your pos_api_pin.table object needs to enclose character variables in quotes.
The SQL string shoud look like:
lcsqlexec = [Sp_API_PINSALES '100112', 'SOLD', 1, '120001, 64045805, '4291', 'VAULT']
If the SP fails, you should issue an AERROR(myerroryarray) to get why it failed.
HTH.
>yes, i am referring to stored procedures...here's my call from the query analyzer:
>
>Sp_API_PINSALES "100112", "SOLD", 1, "120001", 64045805, "4291", "VAULT"
>
>and here's my call from the foxpro window:
>
>cgobject = CREATEOBJECT("pos_api_pin.table")
>cg_nreturn = cgobject.PINSALES("100112", "SOLD", 1, "120001", 64045805, "4291", "VAULT")
>
>the stored procedure is pretty long, but i'll post the first part:
>
>CREATE Procedure Sp_API_PinSales
> (
> @product_sbt Varchar(6),
> @pin_status as varchar(15),
> @quantity int,
> @custno_fk Varchar(20),
> @pin_controlno float,
> @invno_fk varchar(20),
> @loctid_fk varchar(20)
> )
>As
>Begin Transaction
>
*snip*
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao