Cannot get the Db lookup to functoid to work in Service Connect

I haven't used the DB operation to hit a vantage database, but here is a sample query I use to hit a third party sql DB....


SELECT [ID], [PONumber], [Item], [Quantity], [Received]
FROM [PODETAIL]
WHERE PODetail.PONumber = PONum and PODETAIL.Item = ItemNum and Received is null

PONum and ItemNum are xpath statements using data from the work flow.


Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of STEPHEN
Sent: Wednesday, February 08, 2012 12:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Cannot get the Db lookup to functoid to work in Service Connect



Hi all,
I can not get the Db lookup to functoid to work in Service Connect.
Trying to use it from a conversion to a webmethod.

It s a simple

SELECT VENDORNUM

FROM VENDOR

WHERE COMPANY = 'XXX'

AND VENDORID = 'XXXXX'

Has anyone had any joy

Steve



[Non-text portions of this message have been removed]
Hi all,
I can not get the Db lookup to functoid to work in Service Connect.
Trying to use it from a conversion to a webmethod.

It s a simple

SELECT VENDORNUM

FROM VENDOR

WHERE COMPANY = 'XXX'

AND VENDORID = 'XXXXX'

Has anyone had any joy



Steve
Try using


From "MFGSYS"."PUB"."Vendor"


Also, are you using concatenation to get the where clause?


________________________________
From: STEPHEN <subuloye@...>
To: vantage@yahoogroups.com
Sent: Wednesday, February 8, 2012 1:56 PM
Subject: [Vantage] Cannot get the Db lookup to functoid to work in Service Connect


Hi all,
I can not get the Db lookup to functoid to work in Service Connect.
Trying to use it from a conversion to a webmethod.

It s a simple

SELECT VENDORNUM

FROM VENDOR

WHERE COMPANY = 'XXX'

AND VENDORID = 'XXXXX'

 Has anyone had any joy



Steve




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]