Sql string

Results 1 to 2 of 2

Thread: Sql string

  1. #1
    Join Date
    Dec 1969

    Default Sql string

    Hi!<BR><BR>I&#039;m trying to update a record (Access2000 database) via a form. One of the fields "Rank" is a text field and the other "QualTrngNQ" is a "yes/no" field. I think that Access actually stores -1 for Yes and 0 for No. My sql string is:strUpdate = "UPDATE StudDemo SET Rank=&#039;"& Rank &"&#039;, QualTrngNQ=&#039;"& QualTrngNQ &"&#039; WHERE DemoID = " & DemoID<BR>The query works when I take the Yes/no field out. Leading me to think it&#039;s the Yes/No field. Should the &#039;"& be different because the Yes/no is actually -1/0?<BR> <BR><BR>thanks<BR>SteveDi

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

    Default try taking them out

    i have not worked in access so not sure<BR><BR><BR>but try passing true and false to it (or even yes no)<BR><BR><BR>without the &#039;

Posting Permissions

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