Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 6 of 6 total |
Build 6: #700 Error |
Fri, Jan 19 2007 1:42 PM | Permanent Link |
Charalabos Michael | Hello Tim,
SQL: UPDATE Folders SET TotalCount = TotalCount + 1 WHERE Name = 'test' AND (UserID=0 or UserID=NULL)' <UserID and TotalCount are Integers> Error: ElevateDB Error #700 An error was found in the statement at line 4 and column 25 (Expected NULL, Boolean, SmallInt, Integer, BigInt, Float, Decimal, Interval Year, Interval Day, Interval Hour, Interval Minute, Interval Second, Interval or MilliSecond expression but instead found NULL). -- Charalabos Michael - [Creation Power] - http://www.creationpower.com - http://www.creationpower.gr |
Fri, Jan 19 2007 2:34 PM | Permanent Link |
Michael Baytalsky | Just out of curiosity, did you try UserID is NULL? Michael PS. Got to download and see for myself Charalabos Michael wrote: > Hello Tim, > > SQL: > UPDATE Folders > SET TotalCount = TotalCount + 1 > WHERE Name = 'test' > AND (UserID=0 or UserID=NULL)' > > <UserID and TotalCount are Integers> > > Error: > ElevateDB Error #700 An error was found in the statement at > line 4 and column 25 (Expected NULL, Boolean, SmallInt, Integer, > BigInt, Float, Decimal, Interval Year, Interval Day, Interval Hour, > Interval Minute, Interval Second, Interval or MilliSecond expression but > instead found NULL). > |
Fri, Jan 19 2007 3:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Error: ElevateDB Error #700 An error was found in the statement at line 4 and column 25 (Expected NULL, Boolean, SmallInt, Integer, BigInt, Float, Decimal, Interval Year, Interval Day, Interval Hour, Interval Minute, Interval Second, Interval or MilliSecond expression but instead found NULL). >> The error message is wrong. In EDB, = NULL or <> NULL is not accepted anymore in favor of the standard IS NULL or IS NOT NULL. Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jan 19 2007 8:03 PM | Permanent Link |
Charalabos Michael | Hello Michael,
> Just out of curiosity, did you try UserID is NULL? I did now and it works.I Just need to get used to the new SQL changes! -- Charalabos Michael - [Creation Power] - http://www.creationpower.com - http://www.creationpower.gr |
Fri, Jan 19 2007 8:04 PM | Permanent Link |
Charalabos Michael | Hello Tim,
> << Error: > ElevateDB Error #700 An error was found in the statement at line 4 and > column 25 (Expected NULL, Boolean, SmallInt, Integer, BigInt, Float, > Decimal, Interval Year, Interval Day, Interval Hour, Interval Minute, > Interval Second, Interval or MilliSecond expression but instead found > NULL). >> > > The error message is wrong. In EDB, = NULL or <> NULL is not accepted > anymore in favor of the standard IS NULL or IS NOT NULL. Yeap, IS Null works. I think you should fix the text in the error message ? -- Charalabos Michael - [Creation Power] - http://www.creationpower.com - http://www.creationpower.gr |
Mon, Jan 22 2007 8:18 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Yeap, IS Null works. I think you should fix the text in the error message ? >> Yes, you can safely assume that all errors will be fixed once they are found. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |