Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SetJoinTable Method

0 views
Skip to first unread message

Marc DESJARDINS

unread,
May 15, 2003, 2:20:37 PM5/15/03
to
Hi,

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

Vinayak Tadas [msft]

unread,
May 15, 2003, 11:15:13 PM5/15/03
to
No this is not possible. You cannot specify columns in the external table as
a part of the SqlWhereClause.

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...

0 new messages