By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

error: operator + is not defined for string and

P: 3
hello, pls can anyone tell me how to get around this error: operator + is not defined for string and

here is the code

dim comm AS OdbcCommand ("insert into table2 select * from" + oDS.Tables(0),oConn,oTrans)

how do i insert the record in the dataSet into another database table.
thx for your help
Oct 25 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 7,872
That was a very hap-hazzard attempt at inserting it, just trying to add a dataset to a string

You would need some kind of SQL insert statement and then pull the values from the record you want use them in that insert statement and execute it.
There might be a way to do it with bound datasets, but I am unfamiliar with that
Oct 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.