Archives
If you even need to find out all store procedures that contain certain phrase, such as “PurchaseOrders”, the following query will help. select so.name, sc.text from syscomments sc inner join sysobjects so on sc.id = so.id where so.xtype = ‘P’ and sc.text like ‘%PurchaseOrders%’ This can be extended to other object type, for example ‘TR’ […]
In Syteline, there are many ways to default field value. The most simple way is to use the default value property of the field component. But if you need to set the default value based on some other field value, that simple property value would not cut it. Syteline Application Case We want to default […]
We will use a sample to run through the process of adding a CLM into IDO. Part of making the Customer Document Profile function available to RMA verification report, we need to create a new CLM to IDO SLRmas. The CLM is based on SP navProfileRMAVerificationSp. create PROCEDURE [dbo].[navProfileRMAVerificationSp] ( @RMAStatusOpen ListYesNoType = NULL, […]
SQL server provides way to connect to remote database (SQL, Oracle and many others). Within your store procedure, you can dynamically connect to the remote DB, fetch data, process them into Syteline DB. Business Case: Let’s say you have a web store database, in a remote database server. You want to replicate the orders into […]
Here is a basic way to call a SQL Store Procedure (SP) within a script, either Form Script or Inline Script. The sample we use below is calling a SP: GetCustType and return the CustType value to a form variable. Dim nRetVal As InvokeResponseData Dim nRequest As New InvokeRequestData() nRequest.IDOName = “SP!” nRequest.MethodName = “GetCustType” […]