BusinessObjects Board

High volume update to join syntax?

sdk development
#1

Hi Dwayne, I use this spreadsheet VERY OFTEN and I appreciate it so, much, it has saved me a ton of work. I have a new problem that I’m hoping for a solution to. I have an ORACLE universe that uses a function in about 700 joins. This is a sample of the join sql:

CARRIER.CODE_ID=CLAIM.CARRIER and
CARRIER.CODEFLD_ID =GetCodeFieldId('STR.Clm', 'Carrier')

We have 2 environments for different types of clients, ORACLE and SQL Server. The table structure is the same for both database types. I am dealing with the Oracle/SQL Server function differences and that is managable. However, in the SQL Server database the function is prefixed with the owner. Is there a way to change this without opening every single join?

Thanks in advance…
D’Ann

{moderator note … split off from the referenced BOB Downloads posting into its own thread … dwayne}

djenkins (BOB member since 2002-12-12)

#2

I haven’t tested it, but a similar technique should work. Say, dump the existing join syntax in column A, and update the syntax in column B. Make the updates with something like the following:

Univ.Joins(Rng.Cells(RowNum,1)) = Rng.Cells(RowNum,2)

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)