db seq/row ident?

Classic Servoy
1

OK, I’ve created my first Table against an Oracle DB from within Servoy.

I have the Servoy ID, and I made my own, which I set as a Row_ident, and to use a db seq. Servoy created the table and the Oracle sequence object.

However, when I put a new record in, Servoy is no getting the data from the Sequence. So I can not save the record.

What do I need to do to make this work? ARe there options for assigning the Sequence After the “save/commit” or on Record creation?

Thanks,
Lee Snover

2

Go to Define Dataproviders.
Select the table and select the column.
Now you can press the Properties button at the bottom of the window.
In this Column info dialog you can set the sequence type and also the sequence name.
Check if the sequence name is correct.

I know that Servoy uses seq_* for PostgreSQL but should use *_seq.
Maybe it has the same issue with Oracle.

Hope this helps.

3

ROCLASI:
Go to Define Dataproviders.
Select the table and select the column.
Now you can press the Properties button at the bottom of the window.
In this Column info dialog you can set the sequence type and also the sequence name.
Check if the sequence name is correct.

I know that Servoy uses seq_* for PostgreSQL but should use *_seq.
Maybe it has the same issue with Oracle.

Hope this helps.

Thanks, I got it. For some reason, I could swear I saw the sequence table that Servor created, but I was mistaken. The name Servoy attempted to create was too long, and so Oracle did not make it. I made one manually, and set the value in the Properties and now it’s working fine.

It’s always the stupid omissions that get you.

Thanks!
Lee Snover