Good afternoon. I have a value in the salesperson field I want to delete,
an entry for "CO242". I cannot do this within QAD because the user CTRL-C'd
out when the system locked up. Can I simply say:

for each ls_mstr where ls_addr="co242": delete ls_addr.
end.

Thank you for any help you can provide


Jeff Crosby
jcrosby (AT) wallindustries (DOT) com

"Jeff Crosby" <jcrosby (AT) wallindustries (DOT) com> wrote in
news:vlplkps04l5b2b (AT) corp (DOT) supernews.com:

Yep..

Kevin

"Kevin" <Joe (AT) Joe (DOT) com> schreef in bericht
news:Xns93F0D626E4132JoeJoecom (AT) 195 (DOT) 8.68.207...
for each ls_mstr where ls_addr="co242": delete ls_mstr.
end.

Reggie

"Reggie Dinsbach" <info (AT) dinsbach (DOT) nl> wrote in news:3f5ddb62$0$28891
$1b62eedf (AT) news (DOT) euronet.nl:

Maybe I should read before I type.. :-))

in big scale applications like erp and mfg/pro
the tables are all tied together and effect one another
you can't just delete one without updating all the other

for example - it might be included in all kinds of summaries,
have more detailed records linked to him
or show-up in other records linked to him, somehow

ofcourse those are just very simplistic examples
in real-life the relationships are far more complex
point is there is no such thing as a stand alone table



role of thumb - use their maintenance programs to update the database
and cim's/batch jobs on them to write your own or for lengthy updates,
that's what cim's are for

don't even try to do all the changes to all the tables yourself
besides it been impossible a bug in the program
would really screw-up your database, don't go there



your database is corrupt! that is if your already deleted
the right thing to do would be to load your backup
which would mean wiping out a few days work

but you can cut corners recreate only the deleted records
and take the risk that it already caused some damage



i only told you what you can't do (which is important by itself)
but not how to unlock your database
try www.peg.com for question on mfg/pro, HTH