Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Correct way to call DBC stored procedure
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00523854
Message ID:
00524224
Vues:
23
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform