Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server and Foxpro
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01511584
Message ID:
01511598
Vues:
74
>>Is it possible to call, into a SQL server stored procedure a stored procedure in a visual foxpro dbc ?
>
>What do you want to call from where?

I'll try to explain my problem:
I have a complex stored procedure in visual foxpro database.
I need to obtain the same result but using SQL server, because i have to access my fox tables from remote access.
So i have defined in a sql database some views on my fox tables using linked server.
The problem is that nonw i have to obtain data not from a simple table, but from some tables and some calculations i cannot easily remake in SQL, so i think to create a SP in my SQL server database and call a SP in visual foxpro DBC that make the elaboration and return the data i asked without making complex SP in sql server that i don't know well.......

Alternatively someone can suggest me where can i find examples on makin sp in sql server ?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform