Kbase 37615: Cannot insert a new row when using SQL-92 Sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2001 |
|
Solution ID: P7615
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Cannot insert new row
Using SQL-92 Sequence
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.
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);