Login / Register  search  syndication  about

          Infor CRM Questions & Answers

Your place to get answers to your SalesLogix related questions.

 Home  |   Subscribe via RSS  |   Subscribe via E-mail  |   

Default Values From a Standalone Table in SalesLogix

Question: I have a one row, standalone table that holds default values, and there is a custom entity that I would like to populate with these values when I click a button.  My goal is to create a business rule that will return default values from a standalone table, and then will populate values at the entity level.  I was thinking that to get the default values I should run SQL because I have used SQL in custom smartparts in the past.  I used this code in the business rule:

System.Data.OleDb.OleDbConnection oConn = (System.Data.OleDb.OleDbConnection)data.GetConnection();
oConn.Open();

But I get the error: The type or namespace 'Data' does not exist in the namespace 'System'

I added System.Data and get the same error.  How can I run SQL in the business rule, and is there a better way to return the values from this standalone table to a business rule on my custom entity?

Answer: To correct your issue you may need to edit this file:
C:\Documents and Settings\All Users\Application Data\Sage\Platform\Configuration\Global\codesnippets.xml and add the location of the system.data.dll to the defaultreferences section: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll

What's This?
  
Bookmark and Share

About SalesLogix Support

   Your SalesLogix Business Partner for SalesLogix Support.


Related Content
   Can I Bind an Attachment to a Specific Activity in Infor CRM version 7.54?
Recently I had a user ask if they could bind an attachment to a specific Activity within Infor CRM??
Posted on Jul 07, 2015 by Dale Richter to Infor CRM Questions & Answers
 
   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) Administrator Locked Out
I thought I had seen all the issues affecting the datalink but this was a new one. We could not login t
Posted on Jun 18, 2015 by Mark Duthoy to SalesLogix Support
 
   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
 
Comments

No Comments
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