associative entities

Results 1 to 3 of 3

Thread: associative entities

  1. #1
    Join Date
    Dec 1969

    Default associative entities

    i have an associative entity, staffskills.<BR>PK:IpAddress<BR>PK:SubCategoryID<B R><BR>if im adding an entry to this table, how do i validate that this entry hasnt been entered before?<BR>thank you!<BR>m:)<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: associative entities

    run a query before the INSERT query that uses a WHERE statement containing the value of what your trying to add...<BR><BR>Check to see if any results are returned...<BR><BR>Essentially do a dup check query before inserting your record...

  3. #3
    Join Date
    Dec 1969

    Default FAQ#106 <EOP>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts