Chuck, Perhaps the easiest method is to unload the database to a file and use a text editor (my favorite is KEDIT by Mansfield Software of Storrs, CT). Do Global changes to the unloaded file then reload. You will need to change all of your "CMD", "RMD", and "APP" files. If the application was maintained by APPLICATION EXPRESS you will have to learn how to use CODELOCK. In changing the unloaded file. Make sure you change the quote character to QUOTE QUOTE before you change the DOUBLE QUOTE to SINGLE QUOTE. For Example "James O'Harra" need to become 'James O''Harra'.
You are correct SRPL could be used even on the SYS_FORMS, SYS_LABELS, and SYS_REPORTS tables. Just declare a cursor to fetch the appropriate SYS_FORM_DATE, SYS_LABEL_DATA, or SYS_REPORT_DATA column. The hard part is COMPUTED columns that need to be changed. There is no way to directly edit the SYS_COMPUTED table where the computed column formula is stored since the SYS_COMPUTED table is hidden. The only way would be to drop and recreate the appropriate computed columns. If the same computed column name is used in multiple tables you will need to first drop all of them then start the recreate process. At one time some firm once marketed a program to automate the double quote to single quote conversion. Can't remember who an my copies of the RBASE EXCHANGE MAGAZINE are presently stored away. All in all I would go the unload route. Possible unloading data and structure into separate files. Above all BACKUP!!! BACKUP!!! BACKUP!!! before making any changes of this magnitued. After you have made the database and application conversion. TEST!!! and re-TEST!!! your application. I also recommend using RSTYLE on all you application files. Be sure to checkout the SET QUOTE command in all files. Since RSTYLE will track and honor this command. -- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- "Chuck Lockwood" <[EMAIL PROTECTED]> wrote: > 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/
