Kbase P7615: Cannot insert a new row when using SQL-92 Sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/05/2011 |
|
Status: Verified
SYMPTOM(s):
Cannot insert a new row when using SQL-92 Sequence
Cannot insert new row
Error is returned when inserting a new row
Internal error -1214 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmSeqGetID called from seq_get_seq_id on for . Save log for Progress technical support.
FACT(s) (Environment):
Using SQL-92 Sequence
All Supported Operating Systems
Progress 9.1D
CAUSE:
Sequence name used is not correct
FIX:
Specify the correct name of the sequence in the INSERT Statement.
Example:
If the sequence is named "pub.myseq", to insert a new row with the next value of the sequence, the Statement should look like this:
insert into <tablename> values(pub.myseq.nextval);