I've got a client who's main data table for their orders is over 2300 wide for record length.
Anybody seen any wider in their travels?
I have seen SQL Server tables with 20+ fields of varchar 4000. Total lack of discipline and perfect example of laziness that is infecting the software world's concept of "data." Needless to say, the shoddy approach of that application also showed through into the UI and other areas.
In terms of VFP tables, I have to say I've never come close to the 65k limit. And though I don't claim to be an expert at normalization, I just seem to never enjoy creating those 200 field tables that have stuff like month1, month2, month3, month4.... yada yada. That's probably because I have a different kind of laziness - once I design a system I NEVER want to go back and change code. If a software change is required for any other reason than a new requirement surfaced, it means I failed in my design.
-Charlie
On 11/2/2020 7:25 PM, MB Software Solutions, LLC wrote:
I've got a client who's main data table for their orders is over 2300 wide for record length.
Anybody seen any wider in their travels?
I hope you are the winner.
On Mon, Nov 2, 2020 at 6:25 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
I've got a client who's main data table for their orders is over 2300 wide for record length.
Anybody seen any wider in their travels?
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]
And this project is one of those passed through the years and isn't something easily refactored without worries you break something elsewhere unknown.
On 11/3/2020 1:41 PM, Stephen Russell wrote:
I hope you are the winner.
On Mon, Nov 2, 2020 at 6:25 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
I've got a client who's main data table for their orders is over 2300 wide for record length.
Anybody seen any wider in their travels?
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]
On Nov 4, 2020, at 14:22, MB Software Solutions, LLC mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
And this project is one of those passed through the years and isn't something easily refactored without worries you break something elsewhere unknown.
s/worries/guaranteeing
Fixed that for you.
-- Ed Leafe
-
Charlie -
Ed Leafe -
MB Software Solutions, LLC -
Stephen Russell