SQL COMMAND

• • Reply

  19 years ago

  by azmh

  j

  , United States

  Joined 19 years ago

  The code is:
  db.excute "insert into Table1 (Feild1) values F(4)"
  "F" is a function that I define in a module in my project
  the error is  "Function is not define in expresion" ....
  What is the reason? this my quastion.

  Report abuse
• • Reply

  19 years ago

  by gigsvoo

  gigsv00

  , United States

  Joined 19 years ago

  This is becoz ur function is only recognize by VB but not SQL syntax do something like this:
  

  
  db.excute ("insert into Table1 (Feild1) values " & F(4))
  

  
  This should works

  Report abuse