I have a stored procedure in SQL Server 7 that incluses a select statement along the lines of SELECT * FROM table WHERE date_add >= @bdate and date_add <= @edate. @bdate and @edate are datetime parmaters to this procedure.
The following SPT works fine:
ln_return=SQLEXEC(ln_handle, "myproc '01/01/2001','01/01/2001'")
*Note yes I should give it better strings -- but for teting purposes these work
*fine.
*ln_return=1
*And I do indeed get one sqlresult cursor
*This following fails
ln_bdate=datetime()
ln_edate=datetime()
ln_return=SQLEXEC(ln_handle, "myproc ?d1,?d2")
*ln_return = -1 meaning an error
* and of course I get no results cursors
* Is this an ODBC problem? A UFU on my part? Help!
*
Thanks
Gar W. Lipow