Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: Frank Cazabon
  Where is Frank Cazabon?
 
 Trinidad And Tobago
 Frank Cazabon
 Tags
Subject: RE: Multiple Detail Bands and SQL Server
Thread ID: 112412 Message ID: 112593 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, November 09, 2006 10:22:13 PM         
   


> Hi John,
>
> I haven't worked with views in ages, but can't you create indexes on them? I'm sure I used to.
>


Yes, you can create index tags for views, as long as they're in row buffered mode. But it looks like John's problem is that he's using a parameterized view, so he only has a subset of the records for the report at any point.


-BP
www.peisch.com

ENTIRE THREAD

Multiple Detail Bands and SQL Server Posted by John Jarman @ 11/8/2006 10:51:10 AM
RE: Multiple Detail Bands and SQL Server Posted by Barbara Peisch @ 11/8/2006 8:27:50 PM
RE: Multiple Detail Bands and SQL Server Posted by John Jarman @ 11/9/2006 10:24:26 AM
RE: Multiple Detail Bands and SQL Server Posted by Frank Cazabon @ 11/9/2006 2:45:18 PM
RE: Multiple Detail Bands and SQL Server Posted by Barbara Peisch @ 11/9/2006 10:22:13 PM
RE: Multiple Detail Bands and SQL Server Posted by Barbara Peisch @ 11/9/2006 7:18:31 PM