Keep "temporary" tables after BW query execution

2007-08-27 Thread Döhr , Markus ICC-H
Hi all, We have a problem with a certain statement in a BI 7.0 system that uses temporary tables and thus we can't get an execution plan of the statement. I vaguely remember, that there is a parameter to set, so that those tables are kept even after execution and can be deleted with a report if

RE: INSERT .. UPDATE DUPLICATES - no trigger is fired

2007-08-27 Thread Anhaus, Thomas
Hi Dusan, thank you for mailing this bug. We will fix it as soon as possible. As a workaround you could insert via the , i.e. INSERT TB SELECT 1, 'Text (updated)' FROM DUAL UPDATE DUPLICATES After that you should have 2 rows in your LOG table. Best Regards, Thomas --- Thomas Anhaus MaxDB&li

INSERT .. UPDATE DUPLICATES - no trigger is fired

2007-08-27 Thread Dusan Kolesar
Hello, I'm using MaxDb 7.6.00.37 on Linux OS (CentOS). when I do INSET statement wiht UPDATE DUPLICATES database engine works incorrectly. Only when INSERT is performed trigger is fired. On UPDATE none triger is fired. Here is an example: CREATE TABLE "ADMIN"."TB" ( "ID" Integer DEFAULT SERI

RE: Problem building sources

2007-08-27 Thread Dittmar, Daniel
> 3) later i have this errors (that i dont know how to fix or workaround): > > "Possible previous pascal syntax error!" in many files and because this > i cant compile clientruntime.lib: Locate %TOOL%\lib\pgenc.exe in Windows Explorer and set the compatibility to "Windows 2000" (Properties/Comp