Access a Stored Procedure in Another Database

[dkediger]

VFP 6:

Have an inherited project I'm working on. There are two main databases, each with a stored procedure called NEWID that is used for grabbing the last used ID from an ID table in the respective DBC, incrementing by 1, and returning that value.

The ID tables in each DBC contain different sets of ID counters.

My problem is that I'm needing to grab an ID from the DBC that is not open and used.

Is there a way to access the stored procedure in the not active DBC without interfereing with the currently open DBC?

 

[rgbean]

No. The DBC must be open to access anything in it - whether data or SPs.

Rick

 

[dkediger]

Thanks for the reply!

I've programmed in a conditional section in the active DBC to get my ID, but is there a way when calling the "function" from code to specify which DBC it is in, or is this just a limitation?

 

[rgbean]

What you need to do is set the current database to the one you want. See the Help for SET DATABASE TO.

Rick

 

[dkediger]

Will Do - Thanks!