Post reply

ggg

  • July 3, 2005 at 5:59 pm

    #89931

    Hi I am new and I need help to sort out my project. I am doing a sales project which involve Products Stocks and Invoices. The help I need is when a quantity of Product is sold its Stock level or quantity has to be reduce from the products or Stocks table but I don't have any idea how to go about it. So I would be grateful if anynoe could help me how I can reduce the quantities of the products when some is sold. Please do give me some Design. Pls for give me about the subject I am trying to change it but I don't have the chance. Thanks

  • July 3, 2005 at 9:49 pm

    #570565

    Joe would you please post the DDL for your tables

    Thanks

    Mike

    p.s. checking out this site is recommended (by me )

  • July 3, 2005 at 11:27 pm

    #570577

    Hi Mich what is DDL?

  • July 4, 2005 at 6:58 am

    #570637

    Hi Joe DDL is data definition language. It is the script that is used to create your tables. You can get a copy by  going to enterprise manager and right clicking the table you want. I would give you a little more information as to the exact way to do this but it looks like I crashed my entprise manager when I installed SQL 7 on my machine this weekend.

    If you are using QA to create your tables for testing purposes just cut and paste the create table and insert statements you are using.

    HTH

    Mike

    Now I get to reinstall SQL server what joy.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply