Updating rows.
"Damien Corbishley" <[email protected]> Thu, 25 Mar 2004 15:40:04 +0000
| Newsgroups | gmane.comp.db.village.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --===============0615657610== Content-Type: multipart/alternative; boundary="=_D7F6F860.8CED81B7" This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_D7F6F860.8CED81B7 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, there doesn't seem to have been much activity on this list for a while. bu= t I thought I'd still send it. My question is, is there a way to update rows in a database without retrie= ving each row beforehand? The examples I have seen all seem to retrieve the= m first ( calling the TableDataSet..where method with the appropriate Stri= ng where clause ) and then for each row returned, updating that row. I would like to just perform a UPDATE <table_name> set <col>=3D<value> ...= . WHERE <col>=3D<value>. I have managed to construct the statement bar the = WHERE clause, is there any way to set the WHERE clause for an update / dele= te statement ? or is this the reason a select is performed before hand? Thanks in advance. Damien=20 ********************************************************************** This e-mail and any files transmitted are intended for the addressee only -= it is private and confidential. If you have received this mail in error pl= ease notify the sender and immediately delete the e-mail. The registered of= fice of Intervoice Ltd is 50, Park Road, Gatley, Cheshire, SK8 4HZ, UK. All= rights reserved (c) 2004 Intervoice Ltd This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** --=_D7F6F860.8CED81B7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px"> <DIV><FONT size=3D1>Hi,</FONT></DIV> <DIV><FONT size=3D1> there doesn't seem to have been much activity on = this=20 list for a while. but I thought I'd still send it.</FONT></DIV> <DIV><FONT size=3D1></FONT> </DIV> <DIV><FONT size=3D1> My question is, is there a way to update rows in = a=20 database without retrieving each row beforehand? The examples I have seen a= ll=20 seem to retrieve them first ( calling the TableDataSet..where me= thod=20 with the appropriate String where clause ) and then for each row returned,= updating that row.</FONT></DIV> <DIV><FONT size=3D1></FONT> </DIV> <DIV><FONT size=3D1> I would like to just perform a UPDATE <table_n= ame>=20 set <col>=3D<value> .... WHERE <col>=3D<value>. I h= ave=20 managed to construct the statement bar the WHERE clause, is there any = way=20 to set the WHERE clause for an update / delete statement ? or is this the= reason a select is performed before hand?</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D1>Thanks in advance.</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D1>Damien</FONT> </DIV> <DIV><FONT size=3D1></FONT> </DIV> <DIV><FONT size=3D1></FONT> </DIV> <DIV><FONT size=3D1></FONT> </DIV><FONT SIZE=3D3><BR> <BR> **********************************************************************<BR> This e-mail and any files transmitted are intended for the addressee only -= it is private and confidential. If you have received this mail in error pl= ease notify the sender and immediately delete the e-mail. The registered of= fice of Intervoice Ltd is 50, Park Road, Gatley, Cheshire, SK8 4HZ, UK. All= rights reserved (c) 2004 Intervoice Ltd<BR> <BR> This footnote also confirms that this email message has been swept by<BR> MIMEsweeper for the presence of computer viruses.<BR> www.mimesweeper.com<BR> **********************************************************************<BR> </FONT> </BODY></HTML> --=_D7F6F860.8CED81B7-- --===============0615657610== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Village-dev mailing list [email protected] http://share.whichever.com/mailman/listinfo/village-dev --===============0615657610==--