SQL Problem

• • Reply

  19 years ago

  by azmh

  j

  , United States

  Joined 19 years ago

  The code is:
  

  
  Private Sub Command1_Click()
     Dim d As Database
     Set db = OpenDatabase("C:\DB1.mdb")
     db.Execute "Update tbl SET tbl.a=FF(tbl.a) "
  End Sub
  Public Function FF(i As Integer) As Integer
     If IsNull(i) Then
         FF = 0
     Else
         FF = i
     End If
  End Function
  

  
  The Problem Is :
  the Compiler Give me this massge 'Undifne Function "FF" In Experstion'
  why?? and what the solution....
  

  
  

  
  

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  Use
  

  
  db.Execute "Update tbl SET tbl.a=" & FF(tbl.a)
  

  
  The database doesn't know anything about your FF function... you need VB to parse that bit first, and then put it into the string.

  Report abuse