Go Directly To
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Mar 25, 2006 1:04 AM by 433353
Update record using VB6.0 and Oracle 10G Express Edition
Mar 23, 2006 8:52 AM
I have VB6.0 and Oracle 10G Express Edition in Windows 2000 Server. My procedure in VB 6.0 can't update record in the table using SQL statement, and the Error Message is " Missing SET keyword ".
The SQL statement in VB6.0 look like this :
Dim conn as New ADODB.Connection
Dim rs as New ADODB.Recordset
Private Sub Command1_Click()
dim sql as string
sql = " UPDATE my_table " & _
" SET Name = ' " & Text3.Text & " ' " & _
" AND Unit = ' " & Text2.Text & " ' " & _
" WHERE ID = ' " & Text1.Text & " ' "
Private Sub Form Load()
Set conn = New ADODB.Connection
conn.Open "Provider=MSDASQL;" & "Data Source=my_table;"& "User ID =marketing;" & "Password=pass123;"
I'm sorry about my language.
What's wrong in my SQL statement, I need help ........ asap
This content has been marked as final.
Show 1 reply
Re: Update record using VB6.0 and Oracle 10G Express Edition
Mar 25, 2006 1:04 AM
in response to
you should use "," (comma) in order to seperate the columns to be updated. You have used "AND" keyword which is wrong. SQL should be something like
SET col1=1236, col2='something', col3=787
is it clear enough ?
YT from BTG