Problem in adding a column using vb 6.0

[veer]

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(icou nt) & "\" & sDirFolder & " '"
dbmaster.Execut e (squery)

please help me

[debasisdas]

You need to use ADOX library for any DDL .

[veer]

Hi
the error is still same

You need to use ADOX library for any DDL .

[debasisdas]

You need to learn SQL before trying to execute them from VB.

Learn the basics of SQL first.

[lotus18]

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(icou nt) & "\" & sDirFolder & " '"
dbmaster.Execut e (squery)

please help me

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

Rey Sean