Tag: SQL Functions
Checking for URL values for IDN compatability
Yesterday, Kris posted about a new issue in 8.309 regarding URL controls. To check for this condition, I put together a quick SQL function that can be used to check url values to see if they would be affected by this bug.
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 these pretty keys there...
Simple Insert Trigger Example
I previously posted about using an update trigger to enforce data rules in SalesLogix. Since I was working on another trigger now, I also wanted to post a simple example of an Insert Trigger.
Recombining Parsed data in SQL
A couple of weeks ago, I posted about using User Defined functions and Cross Apply to parse data in SQL server. The second part of the import I was working on required me to take that parsed data, perform some manipulations, and then recombine that data. Surprisingly, I found that putting that data together was much more difficult then pulling it apart in the first place. After much experimentation, this is what I came up with...
Using SQL User defined functions and Cross Apply to parse SQL data
Recently, I worked on an import where I spent a considerable amount of time working out how to effectively parse data from a SQL table, for insertion into another table.
