Browse By Tags

  • Detect when table gets updated

    Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…
  • Four T-SQL commands for your toolbox

    I have used the following T-SQL commands quite often when working on the SQL Server side. There are other ways to find some of this information, but you should have these commands in your toolbox. Using the SQL Server Management Studio(SSMS) interface…
  • Error 4262 occurred while trying to create a work order.

    We received this error while trying to create a new W/O. Error: "Error 4262 occurred at frmmfzdh001 in Procedure WOCreateStepsNotesMM. Unable to add the tmfWorkOrdDetl_HAI record because it is trying to reference a record in tmfNotes_HAI that does not…
  • How to call / trigger a Workflow Rule in Code?

    Hi, Does anyone know of a way to call, or trigger a Workflow Rule from within code? Thanks, Mike