SQL Question

Results 1 to 2 of 2

Thread: SQL Question

  1. #1
    Join Date
    Dec 1969

    Default SQL Question

    I am using the following SQL to delete records selected through check boxes;<BR><BR>"DELETE FROM tblOrganisation WHERE tblOrganisation.ORGANISATIONID IN (" & intOrganisationIDDelete & ")"<BR><BR>What is the simplest way of using this string of values (intOrganisationIDDelete) to replace them, in the database with one value (ie. the number 1). So that all the values selected from intOrganisationIDDelete now have the value 1 in the ORGANISATIONID field. I am using Access

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: SQL Question

    If you are deleting them, what will be there to replace???<BR><BR>but this is what you will need<BR><BR>update tblOrganisation set ORGANISATIONID =1 where ORGANISATIONID IN (" & intOrganisationIDDelete & ")"<BR>

Posting Permissions

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