Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server SP treat like a RV?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Server SP treat like a RV?
Divers
Thread ID:
00758958
Message ID:
00758958
Vues:
54
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform