You can do: Update mytable set myfield = "Modified" where rowid = 12 (only "where rowid=...." is accepted)
or select * from mytable where myid=12 into tmp1 noselection update tmp1 set myfield="Modified" close table tmp1 but not what you have suggested. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 7:31 AM Subject: MI-L Update table > Hi, > > Is the following possible? > > Update mytable set myfield = "Modified" where myid = 12 > > Andrew > > > Regards > > Andrew > > ------------------------------------------------ > The information in this e-mail together with any attachments is intended > only for the person or entity to which it is addressed and may contain confidential > and/or privileged material. Any form of review, disclosure, modification, > distribution and/or publication of this e-mail message is prohibited. If > you have received this message in error, you are asked to inform the sender > as quickly as possible and delete this message and any copies of this message > from your computer and/or your computer system network. > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 8316 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8319
