Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Murali Narayanan
  Where is Murali Narayanan?
 Mumbai
 India
 Murali Narayanan
 Tags
Subject: RE: multiple if commands in report
Thread ID: 416071 Message ID: 416089 # Views: 55 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Sunday, December 21, 2014 7:49:29 AM         
   


> Thank you Jun,
> I have not tried to create a cursor before as I always thought that cursor was associated with SQL
> and I am using native tables.
> Icase works well in this instance, thank you for your trouble.
> regards
> Murali Narayan
>
> >
> > Aside from the ICASE() inside the report as shown by Tore, why not create a cursor where that Icase() result is a field of the cursor? Then use cursor on your report
> >
> > https://vfpx.codeplex.com/releases/view/99045
> > http://sandstorm36.blogspot.com

No it is not associated with SQL backend. You can create any cursor out of one or more native tables.

You should try using one instead of working directly with those tables just for reporting purposes.

https://vfpx.codeplex.com/releases/view/99045
http://sandstorm36.blogspot.com

ENTIRE THREAD

multiple if commands in report Posted by Murali Narayan @ 12/20/2014 5:01:53 PM
RE: multiple if commands in report Posted by Tore Bleken @ 12/20/2014 5:17:10 PM
RE: multiple if commands in report Posted by Murali Narayan @ 12/21/2014 5:20:44 AM
RE: multiple if commands in report Posted by Ali Koumaiha @ 12/23/2014 7:25:07 PM
RE: multiple if commands in report Posted by Jun Tangunan @ 12/21/2014 4:01:03 AM
RE: multiple if commands in report Posted by Murali Narayan @ 12/21/2014 5:23:19 AM
RE: multiple if commands in report Posted by Jun Tangunan @ 12/21/2014 7:49:29 AM