[EMAIL PROTECTED] wrote: > I just started with SAPDB and get stuck with this primitive problem: > Environment: windows 2000 pro, SAPDB 7.4.3.30, using SQL Studio 7.4 > > Step 1. a simple table: > CREATE TABLE "DBA"."TEST" > ( > "SMOKE" Boolean > ) > > Step 2. try to insert a row: > insert into test values(true) > > Resutl: SQL Studio reports an error message: > General error;-5004 POS(25) Missing constant. > > What have I done wrong? I can't find any related topic so I > suppose not many people have this problem.
I assume you executed the insert statement in sqlmode oracle. But in oracle there is no datatype boolean so true is no valid expression in this mode. So try it again in internal mode. Kind regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
