apostrophe

From: Michael Sterling (stermic_at_gw.co.jackson.mo.us)
Date: 12/18/03

  • Next message: Jeremy Collins: "Re: apostrophe" 
    Date: 18 Dec 2003 08:39:50 -0800

    i'm using delphi 7 and have a query in which i'm trying to find names
    that have an apostrophe in them, i.e. "o'mally". my problem is that
    when i write my select statement i can't get the quotes right. i get
    all types of errors no matter what i try. i get "missing right quote",
    "invalid token" etc. i've tried using QuotedStr and nothing works.
    here is my current attempt in which i get an "invalid use of keyword.
    token: n'%'"

    sSQL := 'SELECT statenotified, notary_id, LastName, FirstName,' +
            ' MiddleInitial, Indep, Book_number, Page_number,' +
            ' CloseRec, TermBegins, TermEnds, DatePickedUp,
    FailedToQualify,' +
            ' Notes, SOSLtrSent FROM notaries WHERE LastName LIKE '''+
            ''+ edtLastName.Text+'+''%'' AND CloseRec = 1 order by
    lastname';

  • Next message: Jeremy Collins: "Re: apostrophe"

    Relevant Pages

    • Re: how to link to a csv file with a date field in it?
      ... Regarding the scheduler it's in XP and above - if you aren't familiar with using the Windows Task Scheduler, here is a link to a fairly clean, simple, short tutorial. ... I think you have the right idea - link to the csv, maybe run an append query to process the contents into your main table, in that query you can fix things such as the date. ... s is the complete row of data as a string, flag is a boolean that is initialized to be False. ... The full code I snipped this from contains so much checking for quotes and # hashes and internal commas and internal single quotes replacing certain chars, that it's difficult for me to follow and I wrote it. ...
      (microsoft.public.access.externaldata)
    • Re: how to link to a csv file with a date field in it?
      ... I think you have the right idea - link to the csv, maybe run an append query to process the contents into your main table, in that query you can fix things such as the date. ... s is the complete row of data as a string, flag is a boolean that is initialized to be False. ... We can create a recordset object and set it to a specific table - we add the new row one field at a time, testing each field for type using a select case, add the # for dates or ' for text or nothing for numeric field types to the fldArrrayelement contents and the set rs.fields= the resulting expression. ... The full code I snipped this from contains so much checking for quotes and # hashes and internal commas and internal single quotes replacing certain chars, that it's difficult for me to follow and I wrote it. ...
      (microsoft.public.access.externaldata)
    • Aging Function
      ... I took your advice and the query worked! ... total debits for those accounts, ... >problem with using the accounts as criteria. ... >it was a result of the missing single quotes. ...
      (microsoft.public.access.modulesdaovba)
    • Re: Question on displaying repeating data
      ... Next, I have to choose the link from the main form, to the subform. ... >> of historical quotes. ... The query logic is relatively simple. ... >> My problem is that I don't know how to display this. ...
      (microsoft.public.access.forms)
    • pop-up form to filter report
      ... when writing sql code use double quotes to ... denote the sql query text and single quotes for string ... John is right about the need to lose the ...
      (microsoft.public.access.reports)