Tag: SQL

  • Content Type

Executing Direct SQL Statements in a Process or Configuration Web Service in Creatio (formerly bpm’online)

Creatio does have a lot of options for working with objects/data with an Entity object model, EntitySchemaQuery, Select/Update/Insert objects (I’ll get around to writing articles on these topics as well). You can also execute a SQL statement directly when needed as well. Before we get into the code, it’s worth mentioning, executing a SQL statement […]

Load order issue in Infor CreateUnicodeDB utility

I recently bumped into an issue with the order in which the utility (CreateUnicodeDB) creates database objects.  SQL Users and schemas are processed first, followed by SQL tables, followed by the other SQL objects.  In this particular database, there were scalar UDFs being used to create computed columns in a number of the SQL tables.  Since the utility creates Tables before UDFs, it would error out on any table referencing that non-existent U...

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 […]

Clearing all Activity Notifications in Infor CRM with a SQL Statement

If you’ve ever imported activities into your Infor CRM (Saleslogix) database, you’ll likely hear from users that they’ve been bombarded with notifications. In some instances, you might want to clear those notifications so newly created activity notifications don’t end up getting lost in them all. Luckily, you can do that with a single SQL statement. […]

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...

Updating text within Textblob fields in SalesLogix

I had a request to post on how you could replace characters within a blob field in the SalesLogix database. Blob fields are database fields that hold any sort of binary information (such as text, images, audio, etc..), but SalesLogix uses them primarily for holding large amounts of text, since you don't have to define a field length. The LongNotes field in the History table is a good example.

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.

Running Sql Server Integration services package from a C Sharp application

If you've ever created a SSIS package and wanted to provide a way for end users to run that package without having to run the Business Intelligence Development studio, you can compile the package into a dtsx file for them to run. This would require them to manually alter connections and variables, which can get complicated for an average end user. Alternatively, it is pretty simple to put together an application which can be used to run the ...

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!