Using Stored Procedure in Sql Server for FoxPro Table.

Please discuss general Delphi programming topics here.

Using Stored Procedure in Sql Server for FoxPro Table.

Postby ZarrinPour » December 28th, 2003, 6:47 pm

Hi all,
I want to know, Is it possible to write a Stored-Procedure in SQl Server that can be apply on one .DBF table on my computer.?
In the other hand suppose we have a stored procedure for inserting one record to Sql's tables,now i want to use this stored procedure for inserting one record to a FoxPro(.DBF) table that is in "d:\MyFoxTable" directory.Note that Sql tables and Foxpro table are the same ( field type , number of fields & etc..). Is it possible such operation.? for example my Insert stored procedure is :
/////////////////////////////////////////////////////////////////////////////////////
CREATE procedure sp_InsertStd
@StdNo char(9),
@StdName varchar(20),
@StdFamil varchar(30)
As
insert into Student(StdNo,StdName,StdFamil) values(@StdNo,@StdName,@StdFamil)
GO
/////////////////////////////////////////////////////////////////////////////////////
IF i can do this ,how should i change the above stored procedure to achieve this effect.?

Thanks.
ZarrinPour
Active Member
Active Member
 
Posts: 12
Joined: September 28th, 2003, 5:50 pm

Postby Kambiz » January 7th, 2004, 6:27 pm

Desktop databases do not support the stored procedures.
User avatar
Kambiz
Administrator
Administrator
 
Posts: 2429
Joined: March 7th, 2003, 7:10 pm


Return to Delphi Programming

Who is online

Users browsing this forum: No registered users and 19 guests

cron