Insert Into is working when called from Visual basic 6 - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Insert Into is working when called from Visual basic 6

It was working alright. But suddenly when I format the sql statement taking the variables and concatenating them to from the Insert Into Statement the error is there "Syntax Error in Insert statement" But when i print the sql statement in the immediate window and then directly make a query of this statement it works fine. I wonder what the problem might be...

Naveed Ahmed

Comments

  • BarkeeperBarkeeper Posts: 335Member
    : It was working alright. But suddenly when I format the sql
    : statement taking the variables and concatenating them to from the
    : Insert Into Statement the error is there "Syntax Error in Insert
    : statement" But when i print the sql statement in the immediate
    : window and then directly make a query of this statement it works
    : fine. I wonder what the problem might be...
    :
    : Naveed Ahmed
    :

    Do you have any code-snippet showing the construction of the SQL-Statement? AFAIK the most problems with constructed SQL-Statements come from Strings- and Date-Variables.
    ------------------------------------------
    Only stupidity of mankind and the universe
    are infinite, but i'm not sure concerning
    the universe. A. Einstein
Sign In or Register to comment.