slxdeveloper.com Community Forums

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!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: CurrentOpportunityID?

Andrew Grandin
Posts: 272

CurrentOpportunityID? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 May 10 7:35 AM

Hi All, small problem im sure most people have come across by now but how do you retrieve the current opportunity ID in 7.5 web? I want to use it in mny code below in the sql string.

Thanks all.
'''''''''''''''''''''''''''''''''''''''''''''''''
Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get();
string connStr = service.GetConnectionString();

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr);

//Open connection
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
string result;
//Build and execute SQL
string sql = "SELECT MAX(STAGEORDER) FROM SALESPROCESSAUDIT WHERE ENTITYID = '" + ??????????? + "'";
cmd.Connection = new System.Data.OleDb.OleDbConnection(connStr);
cmd.Connection.Open();
cmd.CommandText = sql;
cmd.ExecuteScalar();
//If the statements executes then there is a value
result = cmd.ExecuteScalar().ToString();
cmd.Connection.Close();

[Reply][Quote]

Andrew Grandin
Posts: 272

Re: CurrentOpportunityID? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 May 10 8:08 AM

i think ive found this now but i have a another small problem. i need my code executed as soon as the user clicks on a hyperlink step in the sales process.

Just to find the right event i placed message boxes at the top of the following events:

cmdDoAction_OnClick, DoAction and DOActivity (tested on a phone call) but the message box did not show on any of them!

what is fired immediately after a user click on a sales process step????

Thanks for your help all.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/30/2025 10:25:48 AM