Replace functions in VB or Delphi

  • Thread starter Thread starter Vincent Choy
  • Start date Start date
V

Vincent Choy

Hi all,
i try to create a view with the replace function in access 2000, i find
that there is no problem. however, when i run it at Visual Basic or delphi,
there is an
error (undefined replace function). Does anyone know why.
 
Vincent Choy said:
Hi all,
i try to create a view with the replace function in access 2000,
i find that there is no problem. however, when i run it at Visual
Basic or delphi, there is an
error (undefined replace function). Does anyone know why.
Click to expand...

I'm not terribly well versed in the internals of this, but as I
understand it, when you run queries from within Access, the
application's Expression Service is available to the Jet database
engine, and that service evaluates the VBA function call for Jet. When
you run the query from VB or any other application, however, the Access
Expression Service isn't available to evaluate the function, so the
query fails.
 
Back
Top