Instructions on Adding Button:

Create procedure

CREATE procedure [dbo].[uspVPGridQueryType] /** User Defined Validation Procedure **/
(@QueryName varchar(50), @Type int, @ReturnMessage varchar(max) output)
AS
DECLARE @rcode int
SELECT @rcode = 0
UPDATE [Viewpoint].[dbo].[vVPGridQueriesc] 
 SET QueryType=@Type, IsAssignableInWorkCenter='N' 
 WHERE QueryName=@QueryName AND IsStandard='N'
IF @@ROWCOUNT = 0 
 SELECT @ReturnMessage = Concat(@QueryName,' not updated. Perhaps it does not exist, or is a standard VP query?'), @rcode = 1
ELSE 
 SET @ReturnMessage = Concat(@QueryName,' type updated.')
return @rcode

and set it's permissions so it can be used. (or create it using VP's UD User Validation, and the permissions will be set automatically)

Create button

• Use VA Custom Form Buttons to add a button to VAQueries.
• Label it like Set Type to "Form"
• Set Type to Stored Procedure
• In Action put "uspVPGridQueryType"
• Set Button Refresh to Refresh Record.

Switch to Parameters tab

• Set up the parameters like so, each row as below (ParameterID, Name, DefaultType, DefaultValue)
  • 1, @QueryName, 3-Form Input Value, 5
  • 2, @Type, 0-Fixed value, 2
  • 3, @ReturnMessage, 0-Fixed value, 0
• Close VA Custom Form Button form.
• Close VA Inquiries if open, and open it again.
• Move/ resize the button to where you want it.

USAGE

IN VA Inquiries, move to your query and go to the Info tab. Now you can tap the custom button to set it to 'Form', and thus be used in a custom tab anywhere you like!

Notes

• Still only useful if the main form has a VA Inquery setup for it so you can link to it.

Viewpoint, How about letting us set up parameters in the custom tabs based on a query area?