[Valentina] Re: V4RB SQL Query Problem

[alvin]

Hi Ruslan,

I have removed the indexes, downloaded the latest Beta but nothing has
worked. I have a method field which calculates whether a student has started
before five or after five. The method works correctly giving me a boolean
answer - 0 if they started before five, 1 if they started after five. I can
see the boolean field and it is working as it should. But if I try to use an
SQL query to find only those who start before five (boolean 0) the query
returns no records. I have tried this on viSQL and the same thing happens. I
have tried it on two completely different databases and the same thing
happens. This appears to happen on all my boolean method fields which is
extremely frustrating.

Any ideas? My current feeling is that this is a bug in the program. I really
need help with this as it is required for government forms which are due
very soon.

Thanks very much.

Cindy

> From: alvin <alvin at ins.co.nz>
> Reply-To: valentina at lists.macserve.net (Subscribers of Valentina)
> Date: Fri, 10 Jan 2003 20:20:03 +1300
> To: valentina at lists.macserve.net (Subscribers of Valentina)
> Subject: Re: V4RB SQL Query Problem
> 
> Hi Ruslan,
> 
> Thanks for that. I'll give it a try and see what happens.
> 
> Cindy
> 
>> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
>> Reply-To: valentina at lists.macserve.net (Subscribers of Valentina)
>> Date: Thu, 09 Jan 2003 14:21:33 +0200
>> To: valentina at lists.macserve.net (Subscribers of Valentina)
>> Subject: Re: V4RB SQL Query Problem
>> 
>> on 1/9/03 3:30 AM, alvin at alvin at ins.co.nz wrote:
>> 
>>> Hi,
>>> 
>>> I have the following SQL Query in V4RB:
>>> 
>>> SELECT Last_PreferredName, Room, Year, Gender, Date_Of_Birth,
>>> Date_Started_School, bStartFive, RecID From Students WHERE bstartFive = 0
>>> 
>>> bStartFive is a BOOLEAN METHOD which returns results 1 or 0 and has two
>>> records containing 0. The field is valid as I can return the information as
>>> soon as I take out the WHERE query.
>>> 
>>> The problem is that this query returns no records when it should be
>>> returning 2. Is there a problem with Boolean Methods? I am running Realbasic
>>> 4.5.2 and Valentina 1.9.5. I have tried it with 1.9.6 and have had the same
>>> problem.
>>> 
>>> Any help with this would be appreciated.
>> 
>> 
>> Try rebuild indexes.
>> 
>> 
>> -- 
>> Best regards,
>> Ruslan Zasukhin      [ I feel the need...the need for speed ]
>> -------------------------------------------------------------
>> e-mail: ruslan at paradigmasoft.com
>> web: http://www.paradigmasoft.com
>> 
>> To subscribe to the Valentina mail list
>> send a letter to valentina-on at lists.macserve.net
>> -------------------------------------------------------------
>> 
>> 
>> -------------------------------------------------------------
>> The Valentina mailing list is brought to you by MacServe.net
>> For info on lists services, see http://www.macserve.net/lists.html
>> 
> 
> 
> -------------------------------------------------------------
> The Valentina mailing list is brought to you by MacServe.net
> For info on lists services, see http://www.macserve.net/lists.html
>