Tag: Database

  • Content Type

SQL Function for Creating Pretty Key Values for Data in Infor CRM

Some entities in Infor CRM (Saleslogix), such as Tickets, use a “pretty key” as an easier to use value to reference the record. These pretty keys take a table ID value and then create a value like 000-00-001234. If you are creating an external application with this functionality, you’ll need to be able to create […]

SQL Stored Procedure to Create SalesLogix Table ID Values

Most of the SalesLogix systems I see now days no longer use remote users. Instead, all users VPN into a central network to access SalesLogix, or use the SalesLogix Web and Mobile clients instead for remote users. This removes the need to worry about things like synchronization for remote users and also allows you to do some SalesLogix table manipulation without going through the SalesLogix OLE DB Provider since things no longer have to be "s...

Flattening Out SalesLogix Data To Combine Multiple Rows into a Single String using SQL

A question came up from a person attending our current Report Writing class about how to flatten out data that exists as multiple rows in the database to a single string in a report. There is a really cool trick you can do in SQL to accomplish this which I previously outlined in a post on my personal blog where I outline a technique that can be used to make a query append each value from the rows in the query to a variable. Without using cursors,...

Fixing the Orphaned SYSDBA SQL User

Ok, I see in my logs constantly google searches for “fixing the sysdba user“ that lead to this blog. This is a common thing I find in my logs, but strangely enough, I’ve never posted anything about fixing the sysdba user. So, drumroll…   sp_change_users_login 'Update_One', 'sysdba', 'sysdba'   Ta-da! For people who work with SalesLogix […]

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!