By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,595 Members | 3,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,595 IT Pros & Developers. It's quick & easy.

Version control

P: n/a
Dear All,

I am sorry if this message not suitable posted in this group.

I have a table

company id exhibition id version tel fax contact
person
1 1 1 999 9999
Mr. white
1 1 2 888 9999
Mr. white
2 1 2 123 456
Mr. Black
3 1 2 232 333
Mr. Yellow

Now, I need to write a function which specification as follow:
our client can check the latest five version of the table, and when they
click on one version, its content MUST be compared with its' previous
version so as to display what infomation the company changed.
For example, when client click on version 2, the result should like as
follow

company id exhibition id version tel fax contact
person
1 1 2 888 9999
Mr. Borrow
2 1 2 123 456
Mr. Black
3 1 2 232 333
Mr. Yellow

From above result, it indicated that company who with id 1 have updated
their information in version 2
and other two company is not exist in version 1, so it change to red in
color.

According to the above requirement, I only have one solution, retrieve the
selected version and its' previous version, and compare each fields in
selected version with its' previous version, if different, change it to red
in color, am I right?

I am appreciate you if you can provide some suggestion to me.
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.