----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 4:31 PM Subject: Re: Double to Single Quotes
| do an unload all. Use a good text editor and do a search and replace. You | need to do it this way because of the double quotes in expressions in forms | and reports.... +++++++++++++ And one other caution, Chuck: Using the same text editor, you'll occasionally get into an error if you have text that ALREADY CONTAINS a single quote. Suggest you FIRST search for any instances like an apostrophe in a text message. You have two choices: change them to another symbol, like a backward single ' [ ` ], or -- in most cases -- it will work to simply place another single quote, like [That''s invalid!] (example is 2 Singles, NOT a double quote!!). -- Vic Cook +++++++++++++++ | | ----- Original Message ----- | From: "Chuck Lockwood" <[EMAIL PROTECTED]> | To: "Rbase List Server" <[EMAIL PROTECTED]> | Sent: Tuesday, July 09, 2002 3:38 PM | Subject: Double to Single Quotes | | | > Is there a "easy" way to convert a database with lots of DOS forms/reports | > expressions, views and computed columns that are using double quotes to | > single quotes instead? | > | > Looks like most things can be done with SRPL on the system tables, but | what | > about the computed columns? | > | > Success / Horror stories? | > | > Chuck Lockwood | > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | > LockData Technologies, Inc. | > 309 Main Avenue, Hawley, Pa 18428 | > Phone: 570-226-7340 ~ Fax: 570-226-7341 | > Email: [EMAIL PROTECTED] ~ http://www.lockdata.com | > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | > | > | > | > ================================================ | > TO SEE MESSAGE POSTING GUIDELINES: | > Send a plain text email to [EMAIL PROTECTED] | > In the message body, put just two words: INTRO rbase-l | > ================================================ | > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] | > In the message body, put just two words: UNSUBSCRIBE rbase-l | > ================================================ | > TO SEARCH ARCHIVES: | > http://www.mail-archive.com/rbase-l%40sonetmail.com/ | > | | ================================================ | TO SEE MESSAGE POSTING GUIDELINES: | Send a plain text email to [EMAIL PROTECTED] | In the message body, put just two words: INTRO rbase-l | ================================================ | TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] | In the message body, put just two words: UNSUBSCRIBE rbase-l | ================================================ | TO SEARCH ARCHIVES: | http://www.mail-archive.com/rbase-l%40sonetmail.com/ | ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
