SQL Problem2

• • Reply

  19 years ago

  by azmh

  j

  , United States

  Joined 19 years ago

  I have make an DLL File and define an Function into it with name
  Fname(i as string) ,and the file with name Try.Dll
  And i have insert Try.dll in my Project References and it work good...but
  when i insert try.dll in me database file References and create an Query that use Fname function it's do not work and the database can't know this function .....Why????
  

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  As I said in the last one, SQL statements and your VB code are entirely seperate. You can use your function within the VB project that references it, but not in the SQL statement. Therefore, instead of doing
  "SELECT something FROM table WHERE id=myfunction(something)"
  you would do
  "SELECT something FROM table WHERE id=" & myfunction(something)
  -- then VB parses the myfunction part, instead of treating it as string and ignoring it. What exactly are you trying to do??
  

  Report abuse