Connecting

[Chris Kelleher]

Hello,

Due to cheap bean counters, our applications connects
and disconnects from our different databases when it
needs them. Due to cheap programmers, we did not
qualify all references with database names.

If we let RTB connect to all databases, code will not
compile becuase of ambiguous table references. I
blanked out the connection parameters and modifed the
"more" menu so that we can choose our own connections.


Since the programs that reference each database are in
specific workspace modules, is there any way to make
RTB V8.1a UNIX programatically connect to the correct
database(s) at compile time??

Thanks,
Ed

=====

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

 

[Chris Kelleher]

Ed,

In the latest version of Roundtable (8.3+) there are some hooks that would
give you the ability to solve your problem. The before compile hook would
allow you to take control and determine which databases needed to be
connected and then connect or disconnect accordingly. You could then return
control back to the compiler to do the work. The other feature that could
help is the external compiler, it is another session running on the server
machine and it does all of the compiling for the system. That could be
customized to change the list of connected databases before compile. Both
ways are going to require some programming on your part however. I suspect
you could solve your problem using either technique.

HTH

Good Luck.

Nathan Noll (817) 284-8680
NCS Fax (800) 538-7510
Certified Roundtable Consultants nathan@nollc.com

Check out F1 an integrated Change Request System that works
with Roundtable! www.nollc.com/f1