Hello,

I was wondering if someone out there has ever dynamically changed the schema
name for datafields for a dataobject.  Currently, we have an existing
project that we've recently migrated to ND 5x.  The existing datasource
(Oracle db) is set with the "SYSTEM" (e.g.) schema- i.e. StudioUserId,
RuntimeUserID, StudioDBOwner and RuntimeDBOwnder are all set to "SYSTEM". 

So, the existing datafields in the data objects all reference "SYSTEM".
Because of the DB changes, our schema will change to, let's say, "SYS". Is
there a way to dynamically change the schema name for the datafields without
having to go to each individual .sdo file and manually changing all
occurrences in the TableName, OwnerName and Tables attributes?

I suppose a good start would be to get a handle to the dataobject.  I did
find the method, _replaceOwnerNameDynamically in
spider.database.CSpDataObject.  Has anyone tried this before? How would one
change the schema name in the TableName and Tables settings?

Any suggestions would be appreciated.

TIA :)

_________________________________________________________________________

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]

Reply via email to