Microsoft Visual Basic: is there an "update-select statement"?

i want to update a field in a certain table...

here's my code:
Set Rs = con.Execute("select * from t_taxrate")
Do While Rs.EOF <> True
con.Execute "update A13029t set nature = '" & Rs!nature & "' where atc_code = '" & Rs!atc_code & "'"
Rs.MoveNext
Loop

i want to lessen the number of lines in the program... "do while loop" may take some time... is there an "update-select statement"?
if there is, what's its syntax?

thanks in advance...

Keywords & Tags: update-select, statement, microsoft, visual basic, vb

URL: http://www.programmerbase.com/visual-basic/275009/

«« Prev - Next »» 2 helpful answers below.

visit this link (http://www.techonthenet.com/sql/update.php)

noielen | Mon, 03 Dec 2007 17:57:00 GMT |

visit this link (http://www.techonthenet.com/sql/update.php)

eyh thanks! Got it... =)

jeanette_db | Mon, 03 Dec 2007 17:58:00 GMT |

Microsoft Visual Basic Related Links

Microsoft Visual Basic Hot Answers

is there alternative of saving ?
Hi , I must save that values and when I need to use these according to its dates: Date1 Value1 value2 value3 value4 date2...
Is there Agents tutorial?
Hi all,does anyone know whether there is a tutorial about agents?Thanks...
Is there a..?
Is there a...Public Sub Form1_Resize()Sub? If so, how would I make the controls resize as the user resizes? (Textboxes, Labels, etc.)If that sub is non-existant, how would I resize the controls as needed? (When the user maximizes, resizes by dragging, etcetera.)Thanks in advance. :)...
Is there a workaround for not being able to show modeless forms from a DLL?
Is there a workaround for not being able to show modeless forms from a DLL?Actually I'm creating a control with a drop down form in an ActiveX control,and it doesn't work properly. Basically, the the DeActivate event doesn'tfire, and closing the parent form with the dropdown showing...
is there a window_paint event?
I'm using c#...the form has a paint event, but I'm wondering if the form window itself has a separate paint event. I'm drawing some stuff over the entire window (ie, over all teh controls, and the title bar)...if I put the redraw code in the form's paint event, things dont ge...

Microsoft Visual Basic New questions

ZZ 9 Plural Z Alpha
I'm sure you have all heard of the sad demise of Mr Douglas Adams, earlier this week, of a heart attack at age 49.He was a source of inspiration to me in particular, having grown up repeatedly listening to the Hitch Hiker's Guide To The Galaxy, and reading all his books.He will be miss...
ZOrdering Windows
OK, I've made my own gaming engine with it's own pseudo-windows and what not. When it comes to render the windows onto the device context it becomes tricky if I want one window to appear in front or behind another window. I thought about ZOrdering but when a window is created what ZO...
Z-Order...??
Can someone explain what exactly Z-Order is...? And what exactly is it used for...?Cheers......
Zorder Question
Hi Guys,Just a quick and hopefully simple question, I'm working on an application that needs to always be at the very bottom of the zorder, i know how to send my app to the top but I need to know how to send it to the very bottom.Thanks....
Zorder of a label control
I am creating an activex control in which I have a 3rd party image control and a label control. I want the label control to be on top of the image control but it's always hidden beneath the image control. Is there any way I can make it come over top of the image contro?? I have played ar...
Zorder in Win 2k
Does Win 2k handle Zorder differently? All of my windows keep appearing at the bottom of the Zorder instead of the top when I spawn them.What the heck is going on?Eiredrake...
z-order from some components
some components e.g. the "spinButton" are not able to bring to front! Also i set z-order in code and choose option "Bring to front" With other components it's no problem!!! Can you help me?...
zorder and show form
hello,i have 2 forms that i want to display in 2 different ways.form1 shows form2 with vbmodal as default.then on form2 i have a check button thay says: 'always on top'.when you click on it you change the default setting either to on top or not on top.i only managed to get this work af...
Z-ORDER
[Originally posted by Jim]Using pictureboxes, how do i write a function to move a picturebox forward or backward using their Z-order property. I don't want to move them all the way to the back, just one step backward at a time and the same for forward....
zorder
hey,i just need a reminder.when i have a form and from within it i .show another form how do i keep the user from getting back to form1 before clicking exit on form2, and without making form2 alwais on top?thanks.....

Microsoft Visual Basic Related Categories

Microsoft Visual Basic