User Profile

Collapse

Profile Sidebar

Collapse
LightRaven
LightRaven
Last Activity: Feb 22 '08, 10:09 AM
Joined: Feb 20 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • LightRaven
    replied to MS Access, SQL and Java
    in Java
    due I don't want to read the entire database for processing in java. I was hoping the for that SQL statement sent, it would try to look in the module section when it saw this function call.
    See more | Go to post

      Leave a comment:

    • LightRaven
      started a topic MS Access, SQL and Java
      in Java

      MS Access, SQL and Java

      I have defined a VBA function inside a module like this:

      Public Function MyFunction() As Integer
      MyFunction = 2
      End Function

      In my Java program i have the follow:
      ....
      String query = "SELECT * FROM MyTable WHERE ID = MyFunction()";
      ....
      statement.execu te(query);
      .....

      It is an MS-ACCESS database. I get the following error:
      "function...
      See more | Go to post
      No activity results to display
      Show More
      Working...