Hi
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