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) ENDThen 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) ENDIFHow can I put the result set into a cursor or table in VFP ?