VB6 + ORACLE HELP NEEDED URGENT

[ajaybc]

I have made a database in oracle with the fields Name and marks.
Iam making a frontend program in VB6 for inputting values into it.
But it is VB is showing syntax error.Please help

Dim cn As New ADODB.Connection
Private Sub cmdAdd_Click()
cn.Execute "INSERT INTO MARKLIST(NAME,MARKS) VALUES('"txtNAME.Text"',"txtMarks.text")"
End Sub

Private Sub Form_Load()
cn.ConnectionString = "Provider=MSDAORA.1;Password=ajaybc;User ID=SYSTEM;Data Source=VIRTUALAJAY;Persist Security Info=True"
cn.Open
End Sub

 

[furious_gamer]

^^
Why dont u put your table structure and exact error message here, so that we can understand what's really going on..

 

[ajaybc]

^never mind got the solution.

cn.Execute "INSERT INTO MARKLIST(NAME,MARKS) VALUES('" & txtNAME.Text & "'," &txtMarks.text & ")"

 

[furious_gamer]

^^

Thats coool... Atleast i learnt something

 

[ajaybc]