Re: How to record quotation marks

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 06/10/04

  • Next message: Viatcheslav V. Vassiliev: "Re: Workgroup Information File of Access"
    Date: Thu, 10 Jun 2004 11:09:35 +0400
    
    

     query1.sql.add('insert into memorando (chamada, texto) values (' +
     QuotedStr(cCampo1) + ',' + quotedSrt(cCampo2) + ')');

    //------------------------------------------
    Regards,
    Vassiliev V. V.
    http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
    ADO.Net
    http://www.oledbdirect.com - The fastest way to access MS SQL Server,
    MS Jet (Access) and Interbase (through OLEDB)

    "Brian Bushay TeamB" <BBushay@Nmpls.com> ???????/???????? ? ????????
    ?????????: news:galfc0p96ulsgkdt5356e7kihq4am6h5f5@4ax.com...
    >
    > >I am not getting to record text with quotation marks in a field type
    memo,
    > >somebody has some clue.
    > >
    >
    > Try
    > query1.sql.add('insert into memorando (chamada, texto) values
    > (QuotedStr(cCampo1),quotedSrt(cCampo2))');
    >
    > or use parameters in your query
    >
    > --
    > Brian Bushay (TeamB)
    > Bbushay@NMPLS.com


  • Next message: Viatcheslav V. Vassiliev: "Re: Workgroup Information File of Access"

    Relevant Pages

    • Re: MS Access table and field properties
      ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
      (borland.public.delphi.database.ado)
    • Re: index list with ado?
      ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
      (borland.public.delphi.database.ado)
    • Re: Looking for free installer program
      ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
      (borland.public.delphi.thirdpartytools.general)
    • Re: Bitmaps in SynEdit
      ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
      (borland.public.delphi.thirdpartytools.general)
    • Re: a connection problem
      ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
      (borland.public.delphi.database.ado)