At 10:15 2017-04-13, Ken Dibble <krdibble@stny.rr.com> wrote:

>>>Unfortunately, that would require modifications to the database,

>>>which I try to avoid due to the downtime they require.

>>

>> Why would that be an issue of consequence?

>>

>> You add some columns to a table. The rest of the software

>> can ignore them. (Unless you use select * or other black arts,

>> said rest might never see the new columns.)

>

>Yeah, there are black arts involved. My framework has some generic

>code that expects to be able to process every field in certain types

>of tables. If there is not corresponding code for each field in

>certain subclasses, errors are thrown. Probably a poor design choice

>in retrospect, but the choice was made in 2004 and rectifying it

>would require a huge amount of work.

Oh, my! (Alternative pronunciation: "You poor bastard!")

Can you modify the framework? One kludge would be for it to

ignore certain columns, say those starting with a certain prefix.

I have a couple of anvils around my neck, too. They prevent my

system from easily being multi-user. One was a reasonable trade-off

at the time, but the downside continues to bite. The other was an

argument I lost, because my boss does not understand relational databases.

[snip]

>No, I don't have a loader program. I would have to introduce

>internet download capabilities in order to provide that, and that's

>a headache I don't need.

Loader programs are not difficult to set up on a local

network. Still not an option?

[snip]

Sincerely,

Gene Wirchenko

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/1695b548d562df10acc50d112c80b392@mtlp000087

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.