Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
I don't see how this will work. Where is the particular record to update defined? webprddt6 is an as400 library. The drawmstrp is the table and dm_drawing_number is the key field of the record. I have a minimum of 950 records I need to loop through and change field data. One of my major problems is an inconsistency with how dm_drawing_number is named. In my associated table(the one I am scanning from) I have engineering part numbers: example 841523-401, 856235-1, 845787-201. I need to look into the as400 database and find the respective engineering drawing number for these parts. In some cases my engineering drawing number is a six charactor number with embedded sub numbers(our old way) Now we are creating mono drawings(one drawing for one part) That makes to drawing number ten charactors. As I loop through I need to check first for the ten charactor style, if not found the the six charactor style, when found change the data in a couple of fields.
I hope this makes sense.
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