how to create table in oracle 8/8i from visual basic 6.0
- Status
sachin_kothari
Ambassador of Buzz
Possible. You'll have to write a query to do so in the ADODB Recordset's Open property.
You can run any SQL query in a similar fashion
You can run any SQL query in a similar fashion
hi ! Okay here is the following
i am using the following assuming you have Microsoft ADO Data Objects seleted in your references.
Dim cnn as Adodb.Connection
set cnn=new adodb.connection
cnn.open "your connection properties and connection string"
the above command u created a new connection object and using the open method u connected successfully with ur database, i am assuming you know how to successfully make a connection with a database.
now that the connection is open, u can use the Execute method of the connection object to execute any SQL script ...something like :
cnn.execute " select * from address"
Now u must know the SQL command to create a table, that is done using CREATE TABLE. The simplified version of create table is
CREATE TABLE yourtablename (yourcolumn1 datatype,column2 datatype)
ofcourse this is the most basic SQL Statement, there are many options included in the CREATE TABLE statement but that would be very lengthy. For a complete tutorial on SQL you can go here:
and download the pdf's if you want
i am using the following assuming you have Microsoft ADO Data Objects seleted in your references.
Dim cnn as Adodb.Connection
set cnn=new adodb.connection
cnn.open "your connection properties and connection string"
the above command u created a new connection object and using the open method u connected successfully with ur database, i am assuming you know how to successfully make a connection with a database.
now that the connection is open, u can use the Execute method of the connection object to execute any SQL script ...something like :
cnn.execute " select * from address"
Now u must know the SQL command to create a table, that is done using CREATE TABLE. The simplified version of create table is
CREATE TABLE yourtablename (yourcolumn1 datatype,column2 datatype)
ofcourse this is the most basic SQL Statement, there are many options included in the CREATE TABLE statement but that would be very lengthy. For a complete tutorial on SQL you can go here:
Code:
*www.db.cs.ucdavis.edu/teaching/sqltutorial/and download the pdf's if you want
- Status