database connection

Discussion in 'AutoCAD' started by fischer, Oct 8, 2004.

  1. fischer

    fischer Guest

    hiya

    connected my vba code to a access database. i can transfer data from acad to
    access. but now i want to check if the primary key (one of the data i
    transfer form acad to access) is already exists on the database or not.

    how can i do this
    thnx.
     
    fischer, Oct 8, 2004
    #1
  2. fischer

    Jorge Jimenez Guest

    If you write the data using the Execute (SQL) command, there will be no
    need to check if the key already exists, the command will not write if it
    does, and only checking the connection errors will you know what error
    occurred.
    And of course, your key should be exclusive.
     
    Jorge Jimenez, Oct 9, 2004
    #2
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. mismateched "by order" port connection in Verilog

  2. Trouble with 3-terminal MOSFets and the bulk node connection

  3. Virtuoso/LVS hierarchical net connection problems

  4. Selecting & Deleting Objects by Net Connection?

  5. How to separate the connection of source and bulk

  6. Ubuntu - Cadence Connection

  7. 2005 and the database connection.

Loading...