× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2003

Re: Query400 question

Not in Query/400, as far as I know. However, it is possible in SQL with the CASE statement

CASE when xpto='EXW'
then var1=value*0,3
else
var1=value*0,4
END CASE

This can be placed directly into a SELECT statement.

At 03:30 PM 1/20/03 +0000, you wrote:
Hi,

It is possible to define conditions to use on variables defined in a query
?

IF  xpto='EXW'
var1 = value*0,3
else
var1 = value*0,4

var1 is a variable define on the query (definition of a result field)

Cordialement,
Best regards,
-------------------------------------------------------------------
Pedro Reis
Information System
e-mail: pedro.reis@valeo.com
Phone: 351-258 350 725
Fax: 351-258 350060
--------------------------------------------------------------------
VALEO - Electronics & Connective Systems
Viana do Castelo - Portugal
--------------------------------------------------------------------























As an Amazon Associate we earn from qualifying purchases.




	



This thread ...











 
  Replies:




 



























Follow On AppleNews

Return to Archive home page | 
Return to MIDRANGE.COM home page





 


This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].



Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.