Re: Logical data design, Pick style


B Faux wrote:
Dawn;

Can't help myself sometimes... bits 'n pieces from earlier points in this
topic (if not actual thread) and hopefully valuable perspective.

--
Kevin Wrote: (concerning PostgreSQL)
<paste>
In a D3 system, someone wanted to replace all the existing codes for
"Merchandise Return Reasons", with different ones. When they did this,
they rendered all the historical returns unidentifiable, because they
contained the old codes.

Had D3 been capable of foreign key constraints, deleting the old codes
would have been prevented at the database level.
</paste>

This is an example of RM rules concerning read/write/delete control residing
in the DB instead of in the code. See the use of 'triggers' in more current
MV implementations (openQM) and you get EXACTLY this functionality without
loosing MV. BTW having some business rules in code and others in the DB is
alot of fun sometimes...it is possible to make conflicting requirements that
bring the whole show to a screeching halt (crash?)

Note to dawn: I think he is talking about a control code of some sort, not
actual data items in the data file, 'cause if the actual data items got
changed to match the new controls, there would be no problem (see below).
--

Dawn Wrote: (concerning changing a code in 'one place')
<paste>
I don't know of any MV databases where you can change a code and have it
ripple through the values in the database (sorry, off-topic).
</paste>

Many 'old farts' used the editor 'Prestore' command (verrrry carrrefully) to
do this trick. Blows people's minds when they see it. (example for the age
deprived - suitably witty for the gray-hairs)

I was so hoping that someone would say they did it in the editor. That
is how my developers did it too. I was appalled at first, having come
from a shop where it would have been considered a huge breach to use an
editor in the production environment for anything at all. Then to use
an editor on the data -- wow, incredible! I saw it with my own two
eyes and wondered what an edp auditor would have to say about that.
Since arriving in the MV world, I have not seen an edp auditor -- do
they still exist? (EDP, in case there are any youngsters in the
audience, is Electronic Data Processing.)

***WARNING***
Do not try this on a production system without verified BACKUP(S)!!!!!!

And don't let me know in advance if you plan to do this.

Let's take a trip to the Emerald City - um that is let us assume you want to
change the value of someval (attr<5>) from something to somethingelse in
filename.

<example>

:SELECT filename WITH someval = "something"<cr>

102,010,304,502 items selected!!!

::ED filename<cr>
top
001 first attr data

.P1 5[R/something/somethingelse/[FI[P1<cr>

.P1<cr>

***woosh*** (stuff-flashes-past-too-quick-to-see, you mumble "there's no
place like home" a few times and then Dorothy wakes up in bed... er you're
back at TCL)
:
</example>
<snip>
Now old guys gotta sleep zzzzzzzzzzzzzzzzz

I'm trying not to feel old. I went to sleep in my 40's and woke up
today in my 50's. The kids are out of the house (but sent wonderful
gifts), the dog is dead (a Bischon), I don't work in an office with
other people, and I don't recall having a birthday that I found so
difficult before. Since I'm working with you folks as much as anyone
right now, if anyone wants to send a poem or doggerel to my e-mail, it
would contribute to my day. My brother and cousin have sent some truly
awful (but fun) rhyming poems already, so it's off to a good start.
Cheers! --dawn (dwolt who-is-at tincat-group dot com)

.

Relevant Pages

  • Re: Adding components
    ... >> That's because they apparently don't really ALLOW a programmer to test ... I'm not implying they're dishonest or sell a bad product. ... easy-to-use third party treeview and editor. ... I didn't see an editor control (extended RTF, ...
    (alt.comp.lang.borland-delphi)
  • Re: Fadal TRM help
    ... >> Scott, ... >> Strip out the line numbers with the MC editor, ... >> Your not using the 104/D POS control are you ??? ... > They sent the tech out to do the upgrade, ...
    (alt.machines.cnc)
  • Re: Displaying code as html
    ... If you don't mind using a 3rd-party control Code Max ... Code Max has been used by several "syntax-highlighting" editors, ... you create a "fixed" html, ... code editor, much preferred by our friends over at AutoIt. ...
    (microsoft.public.scripting.vbscript)
  • Script edit server control
    ... Does anybody know where I can get my hands on a script editor server ... I have developed a web app that includes an "editor" (textarea control) in ... copy the new text back into the textarea and then save the file. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Script editor server control
    ... Does anybody know where I can get my hands on a script editor server ... I have developed a web app that includes an "editor" (textarea control) in ... copy the new text back into the textarea and then save the file. ...
    (microsoft.public.dotnet.framework.aspnet.buildingcontrols)