Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread #700 Error
Thu, Jan 18 2007 4:33 PMPermanent Link

Charalabos Michael
Hello Tim,
  With the below SQL:
  INSERT INTO Folders
  VALUES (1, 1, ''hello'', TRUE, 0, 0, 0, 1, ''test'', NULL)

  I got the following error:
  ElevateDB Error #700 An error was found in the statement at line 2
  and column 97 (Expected NULL, CLOB expression but instead found NULL).

--
Charalabos Michael - [Creation Power] - http://www.creationpower.com -
http://www.creationpower.gr
Thu, Jan 18 2007 4:39 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<<  I got the following error:
  ElevateDB Error #700 An error was found in the statement at line 2
  and column 97 (Expected NULL, CLOB expression but instead found NULL). >>

What is the type of the column that the NULL is being inserted into ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jan 18 2007 5:12 PMPermanent Link

Charalabos Michael
Hello Tim,

> <<  I got the following error:
>    ElevateDB Error #700 An error was found in the statement at line 2
>    and column 97 (Expected NULL, CLOB expression but instead found NULL). >>
>
> What is the type of the column that the NULL is being inserted into ?

CLOB

--
Charalabos Michael - [Creation Power] - http://www.creationpower.com -
http://www.creationpower.gr
Thu, Jan 18 2007 5:39 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< CLOB >>

Got it.  It's now fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image