The GetProductID function is used to look up and return the Saleslogix ProductID for a specified connection based on the product name or product actual ID.
Note: Returns null if no product ID is found.
GetProductID (
For example:
GetProductID ("MyTarget", "Jumbo Motor D4", "N" )
GetProductID ("MyTarget", "543-J66", "I" )
From the specified connection, runs one of the following SQL statements:
‘select productid from product where name = “product value” ‘ (option
N)
‘select productid from product where actualid = “ product value ”’ (option
I).
See also