Bill, Wow! and I was wondering what project I should start today <g>.
Thanks for the blueprint and the code snippets, I'm ready to start. ~Claudine :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall Sent: Tuesday, September 24, 2002 11:45 AM To: [EMAIL PROTECTED] Subject: Changing from Double to Single Quotes On Tue, 24 Sep 2002 10:40:06 -0500, Claudine Robbins wrote: >OK, I'm a convert. Now, what is the best approach to switching to >single quotes? Well, I'll get started, but others should jump in. Lots of backing up and testing, of course, Work on a complete copy of the database and application. You can copy files over when you are done, (not the database, but the other files), and you can transfer modified forms, reports and labels with OUTPUT/UNLOAD Rules and Views you may want to revise in the production database. Here is a list of places where double quotes could be hiding, and need to be changed: text files on disk: (for these, you can use R:Code search and replace, with confirmation, to work through them.) =============== Command Files Application Files EEP Files Stored Procedure source code files RBASE.CFG file Data within the database: ================== variable expressions in forms variable expressions in labels variable expressions in reports view definitions computed column definitions rule definitions For the views and rules, you can do SELECT commands looking for double quotes within the sys_views.sys_query or sys_rules.sys_where columns. If your current quote character setting is a double quote, and you are looking for a double quote, you need to "double" the double quote INSIDE a pair of double quotes. So your where clause will have four double-quote marks in a rows: SEL * FROM sys_rules WHERE sys_where CONTAINS """" For the expressions in forms, reports, and labels, you will have to open each one and choose "Variables/List Expressions" to review them by eyeball. And, when you are finished, be sure that, while connected, you SET QUOTES=', then disconnect. Bill ================================================ 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/
