Re: Passing data from VB 5.0 to Oracle??????

From: Christopher Yiangou <christopher.yiangou_at_pixie.co.za>
Date: 1998/05/13
Message-ID: <3558d2d9.0@hawk.pix.za>#1/1

I'm assuming that you're already connected to the database, now you need to transfer your values to a table:

' Example for Oracle Objects for Ole
' txtEmpId.Text and txtEmpName.Text are textboxes on your form
' note delimiting single quotes for text fields

Sql="INSERT INTO table"

Sql=Sql & " ( EmpId , EmpName )"
Sql=Sql & " VALUES ("& txtEmpId.Text &",'"& txtEmpName.Text &"')" OraDb.Execute Sql (or is it .ExecuteSQL Sql ?)

G Vaidhyanathan wrote in message <01bd7a18$b5445500$95a3bfa8_at_default>...
>Hello:
>
>Can somebody help me with a piece of code to insert new records new records
>in oracle table from a VB 5.0 form?
>
>thanks
>-ganesh
Received on Wed May 13 1998 - 00:00:00 CDT