Alpha Video Training
Results 1 to 2 of 2

Thread: List Control with detail view. Why does UPDATE command have multiple fields in WHERE clause ?

  1. #1
    Member
    Real Name
    Robert Gilbert
    Join Date
    Jan 2010
    Location
    Kingston, Jamaica
    Posts
    166

    Default List Control with detail view. Why does UPDATE command have multiple fields in WHERE clause ?

    I have a UX component with a List control that has a Detail View.

    I turned on Debug during an update because of a problem I am having and am seeing where the underlying UPDATE statement has multiple field
    in the WHERE clause instead of just using the primary key (which will never change).

    How do I force the system to only use the primary key in the WHERE clause of the UPDATE statement ?

    Please see attached screenshot.

    screenshot.png

    I would like the statement to be :

    UPDATE patient_images SET [visit_id] = :new_visit_id, [updated_user] = :new_updated_user, [updated_at] = :new_updated_at WHERE ([id] = :primaryKey_1)

  2. #2
    Member
    Real Name
    Robert Gilbert
    Join Date
    Jan 2010
    Location
    Kingston, Jamaica
    Posts
    166

    Default Re: List Control with detail view. Why does UPDATE command have multiple fields in WHERE clause ?

    OK I figured it out.
    Also just appreciating how a certain option works.

    What I did was to turn off "Check for write-conflicts" for each of the fields. Once this option is off, it does not include it in the WHERE clause checks.

Similar Threads

  1. File Update and Download using List and List Detail View
    By dantum in forum Mobile & Browser Applications
    Replies: 10
    Last Post: 09-01-2016, 10:49 PM
  2. List Control detail View Error mapping primary key fields
    By bob9145 in forum Mobile & Browser Applications
    Replies: 3
    Last Post: 06-16-2015, 12:03 AM
  3. Replies: 1
    Last Post: 05-27-2015, 12:02 AM
  4. Refreshing detail view of List Control
    By rvanderbes in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 10-23-2014, 01:38 PM
  5. Is anyone using the the detail view under with the list control?
    By MichaelCarroll in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 06-15-2014, 11:56 PM

Bookmarks

Posting Permissions

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