Hello,

I have a program (browser-based) that uses a SQL Server database to store data. The code in the browser contains hyperlinks to .SPT files. These files seem to contain only the parameters for similarly name stored procedures. ie:
---------------------------------------------------------------
<a href="steve.spt"><strong>
    Steve Cashouts
      </strong></a>
---------------------------------------------------------------
The steve.spt file contains something akin to:
---------------------------------------------------------------
    ~ Get Sales Data~
^D@ "Start Date" : "2003-01-01"
^C@ "Units|All|Detail" : "0"
^C@ "Periods|All|Detail" : "0"
^C@ "Gross or Net|Gross|Net" : "0"
^C@ "Show Zero Records|Exclude|Include" : "0"
---------------------------------------------------------------

There is also a stored procedure called sp_Steve.sql

I am trying to figure out how selecting the link that calls the .SPT file causes the stored procedure to run. I've been hunting far and wide on the net and found numerous references to SQL pass-through queries, but no reference to how they store the parameters or how they call the procedure. Any help is greatly appreciated.

Thanks

Steve

Hi Steve,

SPT stands for - SQL Pass-Through, this is a terminology in Visual Foxpro. You might want to take a look at this - Accessing Server Stored Procedures with SQL Pass-Through Functions

But I can't find much on that, as I am not good at this. Just managed to get some info on that for you here.

Hope that helps.
Cheers!



_________________________
- Vijay G
Strive for Perfection

Vijay,

Thanks. I've seen that documentation. These files seem to be a holdover from older versions of the software. I was hoping that wasn't the case.

Again, I appreciate your help.

Steve