Ok, do you tink that you should set up that SPT in the load event for the GUI? Or do you make a SPT class to pass it all through and drop that on the GUI for reuse?

I see this more as a resuable class so I guess that I'll go along that route.

__Stephen

>You can't call an SP from a view. YOu'll need to use SQL Passthrough.
>
>
>>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?