Dear Rommel,
I venture to say that the short term pain of renaming the RowID column
in each table will be less than the long term pain of trying to shoehorn
R:BASE into operating against its design principles.
I recall having a problem with a tiered region in a form based on a view
that I have not tested in the latest version to see if it has been fixed.
I needed the personnel records able to be sorted on surname. Surname
was in the Persons table. "Easy as!" I thought. Create a view on
Persons and Personnel, enable the selection and sorting of the personnel
records by all columns in the view and therefore enable the display of the
records in the tiered region.
Trouble was, whenever the cursor reached the last row, if the user pressed
[F8] or clicked the button that initiated the NEXTROW function R:BASE
would crash to the desktop.
Another caveat on the same column name in unrelated tables is the mess
you would get if you pointed an entity relationship mapping tool at the
database schema.
Like many decisions it surpasses two valued logic and is only resolved by
using infinity valued logic - which is the lesser of the two evils or which
imperfect solution is better?
One thing I would recommend, test the form based on the view at your
earliest opportunity.
At 10:10 15/05/01 -0700, you wrote:
> >> Could you change the RowID column of Table A to say... RowIDTabA?
>Heh... no. :)
>A good number of the tables in the database will have this RowID as a unique
>row identifier (as side from using PKs).
>The RowID columns are used in a data replication process developed here.
>Changing the name of the column (RowID) to be unique across the database
>will make the data replication code very difficult to maintain and manage.
>I guess a work around would be is to have a "column mapping table" but, that
>probably will not help the manageability. We already have a hard time
>documenting the replication process... hehehe.
>The most feasible work around is using a view for the 2nd table, since not
>all tables needed for replication are accessed with a form.
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 61 (0)2 9552 3311
fax: 61 (0)2 9566 2164
email: [EMAIL PROTECTED]
mobile: 0414 675 903
street: 3/66 Wentworth Park Rd Glebe NSW 2037
post: PO Box 470 Glebe NSW 2037 Australia
temp web site: 210.9.46.35
_/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
_/ _/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/_/_/_/ _/ _/_/_/_/_/
_/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/ _/ _/_/_/_/_/
