Update on a single line of code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Warren - 31 Jan 2005 18:17 GMT

I want to execute an update to SQL on a single line and I can't remeber how.
It seems that it was something like this:
Conn.execute "UPDATE table WHERE field = xxx
(fld1,fld2,fld3)value(val1,val2,val3)"
It's been a few years and my memory is not what it used to be.

Reply to this Message

Paul Clement - 31 Jan 2005 19:54 GMT

¤ I want to execute an update to SQL on a single line and I can't remeber how.
¤ It seems that it was something like this:
¤ Conn.execute "UPDATE table WHERE field = xxx
¤ (fld1,fld2,fld3)value(val1,val2,val3)"
¤ It's been a few years and my memory is not what it used to be.

UPDATE Table_3 SET Col1 = "testing", SET Col2="xxx", ... WHERE RecordID=1;

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Jim Warren - 31 Jan 2005 20:01 GMT

It just hit me, it was INSERT INTO that I was thinking about.
In the words of Emily Litella (Saturday Night Live) "Never mind"

> I want to execute an update to SQL on a single line and I can't remeber how.
> It seems that it was something like this:
> Conn.execute "UPDATE table WHERE field = xxx
> (fld1,fld2,fld3)value(val1,val2,val3)"
> It's been a few years and my memory is not what it used to be.

Reply to this Message

VB Forum / Database Access / January 2005

Update on a single line of code