This is an updated question to my previous enquiry. I am going to say thanks to the really nice folks who answered my last question.
The basic issue is I have a database file that I have updated irregularly on two different systems. One is consistently the more rational system, but it has goofy id numbers because of the way it has been updates. The particular table I want to update will have two sets of numbers side by side. n^1, n^2. N1 is a number of 1 to 3 digits. N2 is three or four digits. I have other three digit or four digit sets in the database, so I only want to update the three or four digit number next to the very first number in the table, which can be one, two or three digits. I want to tell the machine to find the pair of numbers, eliminate the second set so that the database when I drop and then rebuild the table the second set will be set from the auto increment and will start at one, rather than at 1400. Is there a way to do this? Thanks again for your courtesy. -- You received this message because you are subscribed to the "BBEdit Talk" discussion group on Google Groups. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at <http://groups.google.com/group/bbedit?hl=en> If you have a feature request or would like to report a problem, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
