Relational Theory (E-R Model to SQL Conversion) – Relationships (one-to-one, one-to-many and many-to-many)

This post details about relational theory relationships. I’ve struggled to find on the Internet any decent explanations of what these are in simplistic terms which are degree/masters degree level, and not primary school or PhD examples! I’ll introduce the types of relationship, with some simple examples showing how the relational theory of relationships is actually […]

More...

Compass ProSolution 9.2 PowerShell Task Error

After the upgrade to ProSolution 9.2, I found that the tasks we ran which used PowerShell with the ProSolution Worker Service failed with the following error message: Error:  – System.Management.Automation.Runspaces.PSSnapInException: An error occurred when loading the system Windows PowerShell Snap-Ins. Please contact Microsoft Support Services. —> System.Management.Automation.PSArgumentException: Unable to access Windows PowerShell PowerShellEngine registry information. […]

More...

PCounter – Resolving the ERROR: DATA AREA PASSED TO A SYSTEM CALL IS TOO SMALL ERROR MESSAGE” when printing to a pull queue

When using PCounter you have a separate queue that will take the job from the client; this is then passed to the queue that relates to the printer identified by the swipe card box the user swiped their card through. I.e. you print to a holding queue, the job stays there until you swipe your […]

More...