Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server and Foxpro
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01511584
Message ID:
01511598
Views:
73
>>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 ?
Previous
Reply
Map
View

Click here to load this message in the networking platform