Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have written a Search and Replace Access database which allows users to search for specified text in all queries, and optionally to replace the search text with some other text.

    What I would like to be able to do - but I have a feeling this is not possible - is to then verify the syntax of the query's new SQL, so that if it was not valid the text would not be changed.

    Does anybody know if this is possible ? If not, any suggestions as to how to get around it somehow.

    Thanks for your help

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I don't know the answer to your question.

    One way around it is to use Rick Fisher's Find and Replace instead of doing it yourself.
    Regards
    John



  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    [quote name='Bodders' post='767044' date='24-Mar-2009 13:04']I have written a Search and Replace Access database which allows users to search for specified text in all queries, and optionally to replace the search text with some other text.

    What I would like to be able to do - but I have a feeling this is not possible - is to then verify the syntax of the query's new SQL, so that if it was not valid the text would not be changed.

    Does anybody know if this is possible ? If not, any suggestions as to how to get around it somehow.

    Thanks for your help[/quote]
    Actually, I don't think you can save an invalid SQL. I believe it will produce an error.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •