Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    14

    Unanswered: Update SQL Problem

    I need to update a logical (boolean) field.

    Tried 'Update table
    set logicalfield = true
    where key = mykeyvalue'

    this fails with the error:

    <<<<<<<<<<<<<<<<<<<<<<<<
    [LNA][Pervasive][ODBC Engine Interface]Error in expression: True
    >>>>>>>>>>>>>>>>>>>>>>>>

    What is the syntax to accomplish this update?

    Thanks!

    Bill S.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    How is the "logicalfield" defined in the DDFs?
    You might try:
    Update table
    set logicalfield = 1
    where key = mykeyvalue
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2009
    Posts
    14
    i have tried this.

    I don't know how to view/edit the DDF's yet.

    Thanks, I will look into the DDF situation.

  4. #4
    Join Date
    Jan 2009
    Posts
    14
    The DDF was the issue.

    Thanks.

    Bill Slaughter

Posting Permissions

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