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