Yes/No field in database

Results 1 to 2 of 2

Thread: Yes/No field in database

  1. #1
    S. R. Oddsson Guest

    Default Yes/No field in database

    I have a problem that really shouldn&#039t be. I have a Yes/No (true/false that is) field in a table. My recordset is called rsDC. I´m adding a record with rsDC.addNew (VBScript). When I reach the True/false field and execute the script I get an error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<BR><BR>Why is this, is the field not really a True/False field?<BR><BR>If anyone can help me with this, I&#039d really appreciate it.<BR><BR>Thanks,<BR><BR>S. R. Oddsson<BR> <BR>

  2. #2
    Sathiya Guest

    Default RE: Yes/No field in database

    in the database it is stored as yes/No or 1/0 if it is 1/0 the you whould enter 1 and 0 only. i think.

Posting Permissions

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