At 11:42 AM 3/24/2011, Tom Frederick wrote:
Only solutions I can think of:
1. Go do something else for awhile until frustration subsides.
2. Delete all forms and reload forms from a backup from several
days ago. Problem is some of the dups do not delete.
Bigger question how does this happen? UPLOADing forms from
another database has always erased the existing form before
adding the new version.
Tom,
Without knowing all details, let me offer you a few suggestions and a
solution to your specific scenario in your development and deployment
environment.
00. Take a walk down the block, find a Starbucks Coffee shop, and
have yourself your favorite drink.
01. Make sure that you are using the current update and build of
R:BASE eXtreme 9.1 (64).
R:BASE Updates: http://www.rupdates.com
02. Copy the database (dbname.rx1-.rx4) on your local workstation
in a separate folder
03. Start R:BASE eXtreme 9.1 (64) and CONNECT the database on your
local workstation. At the R> prompt, type:
EDIT * FROM SYS_FORMS3 ORDER BY SYS_FORM_NAME, SYS_FORM_MOD_TS
Maximize the Browser/Editor and adjust/resize the column width
to view everything on the screen.
Now carefully highlight the duplicate row you wish to delete.
Use [F9] key to delete and confirm everything before clicking
on [Yes] button.
Repeat this for all duplicate rows, if deemed necessary.
Right-click on any cell in SYS_FORM_NAME column, click on
Calculate, and then select "Duplicates ...".
There should be no duplicate at this time, if you followed
the steps correctly.
04. Now re-build the entire database to assure the health and
integrity of the database.
OUTPUT ABC.ALL
UNLOAD ALL
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rx? dbname_bkp.rx?
SET FEEDBACK ON
RUN ABC.ALL
-- Watch the database being built in front of your eyes!
SET FEEDBACK OFF
DISCONNECT
EXIT
05. Take this fresh database, go live, and have fun!
06. Make sure to re-compile your application, using the latest
version and build of R:BASE eXtreme 9.1.
Very Best R:egards,
Razzak.
