Member Avatar for mykar_88

hi
i'm receiving anerror message while executing this statement.

dr.Execute ("alter table results12 add (Total number,Percentage number,Status char(5))")

error message

run-time error:3292
syntax error in field definition

  • 2 Contributors
  • 6 Replies
  • 94 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by mykar_88
Member Avatar for aktharshaik

It must be

dr.Execute ("alter table results12 add Total number,Percentage number,Status char(5)")

remove the Parenthesis for the Fields list provided.

Member Avatar for mykar_88

hi
i tried without parenthesis too
but if the parenthesis is removed,it is showing syntax error in alter statement.

Member Avatar for aktharshaik

What is the Database Backend u r using??

Member Avatar for aktharshaik

It worked for me with VB 6.0 and MS-Access Database.

Member Avatar for aktharshaik

If SQL Server use the query below

dr.Execute "ALTER TABLE results12 ADD Total Numeric, Percentage Numeric, Status char(5)"

By the way what is type of variable dr ? is it ADODB.Connection?

Member Avatar for mykar_88

hi
i'm also using MS-Access as backend
dr is a DAO connection.
i have included another alter statement.but its working.
anyhow once again i'll try with ur syntax and update it to u.
thank u

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.