Why are there limitations in DHPOS? Well, when you get right down to it, it comes to a few big things. First, memory: there are 640K available in DOS for programs AND Data. There are ways to increase this, using EMS, XMS, and a few other methods... however, adding such functionality would take a fairly large amount of time, probably several months, at least. Additionally, and almost as important, not all computers support these expanded memory methods.
What does this mean, exactly? Well, POS uses most of this space just to store itself... the data gets the leftovers. In particular, the indexing method used by POS to lookup stock table items takes 20K. Dale knows better than I what other parts use memory, but that is one of the biggest.
Can this be fixed? Does it need to? Well, here is my opinion. I work in a grocery store, with over 200,000 items in inventory... obviously well beyond what POS is capable of. I would like to see more stock items, and indeed, we WILL see more stock items (13,000, anyway), but an unlimited number poses some problems. I've worked on some routines that would work for stock lookups, but not for reports, which require sorting huge amounts of data. Personally, I have yet to come up with a way (short of a full featured data base system I.E. SQL) that handles all these issues. Using something like SQL totally bashes one of the best things about POS... it will run on hardware from your closet... stuff people would otherwise throw out, and it will run faster on it than a brand new POS package on a multiprocessor P4.
Well, those are just a few of my opinions. If someone happens to have some routines that can handle hundreds of thousands of items in both searching and sorting that would work in qb, I would love to see them
, but if not, I'll keep plugging along, and passing things on to Dale.
In the mean time, It continues to amaze me just what POS can do. If you told most programmers that this thing was written in qbasic, they quite simply wouldn't believe you. "You cant do that in qb.", you would hear. But guess what... Dale did it anyway.
Jonathan Simpson