I want to use the SetJoinTable Method and be able to specify
a CatalogSearch.SqlWhereClause on a field in my external table.
When i do this it crashes:
"ICatalogManager::Search returned null. This can happen if the specified
catalog does not exist or if the searchOptions.PropertiesToReturn is
invalid."
First, is it possible?
Here's my code:
=============
CatalogSearch cs = new CatalogSearch(CommerceContext.Current.CatalogSystem);
CommerceContext.Current.CatalogSystem.SetJoinTable("Software_External","Prod
uctID","ProductID",CatalogJoinType.InnerJoin);
cs.SqlWhereClause = "MyDesc LIKE '%baseball%'";
DataSet ds = cs.Search();
"MyDesc" is a field in the external table, if i specify for example
"Description" which is part
of the catalog, no error occurs and i see the results.
I did tried to set values to PropertiesToReturn of the CatalogSearchOptions
Object but the same
error occur.
Anyone has an idea?
Thank's
Marc
Thanks
Vinayak Tadas
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks
"Marc DESJARDINS" <marc.de...@cactus.ca> wrote in message
news:epDQw6wG...@tk2msftngp13.phx.gbl...