|
Posted by wjreichard on 04/11/07 16:02
OK ... I am using UPS Worldship that issues an ODBC query to my MS2K
server ... Worldship can query either a table or a view and retreive
shipping info for a supplied orderid.
I need to create a DB table that will track the orderids requested
from Worldship so that I can stop doubleships. That is to set up a
function to allow the info to be sent only once to worldship.
I need to execute a stored procedure to write to a table and enforce
biz logic.
So .. I've created a view that Worldship can execute an ODBC query
against (v_upsPull) ... in which I guess the query issued will be
like: SELECT * FROM v_upsPull WHERE orderid = 123456
The view is:
CREATE VIEW dbo.v_upsPull
AS
SELECT * FROM OPENROWSET ( 'SQLOLEDB', '[db]'; '[user]'; '[password]',
'exec sp_ups_pull')
When the ODBC query calls the view the sp_ups_pull store procedurer is
executed.
However ... I do not have access to the original Where clause in the
ODBC query in the stored procedurer.
Is there a way I can get access to the ODBC Where clause and pass it
into the stored procedurer?
If not is there some other way I can create a DB table and run a
select against it ... based on the Worldship query?
Navigation:
[Reply to this message]
|