Iterate/loop through Column/Field names

Scriptcase 8 Discussion
#1

I have a history table which shows Updates on a specific table. It contains all the columns of the table. I am displaying the history table in a grid application. I want to Highlight the column values that have changed, the Database actions(Insert,Update,Delete) are sorted by date so all I have to do is compare the current row with the previous row where the ID is the same

I thought I could insert some code into the onRecord event to iterate through the columns to compare them to previous row and highlight them if they have changed.
Is there a way to Iterate through the field names using a SC macro or session variable or should I approach this using javascript ?

#2

use the sc_field_style({My_Field}, “Background-Color”, “Size”, “Color”, “Family”, “Weight”) macro in the onRecord event.

#3

Yes, that is what im using but I’m looking for a mechanism to loop through {My_Field} I dont want to hardcode every field as it adds maintenance overhead.

eg an array of {My_Field} is what I want

#4

interesting question, any answer?

#5

nope…