Announcement

Collapse
No announcement yet.

[SOLVED]Invalid characters when update any record with date fields

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

  • [SOLVED]Invalid characters when update any record with date fields

    Now when I try to update any row, I receive the message error "Date: with invalid characters"

    onValidate I add a sc_alert with these field, and display "2012-08-21 00:00:00" all is ok, but when sc save the row the error is generated

    I look for these field and all is ok in the form, in the table, in the regional configuration, etc.

    What is the problem ???

    Aquiles

  • #2
    Re: Invalid characters when update any record with date fields

    if you update a date field, then the value pass to that field should be "2012-08-21" and not "2012-08-21 00:00:00"

    Comment


    • #3
      Re: Invalid characters when update any record with date fields

      Hi leatheric,

      I don't update the table,

      I'am simply doing "click" on the "Update" button on a simple record form app.

      when I "save" the record do not have problems (I write 2012-08-21 in the date field)

      I call these record again and without change any field, simple click on "update" button and the error is displayed (in the sc_alert at OnLoad and Onvalidate the field have now 2012-08-21 00:00:00

      The error occurs in OnValidate event, NEVER arrive to "save" the data.

      In Debug mode I obtain this error

      Undefined offset: 6 | Script: C:Program FilesNetMakev6wwwrootscriptcasedevelclasspage
      mPageFld.class.php linha: 10720

      I have installed sc 6.0.031 (the last update and the problems start with these update)

      Aquiles

      Comment


      • #4
        Re: Invalid characters when update any record with date fields

        Hi Aquiles,

        I am also using the lastest update of SC. It is hard for me to visualize where the problem is.
        If you got an error occur in OnValidate even, then you need to solve that error, otherwise, the data will not be saved.

        Maybe you can give more details on your form application. What codes have you placed in your OnValidate event?

        Open up the nmPageFld.class.php and go to line 10720 and see which statement or field name it is referring that might be causing the error. Sometime it could be due to missing statements or symbols ";" , "[]" "{}" etc.

        You can also put echo var_dump(name) at different lines in your OnValidate event to find out what happening for further debugging of your application.

        Comment


        • #5
          Re: Invalid characters when update any record with date fields

          Hello Aquiles,

          Please make sure that the internal format of the field is the same as your DB requires to save records (on the field configuration). Which RDBMS are you working with?

          edit: I re-read your message, and I saw that you checked the internal format.

          edit2: Is this error happening to a specific application?

          regards,
          Bernhard Bernsmann

          Comment

          Working...
          X