Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server SP treat like a RV?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Server SP treat like a RV?
Miscellaneous
Thread ID:
00758958
Message ID:
00758958
Views:
46
I have a function call that I need to denormalize data in a separate table.

I now have that as a SP that I want to call like :
exec dbo.depIndxPage ?vp_page


CREATE PROCEDURE dbo.depIndxPage
@page varchar(15)
AS
select dbo.GetTeeth(pi_applpg) as label , dbo.depindx.*
from dbo.depindx
GO


I will get from 1 -> 1000 rows back.

I want to use this like a NON UPDATEABLE view. Do I create a method in a bizobject for this repeat call like a requery() or is there a better way to implement this?
Next
Reply
Map
View

Click here to load this message in the networking platform