RE: Changing multiple records dynamically

2003-10-23 Thread Mumba Chucks
-----Original Message- > From: Mumba Chucks [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2003 3:11 PM > To: [EMAIL PROTECTED] > Subject: Changing multiple records dynamically > > > Hi, > > Is there any way to automatically update several > rows > as a r

Changing multiple records dynamically

2003-10-23 Thread Mumba Chucks
Hi, Is there any way to automatically update several rows as a result of a change to information being changed in another row in the same table? |--|---| | NAME | VALUE | |--|---| | ABCD | 10| | DEFG | 12| | HIJK | 11| |--|---| So if I changed DEFG to 11, how

SELECT Question

2003-10-20 Thread Mumba Chucks
Hi, I've been given a table to work with, and I'm not meant to change it: - | TABLE_NAME| TBL_IDX | KEYW_ID | - | PROPERTIES| 108 | 16 | - | PROPERTIES| 119 | 16