Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Correct way to call DBC stored procedure
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523854
Message ID:
00524224
Views:
22
>>Create a local view in the dbc and requery that view when you need a new ID. Believe it or not, the following works for me:
>>
>>create sql view v_NextID as select lNextID(?cAlias) NextID from Kounters where Table_Name = ?cAlias
>
>Mark,
>
>This seems like a good approach and would ensure, that the correct SP is used. But it doesn't answer the second problem: should I use default value for Regions table or not.

If the Regions table is the ONLY table that causes this problem, then I would not use a default value. Just use the view I suggested for this table only. Otherwise, you would be back in same situation as you were before. I see no way where you can put a function call to a SP that has the same name as a SP in another DBC for your specific situation. As I see it, you either have to change the names of the SPs to be different or use the view I suggested.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform