Hello,  I have a stored procedure in SQL that i would like to call from a Forms Lookup rule.  The SP generates a random string ... that string.     Here is the Stored Procedure USE [Laserfiche_XXXX] GO /****** Object:  StoredProcedure [dbo].[GeneratePassword]    Script Date: 5/13/2025 2:44:46 PM ******/ SET ......

here is to have a stored procedure lookup a table value and return another column value that is incremented (counter column). If the lookup value ... Add the parameters for the stored procedure here     @ProjectName nvarchar(100) = 0,      @NextCARNum int = 1 AS BEGIN     -- SET NOCOUNT ON added to prevent extra result ......

I have a stored procedure that auto-increments a Voucher Number.  I know by default the stored procedure is ran as soon as the form ... to delay or prohibit that stored procedure from running until a condition is met.  For example, when the user filling out the form selects a ......

with values below is a Stored Procedure we run often where @vendorid and @ponumber are passed in through forms.  The look up rule then looks ... keep current with the changing stored procedure . ALTER PROCEDURE [dbo].[getReceipts]     -- Add the parameters for the stored procedure here     @vendorid varchar(50),     @ponumber varchar(50 ......

I can't use a stored procedure because I have no way to pass it the "search between" dates from Forms. 4. I can't ......

understand how to get the stored procedure to run on submission of the form.  It is still running on page load.  Since I don't ... trigger('change');//This is the stored proc value to trigger the procedure event.preventDefault(); waitfunction(); } }); function requiredfilled() { return _.every($('li:has(.cf-required):visible ......

how to best create a stored procedure that allows the user to select the first dropdown, then a second dropdown based off the values returned ... we do not use a stored procedure , then the normal DB lookup will suggest improper values in the second dropdown as it is not using ......

table/view lookups.  Of those stored procedures , 6 of them are accessing the same stored procedure but using different input values from the forms.  Prior ... narrow it down to those stored procedures causing the slow down. Have anyone else had an issue with this and if so, does anyone know ......

users should be returned.  The stored procedure definition should look like this CREATE STORED PROCEDURE spGetUsers    @dept varchar(30),   @grade varchar(30) BEGIN  ... END The ... a parameter when calling the stored procedure ?  Now, I need to create separate stored procedures for different scenarios? Thanks...

#q3 input').trigger('change'); }); }); Stored Procedure : ALTER PROCEDURE [dbo].[UserGroupGuid2] ,-- Add the parameters for the stored procedure here ,@group varchar(50), ,@id bigint AS ... Table: Lookup Rules: Issues: ,The stored procedure appears to only be running on the first "Change" Event in the 'groupinsert' field. ,The Stored Procedure is ......

custom query that runs a stored procedure . The stored procedure uses a token to do a search on a database, and then it inserts it ... So far, we know this: - Stored procedure runs in workflow - Stored procedure doesn't insert values found into table, despite using the same value in ......

our forms, we have a stored procedure that generates unique, sequential purchase order numbers when the form loads. In addition to returning the generated number ... prepending it with 'CN'), the stored procedure also puts it into a table, along with the date, so that we can reference it later if ......

In Forms, we have a stored procedure that works great.  When connecting to the same database via workflow, we don't see the stored procedure ......

the Form is using multiple stored procedures to load fields with data?...

lookup rules by using SQL( Stored Procedure ) and I don't understand how to get populate on my form so please show me a great ......