Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 9 of 9 total

Fri, Mar 17 2006 6:51 AM	Permanent Link
Ricardo Oliveira	Hi! I have a problem with this SQL: "Select Field1 from Table1 where Field1=-1" where FIELD1 type is Word. I was expecting the query to return zero rows or DBISAM to throw an exception, yet the query returns every record where FIELD1 = 0. Filtering the table also returns the same result. Is this the expected behavior or is it a bug? Ricardo Oliveira
Fri, Mar 17 2006 9:30 AM	Permanent Link
Eryk Bottomley	Ricardo, > I have a problem with this SQL: > > "Select Field1 from Table1 where Field1=-1" > > where FIELD1 type is Word. What version of DBISAM are you using? Eryk
Fri, Mar 17 2006 9:52 AM	Permanent Link
Ricardo Oliveira	Sorry, DBISAM 4.22 Build 3 and Delphi 7. Eryk Bottomley escreveu: > Ricardo, > >> I have a problem with this SQL: >> >> "Select Field1 from Table1 where Field1=-1" >> >> where FIELD1 type is Word. > > What version of DBISAM are you using? > > Eryk
Fri, Mar 17 2006 1:27 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Ricardo, << Is this the expected behavior or is it a bug? >> It's a bug. A new build will be going out Monday and a fix for this will be included. -- Tim Young Elevate Software www.elevatesoft.com
Fri, Mar 17 2006 1:32 PM	Permanent Link
Ricardo Oliveira	Thanks Tim. Tim Young [Elevate Software] escreveu: > Ricardo, > > << Is this the expected behavior or is it a bug? >> > > It's a bug. A new build will be going out Monday and a fix for this will be > included. >
Mon, Mar 20 2006 11:15 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Ricardo, << A new build will be going out Monday and a fix for this will be included. >> Actually, one small revision - this has been pushed forward to Friday due to some outstanding issues that I forgot still needed addressing. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Mar 20 2006 1:47 PM	Permanent Link
Sean McCall	Can't miss this week's Dr Phil? Tim Young [Elevate Software] wrote: > Ricardo, > > << A new build will be going out Monday and a fix for this will be included. > >> > > Actually, one small revision - this has been pushed forward to Friday due to > some outstanding issues that I forgot still needed addressing. >
Tue, Mar 21 2006 2:31 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sean, << Can't miss this week's Dr Phil? >> Don't get me started - that guy is a first-class tool. I hate people that try to simplify life into little inspirational sound-bites in order to make money, which is why the self-loathing kicked in when I did just that in that other thread with Rita. -- Tim Young Elevate Software www.elevatesoft.com
Tue, Mar 21 2006 3:19 PM	Permanent Link
Sean McCall	Couldn't agree more - I don't think he deserved his 1st 15 minutes of fame and certainly don't get why it has lasted so long. I just wish he would stop showing up everywhere and stay confined to miserable daytime tv. Sean Tim Young [Elevate Software] wrote: > Don't get me started - that guy is a first-class tool.