Thank you so much Olaf. . .
Your answer was exactly what I needed. I did not know if there was a compatible way of doing the same thing in Foxpro I was doing in C# ( [bigsmile] )
I will just write a different sql pass through for my foxpro process not using the user define table type in SQL...
Sorry for the lack of information.
The stored procedure is located in a SQL Server database.
I created by user defined table type in SQL Server
Create type myuserdefinedtabletype AS Table
(
Value1 as varchar(20),
Value2 as varchar(10),
Value3 as varchar(30)
)
The stored procedure...
I have a user defined table in sql which is the parameter I pass in a stored procedure.
Using C#, I create a datatable to match the structure and pass the datatable to the stored procedure.
Is this possible in Foxpro? How can I pass the a foxpro database/cursor to the same stored procedure...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.