Skip to Content
0
Former Member
Mar 04, 2009 at 07:56 PM

Help with Formatted search involving a UDF

47 Views

I have a Formatted search which runns the following code:

exec xsp_nssItemLookup $[$38.256.0]

This search is on a udf of the Purchase order screen. (256 is the item details field in the details.

The above query runs fine. What I really want to do is to pass the contents of another UDF to the stored procedure. The USF is called U_NSSItemID. If I change my stored procedure to read:

exec xsp_nssItemLookup $[$38.U_NSSItemID.0] however it does not work. I get blank results every time.

I have also tried exec xsp_nssItemLookup $[POR1.U_NSSItemID.0] which doesn't work either.

I can't figure out what is wrong with my syntax. I don't get any errors, just a blank value.

Thanks

don shields