VB6 + ORACLE HELP NEEDED URGENT

5 posts · originally from https://geek.digit.in/community/threads/vb6-oracle-help-needed-urgent.119806/

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

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

^never mind got the solution.

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

^^

Thats coool... Atleast i learnt something