Re: Comparing two records
From: Rostam <rostamseddiq_at_web.de>
Date: 30 Aug 2001 05:25:15 -0700
Message-ID: <f3e48397.0108300425.51f86452_at_posting.google.com>
Date: 30 Aug 2001 05:25:15 -0700
Message-ID: <f3e48397.0108300425.51f86452_at_posting.google.com>
bytor99999_at_yahoo.com (Mark Spritzler) wrote in message news:<6940c3ac.0108290821.56847f11_at_posting.google.com>... <snip>
> I have an IF statement saying:
>
> IF v_last_record != v_current_record THEN ...
>
> However I get an error. Can you compare two variables of ROWTYPE like
> this, or do you have to type out each field with ANDs in between.
>
> BTW there are 75 fields in the record. I cannot use a real table
> because the real table has over 200 fields.
>
> Thanks
> Mark
Mark,
you can't compare two variables of rowtype directly, you have to specify each field by dot-notation, e.g. emp.empno, and compare these.
Rostam Received on Thu Aug 30 2001 - 14:25:15 CEST