Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

INSERT SQL query with the help of VB

 
   Database Help (Home) -> Oracle RSS
Next:  Detecting Single User Mode  
Author Message
keytowin




Joined: Jan 31, 2009
Posts: 1



(Msg. 1) Posted: Sat Jan 31, 2009 2:45 pm
Post subject: INSERT SQL query with the help of VB

Public cnn As New ADODB.Connection
cnn.ConnectionString = "provider=MSDAORA;user id =scott;password=tiger;"
cnn.CursorLocation = adUseClient
cnn.Open

Public rsret As New ADODB.Recordset
With rsret
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open "member", cnn, , , adCmdTable

sq = "insert into return values('" & Text2.Text & "',#'" & CStr(Date) & "'#,'" & Text5.Text & "')"

cnn.Execute sq

error:invalid character

 >> Stay informed about: INSERT SQL query with the help of VB 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
trouble with insert - This should be so simple, yet it is not working. I am trying to do an insert into a table where the values inserted are gathered from a select from another table. This form works: insert into table2 (select fld1, fld2, fld3 from table1 where blah) ....

What is the Purpose of Subquery in Insert? - This statement is found in oracle's training material: INSERT INTO (SELECT employee_id, last_name FROM employee WHERE department_id=50) VALUES(9999,'peter'); The above subquery is interpreted as the list columns to be inserted with...

multi table insert ? - Hello INSERT INTO ALL WHEN DEPT_NO IN (12,14) THEN INTO EMP SELECT * FROM EMP_OLD; Is it correct statemant ? I think it's not (without first INTO it is ok), but i found somewhere that it is. Could anybody explain why ? Thanx Michal

i can't insert 'a''a' in a field with size 3 - hi, i run INSERT INTO test (FIELD1) VALUES ('a''a') but DBMS oracle returns this error: ORA-01401: inserted value too large for column (FIELD1 size is 3!) what's the error?

problem insert on clob field - Hi, I have a problem inserting a clob field in a database table. My table create table T1(id int, xmlmsg clob); when I do an insert on this table with a big xmlmsg i get an error that he string literal is too long. My sql code insert into T1(id,..
   Database Help (Home) -> Oracle All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]