Today's Smalltalk 4 You looks at how to use sequence numbers as part of your table description with Glorp; in the process of doing that, we modify our simple table description, drop the table from Oracle, and then add it back. Finally, we add new data and check that the sequence number was used as expected. If you have trouble viewing it here in the browser, you can also navigate directly to YouTube. To watch now, click on the image below:

If you have trouble viewing that directly, you can click here to download the video directly. If you need the video in a Windows Media format, then download that here.

You can also watch it on YouTube:

Today we'll make some changes to our simple example - adding a real primary key. That key will be a sequence number in the database, so we'll have to do the following:

Drop the old table

Modify the descriptor and mapping class in Smalltalk

Add the table back to the database

We'll then add some data to the table again to see whether our sequence generator works as expected. First, add an "id" variable to class Emp, and then make the following three changes to class EmpDescriptor: