NetNews Usenet Archive 1992 #19/NN_1992_19.iso/spool/comp/database/informix/1883

Internet Message Format | 1992-09-04 | 1.8 KB

Path: sparky!uunet!ogicse!usenet.coe.montana.edu!caen!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!magnus.acs.ohio-state.edu!mtrotter
From: [e-mail] (Mark L Trotter)
Newsgroups: comp.databases.informix
Subject: HELP! Trying to UPDATE temp table HELP!
Summary: A nasty compile bug with updating temp tables
Keywords: update, 4gl
Message-ID: <[e-mail]>
Date: 4 Sep 92 18:42:19 GMT
Article-I.D.: magnus.1992Sep4.184219.11503
Sender: [e-mail]
Organization: The Ohio State University
Lines: 23
Nntp-Posting-Host: top.magnus.acs.ohio-state.edu


Hi fellow netters!
   I am trying to create a temporary table, insert some elements from
another table, then go thru the temporary table using a cursor and
do some updating of other elements.  All works except:
   1. I can't DEFINE a memory record LIKE the temporary table because
      it doesn't exist at compile time so I assume I must define the
      entire memory record via listing all of the elements, but if I do
      that then:
   2. I can't UPDATE the temporary table using
       UPDATE temptablename SET temptablename.* = memrecord.*
      because I get a compile error saying that memrecord was not
      defined using the RECORD LIKE phrase.

Is this a know bug and is there any workarounds?
By the way, I'm on 4GL version 4.0, OnLine engine and HPUX 7.0.
Thanks for any help!!!!
!------------------------------------------------------------------------!
! "In these uncertain times, one must think of others' viewpoints, and   !
! always remember that a crowded elevator smells different to a midget." !
!        Mark Trotter @ The Ohio State University Graduate School        !
!     voice 614/292-6031  FAX [phone]  BITNET [e-mail]     !
!------------------------------------------------------------------------!