Min/Max Compare Then Update

CementCarver

Registered User.
Local time
Today, 14:56
Joined
Sep 18, 2007
Messages
19
Hello All,

I have an interesting situation. I'm working with a large table that contains a shape_id, sequence_num, x_coordinate and y_coordinate. The shape_id holds a unique identifier for the polygon and the sequence_num is a number that either starts with zero or one.

This sequence_num may be between any range and the example .bmp file attached shows that this particular polygon starts at zero and goes to 6.

What I would like to design is some sort of command button which will populate an array and compare the min sequence_num and the max sequence_num and if the x_coordinate and y_coordinate for the min(sequence_num) is not the same value for the max(sequence_num)'s x_coordinate and y_coordinate then I would need the code to update the table but first add 1 to the max(sequence_num), add then insert a new record with the same shape_id, and populate that new sequence_num with the same x_coordinate and y_coordinate found in the min(sequence_num)

Please see attached .bmp file as a description of the table and record.

I would appreciate any comments anyone would have....Thx...CementCarver
 

Attachments

Users who are viewing this thread

Back
Top Bottom