Results 1 to 4 of 4

Thread: .dbEditUpdateSQL

  1. #1
    Join Date
    Aug 2005
    Posts
    3

    .dbEditUpdateSQL

    Hello
    InTornado I use following
    .dbEditUpdateSQL = "UPDATE [Orders] SET [Orders].mawb = '[[mawb]]' WHERE [Orders].consol = '{{consol}}' "

    I get the response error
    (311 : 999) Error
    Records match the criteria (4)

    does the dbeditupdate above look OK?

    Bart

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    See this property ->

    Obj.dbEditRecordScope = "Single(Def) | Multiple"

    Default is that you can edit (1) single record. If you want to update all matching records then change this property to 'multiple'.


    Fk

  3. #3
    Join Date
    Aug 2005
    Posts
    3

    Thumbs up

    Thanks Frank

    Worked first time
    Bart

  4. #4
    Join Date
    Oct 2002
    Posts
    933
    Great.... keep going.. check out the new manual also

Posting Permissions

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