access function 'Replace' in delphi

From: Vincent Choy (vincent_at_exodus-tech.com)
Date: 10/28/03 

Date: Tue, 28 Oct 2003 10:33:56 +0800

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 delphi, there is an
error (undefine replace function). Does anyone know why.

//no problem in access view
e.g. select replace(a.id,'1','*') as newid from a;

//has problem with get the record set
var
    conn:TAdoconnection;
    rs:_recordset;
begin
    ..
        strSQL:='select replace(a.id,''1'',''*'') as newid from a';
        rs:=conn.Execute(strSQL);
    ..
end;

Relevant Pages

  • Re: GetComputerName
    ... > - Delphi allows us to send it to APIs as a PChar ... > Some APIs perform differently between versions of Windows ... > Reporting the result of GetLastError is a pretty generic task ...
    (alt.comp.lang.borland-delphi)
  • Re: Question: how to read any one character from keyboard
    ... Doesn't anyone use Delphi anymore? ... the user at one point to "press any key" (it's a console app and this ... The help says that if you use Read with a Char var, ...
    (alt.comp.lang.borland-delphi)
  • Re: Generics for Delphi
    ... fVaribale: Array of Integer; ... Unfortunately, I can see the similarity, but that doesn't mean I have to like it :-) This is the point I am trying to make about matching generic delegate types to handlers; I can see unwanted complexity about to rear its ugly head :-( I must admit that things like this have always put me off Pascal from before I ever saw Delphi; it was only the superb Delphi IDE that "encouraged" me to use Pascal in the first place. ... public class MyClass<typeT>: MyClass ...
    (borland.public.delphi.non-technical)
  • Re: C++ to Delphi, HELP !!!
    ... I think this is a Delphi implementation of the BluffTitler C++ ... PtrData: PCopyDataStruct; ...
    (alt.comp.lang.borland-delphi)
  • Re: C++ to Delphi, HELP !!!
    ... I think this is a Delphi implementation of the BluffTitler C++ ... PtrData: PCopyDataStruct; ...
    (alt.comp.lang.borland-delphi)