The single and multi characters are pretty safe to change, as they won't prevent any code from running. They just affect code that uses wildcards.
My apps always call a separate code module for every connect to the db. It checks and changes all stored settings to the defaults if they are not correct. That way, no one ever gets stuck in a weird mode. But, if you can get you code to work without changing the wildcards, more power to you. I too try to avoid changing the settings as much as humanly possible. Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Thursday, January 31, 2008 11:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding '__' query Thanks both. I have been _trying_ to make it a rule not to change any of the SET characters if there is an alternative. Not because it's a problem as such but because when testing if something bombs out I get caught so often. If I had to place a bet on who it was that had an escape sequence it would have been you Dennis, or Bill Downall - perhaps it was for something else. Emmit, I'll try your suggestion & report back. Regards, Alastair. ----- Original Message ----- From: Dennis McGrath<mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List<mailto:[email protected]> Sent: Thursday, January 31, 2008 2:37 PM Subject: [RBASE-L] - RE: Finding '__' query In this case you will need to temporaily change the SINGLE character. SET SINGLE=? Notice no spaces around the = Now search for your underscores. When done SET SINGLE=_ Dennis McGrath Not enough coffee yet this morning. Make that (CHAR(95)+CHAR(95)). Emmitt Dove ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, January 31, 2008 7:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding '__' query Alastair, Try setting a variable to (CHAR(45)+CHAR(45)) and looking for the variable. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Thursday, January 31, 2008 6:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Finding '__' query I am trying to find and then eliminate a realstring of two underscores in a file name. Because the underscore is the single wildcard, probably not surprisingly, I am finding far more than I want. I seem to remember that there was a way of escaping the character to force the search to find the underscores rather than any character. Can anybody remind me of how to do it, please? Thanks & regards, Alastair. ---------------------------- Alastair Burr St. Albans, UK. [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> ----------------------------- ________________________________ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.17/1252 - Release Date: 30/01/2008 20:51
