The third parameter in SQLEXEC() is the name of the cursor to return data in.

>I hava a store procedure to select a range of invoice no. from a table.
>

>CREATE PROCEDURE [dbo].[FindInvoice]
>      @DF varchar(255),
>      @DT varchar(255),
>AS
>BEGIN
>      SET NOCOUNT ON;
>      DECLARE @TABLEID varchar(255)
>      DECLARE @Sqlstat varchar(255)
>      SELECT @Sqlstat = 'SELECT [Invoice No],Date FROM INVTBL Where date between convert(datetime,''' + @DF + ''',101) and convert(datetime,''' + @DT + ''',101)
>      EXEC (@Sqlstat)
>
>END
>
>

>
>Then I call the store procedure in VFP as follow
>
>

>STORE SQLCONNECT('vitalscan', 'sa', 'Wilson123') TO gnConnHandle
>IF gnConnHandle <= 0
>   = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
>ELSE
>   = MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
>  lnRetVal = SQLEXEC(gnConnHandle, [EXEC FindInvoice '03/12/2007', '03/12/2007'])
>=SQLCANCEL(gnConnHandle)
>   = SQLDISCONNECT(gnConnHandle)
>ENDIF
>

>
>How can I put the result set into a cursor or table in VFP ?
>
>Derek