Yes but because it is in quotes it is OK.

Bogusław Brandys wrote:

> dr_bentonquest wrote:
>
>>> Two things...
>>>
>>>
>>>> I'm really sorry to post this here, but I made a mistake. I used FB
>>>> beta 1 on a production system and everything went fine, but when I
>>>> upgraded to beta 2, I got erratic behavior on select statements, so I
>>>> need to go back to beta 1. Problem is I can't find it on SF.
>>>>
>>> 1) What errors? You might want to list them here, perhaps it's
>>> a known thing or perhaps there's a workaround.
>>>
>> SELECT ID,STATUS FROM TRACKING WHERE CASE='123'
>>
>> Results:
>> ID,STATUS
>> ---------
>> 12,20
>> 13,30
>> 14,40
>>
>> So far so good. But when I try this:
>>
>> SELECT ID,STATUS FROM TRACKING WHERE CASE='123' AND STATUS<50
>>
>> nothing is returned. I've recomputed indexes but no luck.
>>
>>
>>> 2) using a beta in production? And then another beta???
>>>
>> Yes. Beta 1 was working fine for me.
>>
>
> Please give us more detailed informations: platform,Tracking table
> structure , indexes,plan etc...
>
> Why you use CASE as table column name ?
> Isn't it a reserved word ?
>
> maybe :
> SELECT ID,STATUS FROM TRACKING WHERE TRACKING."CASE" ='123' AND
> TRACKING.STATUS<50
>
>
>
>
> Regards
> Boguslaw brandys
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
Thomas Miller
Chrome Portal Project Manager
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus