HELP! Trying to UPDATE temp table HELP!
Posted in 1992
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
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 614/292-3656 BITNET trotter.1@osu.edu !
!------------------------------------------------------------------------!