Announcement

Collapse
No announcement yet.

[SOLVED] Problem with fields type numeric and postgres 9.3

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

  • [SOLVED] Problem with fields type numeric and postgres 9.3

    Scv8 not insert records on form editable view app in table with numeric fields type.
    Infinite loop, no errors message o script error to try insert new record,

    TEST:

    1. create o modify a table with a field type numeric....

    Example:
    --------

    CREATE TABLE "TEST"
    (
    "ID" smallserial NOT NULL,
    "IMPORTE" numeric(7,2),
    CONSTRAINT "TEST_pkey" PRIMARY KEY ("ID")
    )
    2. crearte form app grid editable view.
    3. try insert record.
    Last edited by daguard; 03-25-2015, 02:18 PM.

  • #2
    i do not have the problem in postgres 9.3, could you explain a litte bit more ? Did you create the table via SC or pgAdmin ? Seems that SC has no Primary key, so you should check the fields !

    Comment


    • #3
      The table create with pgAdmin.

      SOLVED:
      EDIT CONNECTION CONFIG TAG ADVANCED AND CHANGE COMMA (",") TO DECIMAL POINT (.) FOR client_encoding: UTF8 - Unicode,8 bit

      Comment

      Working...
      X