Anyone know how to use the IF-Then-Else in V10?

Yahoo Archive
1

I guess this old dog *takes off sunglasses” - is going to use a new trick.

Sorry, couldn’t help myself.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 10, 2015 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Anyone know how to use the IF-Then-Else in V10?

 

 

Thank you for the replies -

 

 

Thanks again,

 

DaveO

2

I have tried all manner of Parenthesis, and brackets and I can't seem to get the If-Then-Else working for my BAQ calculated fields in Version 10.


I am working on an upgraded DB from V9 and I see that my progress If-Then-Else statements were converted to Case-When-Else statements. 


Just wondering anyone have some insights on this?  I would prefer to use the If-Then-Else just because I think it is cleaner and more intuitive - am I being a snob?


Please advise,


Thanks,

Dave Olender

Ph: 651-246-3281

3
I've asked the same question. The Case statement seems to be your bet.

Joe

On Mon, Nov 9, 2015 at 6:06 PM, daveolender@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p>I have tried all manner of Parenthesis, and brackets and I can&#39;t seem to get the If-Then-Else working for my BAQ calculated fields in Version 10.</p><p><br></p><p>I am working on an upgraded DB from V9 and I see that my progress If-Then-Else statements were converted to Case-When-Else statements.  </p><p><br></p><p>Just wondering anyone have some insights on this?  I would prefer to use the If-Then-Else just because I think it is cleaner and more intuitive - am I being a snob?</p><p><br></p><p>Please advise,</p><p><br></p><p>Thanks,</p><p>Dave Olender</p><p>Ph: <a rel="nofollow">651-246-3281</a></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

4
Its SQL Use a Case Statement


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Mon, Nov 9, 2015 at 8:16 PM, Joe Douglas Trent jdtrent@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><div dir="ltr">I&#39;ve asked the same question. The Case statement seems to be your bet.<div><br></div><div>Joe</div></div><span class="ygrps-yiv-177460823"><div class="ygrps-yiv-177460823gmail_extra"><br><div class="ygrps-yiv-177460823gmail_quote">On Mon, Nov 9, 2015 at 6:06 PM, <a rel="nofollow" target="_blank" href="mailto:daveolender@...">daveolender@...</a> [vantage] <span dir="ltr">&lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt;</span> wrote:<br><blockquote class="ygrps-yiv-177460823gmail_quote" style="border-left:1px #ccc solid;">

 
<div>
  
  
  <p></p><p>I have tried all manner of Parenthesis, and brackets and I can&#39;t seem to get the If-Then-Else working for my BAQ calculated fields in Version 10.</p><p><br></p><p>I am working on an upgraded DB from V9 and I see that my progress If-Then-Else statements were converted to Case-When-Else statements.  </p><p><br></p><p>Just wondering anyone have some insights on this?  I would prefer to use the If-Then-Else just because I think it is cleaner and more intuitive - am I being a snob?</p><p><br></p><p>Please advise,</p><p><br></p><p>Thanks,</p><p>Dave Olender</p><p>Ph: <a rel="nofollow">651-246-3281</a></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>


</div>
 


<div style="color:#fff;min-height:0;"></div>

5

Thank you for the replies -


I guess this old dog - is going to use a new trick.


Thanks again,


DaveO