Login / Register  search  syndication  about

          George Jensen's Blog

George Jensen on Reporting, Business Intelligence, Crystal Reports, Visual Analyzer, and more.

Running a SQL Update Statement from Saleslogix Web

I am working for a client who would like a button to set all of the records in a table to either "Valid" or "" (blank).  This then allows them to build groups on what records needs to be updated.  I started my adventure by reading Kris Halsrud's post Retrieving the Manager in SalesLogix 7.5 Web .   The solution Kris outlines provided most of what I needed and direct conversation with Kris himself provided the rest.  I wanted to document it here so I do not have to bug him the next time I need to do this.

This is what our C# Snippet Action item looks like launched from the button.

Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>();

using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(datasvc.GetConnectionString()))

{

conn.Open();

System.Data.OleDb.OleDbCommand cmd =
new System.Data.OleDb.OleDbCommand("update sysdba.TABLE set FIELD = 'Value'",conn);

cmd.ExecuteNonQuery();

}

 

The green text is the slq statement, the rest should be able to be used as is.  I hope this little post helps someone else down the line.

Thanks

Geo

What's This?
  
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.


Related Content
   Infor CRM (Formerly Saleslogix) Iterating through all tabs on a Page
 Using the TabWorskpace you can iterate through all the tabs on a page and do something with them, l
Posted on Jun 19, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (Formerly Saleslogix) Hiding Tabs at Runtime Without Using Modules
 As Ryan wrote a long time ago, you can create a module and add it to a page in the Infor CRM web cl
Posted on Jun 10, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   How I assign ownership to a group of Leads in Infor CRM?
There is a tool within Infor CRM to align Accounts to different Account Owners. It is called Territory Re
Posted on Jun 05, 2015 by Dale Richter to Infor CRM Questions & Answers
 
   Infor CRM (Formerly Saleslogix) Adding a Client Side Confirmation on a Dependency Lookup in the Web Client
 We recently had a client who wanted to have a user confirmation prompt before a user was allowed to
Posted on May 28, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (Formerly Saleslogix) Embedding quickforms on quickforms
 I recently had a client who needed to have a lot of elements on a form.  They wanted a kind of
Posted on May 20, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

 

Twitter Trackbacks for Running a SQL Update Statement from Saleslogix Web - George Jensen's Blog [customerfx.com] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 Running a SQL Update Statement from Saleslogix Web - George Jensen's Blog         [customerfx.com]        on Topsy.com

June 23, 2010 4:51 PM
 

Kevin Gillen said:

What about returning a value from a singular field via a select statement ...

Select <fieldname> from <dl_inv_hist_det> where accountid = '<accountID value>' and product_id = '<actual_ID>' value

January 22, 2011 6:44 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2015 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register