Been there, done that!
BTW, looks like we visit the same barber!
Maybe in another post you could share your views about the Pick database and its multi-value columns, which totally destroys the 3rd Normal form rule. I used Advanced Revelation, which featured an MV DB combined with a dialect of BASIC. The dictionary was separate from the data tables, and allowed easy modifications of table definitions. One of my clients used it on a DOS platform for 16 years, up until he retired and closed his business. I enjoyed using ARev, but its GUI stepchild, OpenInsight, was much slower and took a decade to make usable, but by that time I was teaching physics & math in college.
BTW, looks like we visit the same barber!
Maybe in another post you could share your views about the Pick database and its multi-value columns, which totally destroys the 3rd Normal form rule. I used Advanced Revelation, which featured an MV DB combined with a dialect of BASIC. The dictionary was separate from the data tables, and allowed easy modifications of table definitions. One of my clients used it on a DOS platform for 16 years, up until he retired and closed his business. I enjoyed using ARev, but its GUI stepchild, OpenInsight, was much slower and took a decade to make usable, but by that time I was teaching physics & math in college.
Comment