Antw: AW: temp table in trigger

Hi Elke, I receive the message during creation of the trigger. The table does not exist in the moment of creation. The original code I want to use in the trigger is TRY DELETE FROM TEMP.ATZ_VIEW; CATCH CREATE TABLE TEMP.ATZ_VIEW (...); Procedures work perfect with code like this,

RE: Problem with variable returned from dbproc

Hello Albert Unfortunately the example was not complete: One code line is added (// <) /* no error checking! */ sprintf( stmtStr, "{ CALL test_proc (?,?,?) }" ); retcode = SQLPrepare( hstmt, stmtStr, SQL_NTS ); retcode = SQLBindParameter( hstmt, 1, SQL_PARAM_INPUT,

RE: Problem with variable returned from dbproc

Hello Albert > -Original Message- > From: Beermann, Albert [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 16. November 2005 09:12 > To: maxdb@lists.mysql.com > Subject: Problem with variable returned from dbproc > > Hello Everybody > > I work with odbc and a maxdb 7.5 database > [details

AW: temp table in trigger

Elke Schmidtke wrote: > > Hi, > I try to create a temp table in a trigger: > CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB > AFTER INSERT, UPDATE EXECUTE ( > CREATE TABLE TEMP.ATZ_VIEW ( > BEGINN DATE, > ENDE DATE, > BESETZTE_STD FIXED(5,2), > FREIE_STD FIXED(5,2), >

temp table in trigger

Hi, I try to create a temp table in a trigger: CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB AFTER INSERT, UPDATE EXECUTE ( CREATE TABLE TEMP.ATZ_VIEW ( BEGINN DATE, ENDE DATE, BESETZTE_STD FIXED(5,2), FREIE_STD FIXED(5,2), MODELL CHAR(2)); ) But get the messag

Problem with variable returned from dbproc

Hello Everybody I work with odbc and a maxdb 7.5 database I have a table where i hold the last id for all my tables suchbegriff char(20) = tablename wert fixed(10,0) = last id ... ... When inserting a new record into table customers i first get a new recordid *autonum l_suchbefriff = "cu