V4RB SQL Select Problem

[Cindy]

Hi François, 

Funny, I hadn't even thought of that but it will work fine.

Thanks for your help.

Cindy

> Hi Cindy,
> 
> le 14-10-03 7:44, Cindy <alvin at ins.co.nz> a écrit :
> 
>> I thought I had fixed it but seems I was wrong. I cannot get a select query
>> to compare one field with another field.
> 
> I don't think Valentina allow us to compare 2 fields in SQL query.
> 
>> My Age-3 (now AgeN3) field works
>> out the age of the student less 3 years. I then want to know all students
>> who have a ministry year that is less than or equal to that method field
>> (AgeN3). Both in viSQL and in V4RB I get a 616 error and the select fails. I
>> can display all with a ministry year less than 3, for example, but that is
>> not what I want. I want to bring up a select based on the results of two
>> different fields - only select the records whose ministry year is less than
>> their age-3.
> 
> I think you could use a method field in witch you do the calculation (Age -
> Ministry_Year). Now you can do :
> 
> Select ... From Students WHERE Age_Years <= 8 AND AgeLessMinistry_Year <= 3
> 
> Best regards
> 
> François Van Lerberghe
> Thier Monty, 15A
> B-4570 Marchin
> Belgique
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>