Hi Ralph,
Personally I feel ND4's way of attaching the object-owner prefix to the
database objects is messy. May be, somebody thought it might be better than
what ND3 used to do - no prefix attached-, and may be it is so in some
situations, but in general I find it has made life a little more difficult.
The good news is that ND4 does a dynamic replacement of the owner-prefix at
run-time. So if you set the Studio user as INV and Runtime user as CAMP -
both properties for the DataSource - it takes care of most situations. There
might be situations where this is not enough, and the best solution may be
to use public synonyms.
Regards,
Aby
> -----Original Message-----
> From: Cavallaro, Ralph [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 28, 2000 2:06 PM
> To: 'Aby Mathew'
> Subject: RE: [ND] Fw: [ND] Conversion from 3.11->4.1:data objects lose
> tab le names.
>
>
> Hi Aby,
>
> Thanks for getting back to me. That worked out fine,
> however when I
> go and change the Datasource to point to the production
> database, a similiar
> problem arises. Our production database owner is "CAMP" while our test
> database owner is "INV". When the datasource is changed to point to
> production. The table names still contain the "INV." prefix.
> I can keep
> editing the .sdo file but it seems like this should not have
> to be done like
> this. Is there a reason for this occurring?
>
> In any case, Thanks again for
> getting back
> to me.
>
>
> Ralph Cavallaro
> Toys R Us
> MIS Inventory Applications
> (201) 802-5459
>
> > -----Original Message-----
> > From: Aby Mathew [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, January 27, 2000 6:09 PM
> > To: 'Ralph Cavallaro'; [EMAIL PROTECTED];
> > [EMAIL PROTECTED]
> > Subject: RE: [ND] Fw: [ND] Conversion from 3.11->4.1:data objects
> > lose tab le names.
> >
> > Not to worry at all.
> >
> > 1. Close the ND Studio.
> >
> > 2. Open the .sdo file for the data object in some editor (I
> can't help
> > commenting how good Emacs editor is), do a globale search
> and replace from
> > 'fin.' to 'FIN.'.
> >
> > 3. Open the Studio and edit the DataObject.
> >
> > That's it. It seems while Oralce is case-insensitive, the ND-Oracle
> > interface doesn't think so.
> >
> > Aby
> > TeamND
> >
> >
> > > -----Original Message-----
> > > From: Ralph Cavallaro [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, January 27, 2000 2:01 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: [ND] Fw: [ND] Conversion from 3.11->4.1:data
> objects lose
> > > table names.
> > >
> > >
> > >
> > > Has anyone ever solved this problem? I am
> > > having the same thing happen. Any help is
> > > deeply appreciated.
> > >
> > > >
> > > >>New Problem.
> > > >>I convert a project, but when I try to see the
> properties of a data
> > > >>object, I get this error:
> > > >>==============================
> > > >>A table referenced by this data object
> (fin.EMPLOYEE_INTERNET_VIEW)
> > > >>cannot be found in the data source. It has been removed
> > > from the data
> > > >>object..
> > > >>==============================
> > > >>followed by messages for all the other tables that data
> source uses.
> > > >>Then the properties dialog comes up, and the tables are
> > > cleared out of
> > > >>the table tab. If I reselect the tables, and then go look
> > > at the columns
> > > >>tab, all the right columns are there, even some of the
> > > computed fields.
> > > >>Unfortunately the where clauses and joins are still wiped
> > > out and need
> > > >>to be rebuilt.
> > > >>
> > > >>Has anyone else seen this? Is their a cure?
> > > >>
> > > >>
> > > >>
> > > >>John Hoskins
> > > >>TDS Computing Services
> > > >>Internet Technology Team
> > > >>[EMAIL PROTECTED]
> > > >>608.664.8263
> > > >>608.664.8288 (fax)
> > > >>
> > > >>
> > > >>
> > > >>____________________________________________________________
> > > _____________
> > > >>
> > > >>Helpful addresses for the forums...
> http://forums.netdynamics.com
> > >
> >>[EMAIL PROTECTED]
> > > >>[EMAIL PROTECTED]
> > > namics.com
> > > >>
> > > >
> > >
> > > ______________________________________________________________
> > > ___________
> > >
> > > For help in using, subscribing, and unsubscribing to the
> discussion
> > > forums, please go to:
> > > http://www.netdynamics.com/support/visitdevfor.> html
> > >
> > > For dire
> > > need help, email: [EMAIL PROTECTED]
> > >
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
