CASE is not RESERVED word????
Is strange to use in where clause....where case='123'

Paul

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of dr_bentonquest
Sent: Tuesday, February 14, 2006 7:52 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Desperately Seeking FB 2.0 Beta 1 !

> 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.

> > Yes, it's all my fault, but I really need a hand right now, I am
> > desperate. Please tell me where can I download FB 2.0 Beta 1 for
> > Windows or, if you can, send it to conversar@... but please
> > rename the extension first, as gmail can't accept exe attachments.
> >
> > Again, I'm really sorry to ask for help here, but I am desperate.
>
> I might be able to put one up for you if it's really needed.

I really appreciate it.

Thanks,

-Benton






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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