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.