Member Avatar for avinashpatil

Hi All
i have problem in insert statement in which one string returning me value as g's and because of that s is gets separated. and its giving me eroor as Incorrect syntax at s.

strSQL = "Insert into HeaderInfo(yAxisLabel , xAxisLabel , zAxisLabel , yAxisUnit , xAxisUnit , zAxisUnit)"
 strSQL &= " values('" & YAxisLabel & "','" & XAxisLabel & "','" & ZAxisLabel & "','" & YAxisUnit & "','" & XAxisUnit & "','" & ZAxisUnit & "') "

here YAxisUnit variable giving o/p as g's
so how to remove that problem
plz help me out from it

thanking you all

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

I don't understand your problem neither the error you got. Please clarify your question, copy the error message and tell us which language you use.

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.