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

Problem in adding a column using vb 6.0

100+
P: 198
Hi

can any one help by solving this probleum i am accessing mdb database and i want to alter the table . i use the following syntax but it is showing the syntax error

squery = "alter table " & sTableName & " add bookcode varchar(10) IN '" & txtfolderpath & "\" & sArrFolder(icount) & "\" & sDirFolder & " '"
dbmaster.Execute (squery)

please help me
Apr 19 '08 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
You need to use ADOX library for any DDL .
Apr 21 '08 #2

100+
P: 198
Hi
the error is still same

You need to use ADOX library for any DDL .
Apr 23 '08 #3

debasisdas
Expert 5K+
P: 8,127
You need to learn SQL before trying to execute them from VB.

Learn the basics of SQL first.
Apr 23 '08 #4

lotus18
100+
P: 866
Hi

can any one help by solving this probleum i am accessing mdb database and i want to alter the table . i use the following syntax but it is showing the syntax error

squery = "alter table " & sTableName & " add bookcode varchar(10) IN '" & txtfolderpath & "\" & sArrFolder(icount) & "\" & sDirFolder & " '"
dbmaster.Execute (squery)

please help me
if this is .mdb file, varchar datatype is not yet available. Check your query.

Rey Sean
Apr 23 '08 #5

Post your reply

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