Announcement

Collapse
No announcement yet.

INSERT INTO

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • INSERT INTO

    Hi, I have to insert a record into a table, but some fields are not to be valued and Scriptcase reports this error:

    Error in entering
    ERROR: invalid input syntax for type boolean: ""
    INSERT INTO public.fabbricato (id_fabbricato, id_localita, id_stradario, civic, annoacquisizione, annomodifica, descrizionemodifica, id_usooriginale, id_usoattuale, supcoperta, volumelordo, id_tipologia, id_stvertint, id_stvertest, id_isolamento, id_storiz, id_pavimento, id_rivestimento, id_serint, id_serest, id_tipovetro, id_copertura, isoacuint, isoacuest, presenzariscaldamento, id_combustibile, id_potenzacaldaia, fontialternative, impiantoidrico, telephone, ISDN, disabiliporta, disabilipercorsiinterni, disabilipercorsiesterni, id_disabiliscala, valoreiniziale, datavaloreiniziale, valorestima, datavalorestima, id_complesso, bandalarga, description, ato, zto) VALUES (93, 0, 7001,'','', 'c','', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, '', 0, 0,'','','','','','','', 0, 0, nULL, 0, nULL, 143,'',' c ','',' ')
    In this case there are Boolean fields that I do not want to exploit.
    The Boolean field is isoacuint.
    Can anyone help me?
    thanks
    Beatrice

  • #2
    Re: INSERT INTO

    You can insert a 0 or '' for boolean fields. I believe null is not allowed.

    Regards,
    Scott.

    Comment


    • #3
      Re: INSERT INTO

      The''are not accepted, while the value 0 is accepted. But in this case, the field has the value false, while I wish they did not value.
      Thanks,
      Beatrice

      Comment


      • #4
        Re: INSERT INTO

        I think a boolean field cannot be null .. it must be true/false

        Best regards
        Uwe

        Comment

        Working...
        X