Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Modify records

Quote Reply
Modify records
I use dbmansql to organize the data of a shopping-card.

There are 4 tables. I table contains the items of the orders.

If someone ordered three items, there are 3 records in the orders table, identified by invoice-number.

Now I wanted to modify a record of such an order. When I search for the invoice-number I get the 3 records to choose which I want to modify.

I selected one record, made the changings, then I noticed that after that all 3 records was changed to the same values.

Any idea?

Michael

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] Modify records In reply to
Who can help me?

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] Modify records In reply to
Hi Michael, I had started replying to your post sometime earlier, don't recall what came up to cause me to not follow through.

You've indicated:

Quote:


Are you using the invoice number as a "primary key" for this table? If you're using the invice number as a primary key then yes, when you make changes to a record witht hat key, you'll end up changing all the records with that key.

~ Karen
Quote Reply
Re: [Karen] Modify records In reply to
Karen,

the settings is "regular" and I tried it again, when I modify one record, other records with the same invoice number will also modified with the values of the changes record.

Michael

--
Michael Skaide

http://www.cycle24.de