Re: How to record quotation marks

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 06/10/04 

Date: Wed, 09 Jun 2004 22:29:44 -0500

>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

Relevant Pages

  • Re: cancel during asyncfetchnonblocking
    ... >The problem with this seems to be, that the query is not really cancelled ... >AdoDS.Close - looking at my memory usage it climbs incredibly. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: About lookup fields..
    ... No you will have to use a TadoDataset and then create the field in your query to ... sort by it. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: ADO DBASE Seek
    ... Willi ... > Probably using a select query ... > Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: cancel during asyncfetchnonblocking
    ... >Can you use the same object for another query? ... >settings but can't seem to get this working in an OK ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Simple TADOQuery is not live
    ... Brian Bushay TeamB wrote: ... >> The query is left open because its just had lots of validation done ... row I do a kind of two stage commit by first querying my date/time with ...
    (borland.public.delphi.database.ado)