The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix COM interfaces from external applications, such as SlxApplication, ClientObjix, etc. View the code of conduct for posting guidelines.
|
|
|
|
Big Urgent problem creating a lookup, or a temp Group
Posted: 22 Aug 06 6:37 PM
|
fiogf49gjkf0d Hi all,
I'm developing with C#. I'm having problems when I try to create a lookup, or a temp Group trough VS 2003.
here is teh code that I'm Using:
SalesLogix.SlxApplicationClass SLX = new SalesLogix.SlxApplicationClass(); SLX.BasicFunctions.CreateTempGroup("Opportunity", "TempGroup", "Opportunity:accountid", "in", "select accountid from account", "");
this doesn't show any error message, but it doesn't show any result neither.
what am I doing wrong? it's verry important to me, so any help that could be sent to me will be verry useful.
Thanks,
Tomás Ruiz. |
|
|
|
Re: Big Urgent problem creating a lookup, or a temp Group
Posted: 23 Aug 06 7:53 AM
|
fiogf49gjkf0d I'm not expert on that SLX function, but from the looks doesn't it just create the temporary group? After creating it wouldn't you have to SHOW it or do a refresh or something to make it the active visible group?
If so, that would explain why you are not getting an error.
John G. |
|
|
|
Re: Big Urgent problem creating a lookup, or a temp Group
Posted: 23 Aug 06 11:41 AM
|
fiogf49gjkf0d Thanks John,
Acctualy it does create a temp Group in SalesLogix (6.2.4 by the way) at the time that the code is executed, and it' shown as "lookUp Results", all by itself, but the thing is that it shows nothing, even if I press F5 or CTRL+F5.. nothing hapend..
Tomás Ruiz. |
|
|
|
Re: Big Urgent problem creating a lookup, or a temp Group
Posted: 23 Aug 06 12:23 PM
|
fiogf49gjkf0d I did it!!!!
I've found how to make it works!!!,
there was a little bug that was cousing the problem. You have to work with it just like it's a SQL Sentence.
Here is an Example:
In the Parameter I've wrote "Opportunity", In the Parameter I've wrote " ", In the Parameter I've wrote "OpportunityID", In the Parameter I've wrote " IN ", (Operator) In the Parameter I've wrote "(Select OpportunityID from Opportunity)", (Condition) In the Parameter I've wrote "", (Useless for me)
SLX.BasicFunctions.CreateTempGroup("Opportunity", " ", "OpportunityID", " in ", "(Select OpportunityID from Opportunity)", "");
in that way it builds a SQL Sentence with this form....
"Select * from Oportunity where OpportunityID IN (Select OpportunityID from Opportunity)"
Of course this returns all of the Opportunities in DB for the actual User.
but that's the way it works... is verry simple... but it did gave me some troubles.
Hope this helps you in the future,
Sorry for bothering you |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|