Conditional IF by SQL

[PaulJL]

I am trying to build 2 SQL statements that are only executed if they fulfill the If..Then conditional statements below. I have a parameter called approve that can have the value of "Yes" or "No". Please note that the SQL works fine without the If...Then. I've tried all the combinations but I am getting nowhere:

If '::approve::'='Yes' Then
UPDATE customer_IN SET approve='::approve::', client_notes_to_ubm='::notes::', cleared_bank='cleared' WHERE customer_account_ref='::customer_reference::' AND account_name='::account_name::'
End If

If '::approve::'<>'Yes' Then
UPDATE customer_IN SET approve='::not_approved::', client_notes_to_ubm='::notes::', cleared_bank='cleared' WHERE customer_account_ref='::customer_reference::' AND account_name='::account_name::'
End If

If someone could kindly help me if it is possible to wrap 2 SQL statements in If..Then conditions.

 

[Russell Hauf]

On 2002-12-05 10:52, PaulJL wrote:
I am trying to build 2 SQL statements that are only executed if they fulfill the If..Then conditional statements below. I have a parameter called approve that can have the value of "Yes" or "No". Please note that the SQL works fine without the If...Then. I've tried all the combinations but I am getting nowhere:

If '::approve::'='Yes' Then
UPDATE customer_IN SET approve='::approve::', client_notes_to_ubm='::notes::', cleared_bank='cleared' WHERE customer_account_ref='::customer_reference::' AND account_name='::account_name::'
End If

If '::approve::'<>'Yes' Then
UPDATE customer_IN SET approve='::not_approved::', client_notes_to_ubm='::notes::', cleared_bank='cleared' WHERE customer_account_ref='::customer_reference::' AND account_name='::account_name::'
End If

If someone could kindly help me if it is possible to wrap 2 SQL statements in If..Then conditions.

I'm confused. You are having the user enter a parameter which you name "approve", then you want to update that same field ("approve") to something else? First, I think you should re-name the parameter that the user enters. For this example, let's call it APP.

Try the IIF function. Something like:

SET approve=IIF([APP]="YES",'::approve::','::not_approved::'), client_notes_....

You may want to put in a UCase([APP]) to account for the case where "yes" is put in. Note that this will change anything other than yes to not_approved.

HTH,

Rusell