Hi Eric

I do not think PL/SQL has the same array funtions as VFP does. In PL/SQL You would most likely compare two tables using the UNION MINUS SQL construct, or create a CURSOR FOR loop to compare the two physical tables.

Anyway, should discussion of Oracle PL/SQL constructs take place in a VFP forum?

TPL




>I am working with Viual FoxPro as a frontend Oracle7 Workgroup Server on NT4 as a backend.
>
>I an creating a trigger (in Oracle) which will compare new value with old value for each field in the table and then record them in the log table if they differ. Here is my problems:
>
>1. I couldn't find a function to load all fields information into the
>array in PL/SQL (like AFIELDS() in VFP) so I could scan through
>that array and compare old and new field values.
>
>2. The syntax for new & old values in PL/SQL is - new.Employer_Name and
>old:Employer_Name where Employer_Name is name of the field.
>
>How I could compare values for each field without hardcoding field name, like:
>
>var1 := 'Employer_Name';
>and then use var1 in :old and :new constructions.
>
>Thanks in advance.