Need to use table without primary key - possible ?

Classic Servoy
1

OK… I have read all of the posts I can find on this subject and so far, no luck.

I am building some extensions to a commercial product we already own. My extensions allow users to modify records created elsewhere by users running the win32 font end application.

We have MS SQL 2000 on the backend, latest servoy and a win32 app on the front.

I have a table, called transactionlines, which contains detail about each transaction, including a transactionID, which is not unique. Multiple transactionline records could have the same ID, because multiple steps may be needed to complete a transaction. There is no primary key in this table.

I also have a table, called transactionsmain, which contains a unique primary key - the column containing the transactionID field. This table consists of only four columns, and exists mainly to record the unique transaction ID.

The users occasionally make a mistake in inputting transactions, which must later be fixed by reassigning the owner of the transaction. This cannot occur through the win32 front end. I am trying to do it with servoy.
In order to do this, we must open and modify rows in the transactionlines table.

Because this table does not have a primary key, I cannot access it servoy. Yet I cannot make my own key column, because only servoy would increment the key correctly, since the win32 front end doesn’t use keys in this table and I have no way to change that.

Am I screwed ?

Any assistance appreciated.

-L

2

I would make a primary key column that is maintained by the database itself.
This way any frontend (or stored procedures) will create records with a proper PK.

Servoy can handle db managed PK’s

Hope this helps.

3

lzar:
I have a table, called transactionlines, which contains detail about each transaction, including a transactionID, which is not unique. Multiple transactionline records could have the same ID, because multiple steps may be needed to complete a transaction. There is no primary key in this table.

…

Because this table does not have a primary key, I cannot access it servoy. Yet I cannot make my own key column, because only servoy would increment the key correctly, since the win32 front end doesn’t use keys in this table and I have no way to change that.

As long there is a combination of columns on a table which are uniquely identifing a row, you can set the pk on those column to “row_ident” now servoy will work on that table.
When records has to be created and the seq is handled by the database set the sequence for the pk columns to to correct type (for sqlserver this is likely db_identity type)