Announcement

Collapse
No announcement yet.

Session variable not expanded on sequence name

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

  • Session variable not expanded on sequence name

    I use several tables all with same structure, and all with a SEQUENCE (Oracle) as primary ID key.

    I created a form to edit data rows, since I use dynamic table name [tabname], I used also a dynamic sequence name [seqname] in the filed "sequence name" next to ID field.

    When I try to insert a new row, I get SQL Error, since the sql generated is INSERT INTO realtabname ( IDKey, Field1) VALUES ( [seqmame].NEXTVAL , 'text')

    I use scriptase 8.00.0047 (not yet upgraded at 8.1).

    Is there anything I can do or have to be modified the scriptcase code ?

    thanks
Working...
X