Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
P

Patrick Harris

@Patrick Harris
About
Posts
11
Topics
0
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • With thanks to Chris - frustrated by the Windows 8 "Start menu"?
    P Patrick Harris

    Thanks. Just installed it. Love it.

    Free Tools php html com question

  • Coding outside of work.
    P Patrick Harris

    NDA deals with property rights as does IP. Both belong to the new owers of any / all property belonging to the old company unless stated in the filings as null and void. Good luck, I hope you the best in your endevours.

    The Lounge help career

  • Coding outside of work.
    P Patrick Harris

    After bankruptcy, all assets are levied and sold. Intellectual property is an asset and will be classified as such. You will still be held accountable to the NDA. It is exactly the same as if the company were sold. End of discussion... do not violate the NDA.

    The Lounge help career

  • Why JSON Won... And Is Good As It Is
    P Patrick Harris

    Humor was lost when I found out you didn't put in a begin tag for Just kidding...

    The Insider News html com sysadmin xml json

  • Is desktop programming still providing employment?
    P Patrick Harris

    Fake it till you make and get a job doing web development... you'll never look back. I was a C++ developer for 20 years and now I develop C# ASP.NET applications and little pop desktop apps in C# here and there. But my drug of choice now is web development.

    The Lounge c++ question wpf career

  • how to use Barcode in POS and Inventory system (Design wise)?
    P Patrick Harris

    Very good point, and you are correct. I've programmed POS systems for years. We used what we called an "alias" table for this. Ideally, you will store a system generated unique ID for your product in an items or products table. Then you will supply both a module and an import function to maintain your alias table for storing keyed values associated with your products. ie: CREATE TABLE ALIASES( ID INTEGER IDENTITY(1,1) NOT NULL, ALIAS NVARCHAR(50) NOT NULL, XREF_ID INTEGER NOT NULL, ALIAS_TYPE INTEGER NOT NULL, DESCRIPTION NVARCHAR(100)) Note I used "XREF_ID" rather than a PRODUCT_ID. Keep in mind this table can be used for more than products. For instance, you may want to store aliases for customers, or vendors, or any other things people will look up stuff with. This is where the ALIAS_TYPE comes into play. These types can be maintained by a maintenance module associated with an ALIAS_TYPES table. This allows for dynamic growth of the system and modularization of your cross references. I used an IDENTITY field for simplicity. But as Roger noted, it is probably better to use a GUID or some other form of unique value (i.e. STORE_NO + '-' + IDENTITY). Getting back to the "Barcode" topic... you can store your Barcodes / UPC Codes / Model IDs / whatever in this ALIASES table and give them an appropriate type for searching on.

    Design and Architecture design tutorial question

  • Agile Planner
    P Patrick Harris

    Thank you.

    Free Tools business com

  • Agile Planner
    P Patrick Harris

    Any plans for this to be available for VS2010+ I tried to install it and it's for VS2008 only.

    Free Tools business com

  • Straight from the horse's mouth
    P Patrick Harris

    5 stars... that made me laugh.

    The Weird and The Wonderful tutorial question career

  • Hosted Source Control
    P Patrick Harris

    http://offers.assembla.com/free-subversion-hosting/[^]

    Free Tools question

  • Looking for version control software
    P Patrick Harris

    I'm in the same boat and I use this:http://tortoisesvn.tigris.org/[^] It is absolutely the best for what you're looking for. Just be careful not to put big files into it because you cannot remove them from the repository (unless you use svnobliterate).

    Free Tools collaboration question announcement
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups