Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How can I refresh data in tables

Discussion in 'Information Technology' started by Angus Comber, Jul 28, 2006.

  1. Angus Comber

    Angus Comber
    Expand Collapse
    Guest

    Hello

    I have a module which does an INSERT INTO - ie adds some data to a table. I
    want to find out what an autonumber field is in the table so I do a:

    SELECT ClientID FROM Client WHERE xyz

    It doesn't find the ClientID - I think it is because if I look in the table
    I don't see the newly added row - I think I have to refresh to see newly
    added data. Might be wrong here.

    What do I need to do to get the autonumber field straight after doing an
    INSERT INTO?

    Angus
     
  2. Loading...


  3. Angus Comber

    Angus Comber
    Expand Collapse
    Guest

    Sorry - was a problem with my SQL. Ignore.

    Angus

    "Angus Comber" <nospam@gmail.com> wrote in message
    news:#hThqkzqGHA.4032@TK2MSFTNGP03.phx.gbl...
    > Hello
    >
    > I have a module which does an INSERT INTO - ie adds some data to a table.

    I
    > want to find out what an autonumber field is in the table so I do a:
    >
    > SELECT ClientID FROM Client WHERE xyz
    >
    > It doesn't find the ClientID - I think it is because if I look in the

    table
    > I don't see the newly added row - I think I have to refresh to see newly
    > added data. Might be wrong here.
    >
    > What do I need to do to get the autonumber field straight after doing an
    > INSERT INTO?
    >
    > Angus
    >
    >
     

Share This Page