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

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

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

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

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

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