Hello,
Sorry if my question is a bit confusing.
in practice I have a form where there is a checkbox of type true / false.
In this form there is...

Hello Joe

Thanks for your Reply, when i write : mylogicVariable is a variable that i declare in VFP.
what  i want  is :
 Where 
BO.LOGI1 = (case...

Hello,
The  LEFT  join condition doesn´t have solve the problem. I keep the original query and i have adding UNION ALL changing my Where condition and finally i solve the...

Hello,
Thanks for your reply.

Best regards,
Luis

Thank you all for the help.

Best  regrards,
Luis

Hello Thom,
Thanks for your advise.

Best regards,
Luis

hello again,

Thanks but i solve the problem assigning values to my DECLARE variables:

   DECLARE @obrano    numeric(10, 0) = 1025 «« declare here the value
   DECLARE...

Hello Lynn

Thanks for  your  reply and advise.
Best regards,
Luis

Hello Steve,

Thanks for your reply, but sql server return this error:
Procedure expects parameter '@params' of type 'ntext/nchar/nvarchar'.

Many thanks,
Luis

Hello Antony

Many thanks for your help.
I try your script, but is returned this error:
Must declare the scalar variable "@_myobrano".

Best regards,
Luis

Hello Lynn

Many thanks for your Reply and explanation.

Best regards
Luis

Hello Sergiy

After some test, i change the script like this:

USE [NMYDATABASE]

GO

/****** Object: Trigger [dbo].[trgAfterINSERT] Script Date: 12/02/2016 10:19:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[trgAfterINSERT] ON...

Hello Sergiy

I rebuild my trigger with your script, but if i make a new document and save my column don´t update with the information. Why ??

Also you refer that my...

Hello comunity

I solve the problem that is due to have another INSERT TRIGGER, then i run after rebuild my Trigger the triggers - order of execution

exec sp_settriggerorder @triggername...