Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows Server 2016
Someone else can pipe in and say if they know of a class that does this but my first reaction was that it would probably have to be fairly specific code depending on what you want to do.
One form that I have set up for a customer had to do with a search and replace for updating the domain name portion of email addresses. This happens in their industry (insurance) where there are a fair number of mergers going on on a regular basis. They wanted to change just the domain portion.
To make sure they did not mess up the data inadvertently, the form:
- has a field for the original domain name
- has a field for the new domain name
and this is where some safeguards were built in:
- the user has to press "search" first which shows a listing in a grid of all the matches found for the original domain name
- before they can proceed, they have to do a "test replace" which shows the addresses with the replacement as it would be
So I would build in some safeguards based upon the data they are updating. If the data is critical enough, you might even copy out the data that is being changed to a backup folder in some sort of data file - I do this when this customer sometimes asks me to get rid of data - I just copy it out as a free table with the primary key and the changed field - it gives me a backup if they happen to say "is there any way we can get that data back" - people change their minds! (in this case, it is mailing lists where they say to purge such and such).
Good luck. I will attach a screen shot of the tool this customer uses.
Albert
>Hi All,
>
>A customer has asked to have a 'Find and Replace' feature to replace data of various types in a table.
>Is there some code out there that I can just drop in?
>Thanks.
>
>Luke
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement