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
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