Tek-Tips Forums is an intelligent work forum community for Information Technology. VBA Visual Basic for Applications (Microsoft). Visual FoxPro.
Active9 years, 2 months ago
I'm looking at upgrading a POS (Point Of Sale) project which is currently built in FoxPro to .net. The planned architecture is quite complex and there is plenty of rationale behind the new technologies chosen. Some of the requirements include the ability to have both desktop and web front end (where web front end has limited functionality), syncing data with an external website and the ability for multiple clients to run off of 1 server. My current model of choice is an MVP pattern with Sql Server (probably Express) as the DB, and a WCF service layer between the presentation and services in order to allow for remote UIs.
My concern is that during my research I have noticed that there seems to be a common theme amongst touch screen POS systems to build them in FoxPro.
Apologies for the slightly subjective question however I am keen to find out if there is any particular reason for this? Does FoxPro have any particular out of the box functionality that lends itself to this type of system? I have not used FoxPro and so before finalising my choice of technologies for this project would like to make sure I am not missing a trick by ruling it out completely.
The Third Edition of the Handbook of Developmental Psychopathology is a discipline-defining, forward-looking resource for researchers, clinicians, scientist-practitioners, and graduate students in such fields as developmental psychology, psychiatry, social work, child. Download handbook of psychopathology in intellectual disability in pdf or read handbook of psychopathology in intellectual disability in pdf online books in PDF, EPUB and Mobi Format. Click Download or Read Online button to get handbook of psychopathology in intellectual disability in pdf book now. This site is like a library, Use search box in the widget to get ebook that you want. Handbook of Psychodynamic Approaches to Psychopathology and millions of other books are available for Amazon Kindle. Learn more Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. The purpose of this handbook, originally published in 1984, was to provide a compreh- sive review of current clinical descriptions, research, and theories of psychopathology. Descriptive psychopathol. Note: If you're looking for a free download links of Handbook of Psychopathology in Intellectual Disability (Autism and Child Psychopathology Series) Pdf, epub, docx and torrent then this site is not for you. Ebookphp.com only do ebook promotions online and we does not distribute any free download. Download handbook of experimental pharmacology.
Jonas
48.2k8787 gold badges246246 silver badges323323 bronze badges
MacrosMacros
6,25122 gold badges2929 silver badges5858 bronze badges
closed as not constructive by WillNov 11 '11 at 13:12
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
6 Answers
Licencing - SQLserver didn't run well on client OSes and was expensive.
Foxpro was cheap and easy.
![]()
If all you are doing is retrieving price values from one table and updating sales in another, then SQL is rather overkill.
Martin BeckettMartin Beckett
82.1k2020 gold badges165165 silver badges243243 bronze badges
sectreansectrean
8,82966 gold badges2323 silver badges3131 bronze badges
foxpro was an inexpensive and fast database. It was probably chosen because it was a good match for their requirements at the time it was designed.
![]()
11.1k33 gold badges3131 silver badges6060 bronze badges
Many POS systems have a standalone capability so that the store can continue to trade even if the connection to the in-store server(s) is down.
Basic Cash Code Pos Register Software Visual Foxpro Forum Download
Typically this means a local database for price lookup etc, and local storage of transaction data until the server connection comes back up again.
The hardware and licensing costs need to be as low as possible.
Hence FoxPro was a good choice a few years ago, but a properly architected .NET application would be an excellent choice today.
JoeJoe
104k2424 gold badges158158 silver badges290290 bronze badges
Many PoS systems date back to before SQL databases became popular on desktop machines so very many still use FoxPro or other xBase-style database. As PoS systems are generally single-user and single-tasking, there was very often no compelling reason to upgrade to a fully-fledged SQL database engine.
Ken KeenanKen Keenan
8,70555 gold badges2626 silver badges4545 bronze badges
FoxPro had a few advantages at that time. I can remember that for many many years all the new concurrent DBs laked at least in on place, so we choose FoxPro over and over again for now POS solutions:
There are still an incredible huge number of FoxPro legacy applications (especially in small and medium companies), so this is not just a POS issue.
![]() Basic Cash Code Pos Register Software Visual Foxpro Forum
A. IonescuA. Ionescu
Basic Cash Code Pos Register Software Visual Foxpro ForumsNot the answer you're looking for? Browse other questions tagged .netfoxpropoint-of-sale or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |