dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Update View / Cursor

  1. #1
    Paul Summerfield Guest

    Update View / Cursor


    I have a select criteria for a user from here I make a cursor, and run all
    the reports they need, but when they have finished all there reports, I need
    to update the records to show the reports have been generated

    SELECT Patient_details.pd_pk, Patient_details.pd_title,;
    Patient_details.pd_firstname, Patient_details.pd_surname,;
    Patient_details.pd_address, Patient_details.pd_street,;
    Patient_details.pd_town, Patient_details.pd_county,;
    Patient_details.pd_zip;
    FROM op!Patient_details;
    &LcFilter;
    INTO CURSOR Addresslist

    How can I accomplish this? Would I compare the cursor to the table, if so
    how?

    Or instead of making a Cursor can / should I make an updateable view, if
    so how?

    Many thanks

    Paul


  2. #2
    Cindy Winegarden Guest

    Re: Update View / Cursor

    Hi Paul,

    You haven't said which fields you will be updating and what values you will
    use. Ultimately, nothing changes in your report cursor so you should be able
    to use the same filtering criteria as you did in your SELECT statement.

    Using an updatable view for your reports would also work.

    --
    Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
    cindy.winegarden@mvps.org, www.cindywinegarden.com

    "Paul Summerfield" <foxpo@quantumistic.co.uk> wrote in message
    news:3f140352$1@tnews.web.devx.com...
    >
    > I have a select criteria for a user from here I make a cursor, and run all
    > the reports they need, but when they have finished all there reports, I

    need
    > to update the records to show the reports have been generated
    >
    > SELECT Patient_details.pd_pk, Patient_details.pd_title,;
    > Patient_details.pd_firstname, Patient_details.pd_surname,;
    > Patient_details.pd_address, Patient_details.pd_street,;
    > Patient_details.pd_town, Patient_details.pd_county,;
    > Patient_details.pd_zip;
    > FROM op!Patient_details;
    > &LcFilter;
    > INTO CURSOR Addresslist
    >
    > How can I accomplish this? Would I compare the cursor to the table, if so
    > how?
    >
    > Or instead of making a Cursor can / should I make an updateable view, if
    > so how?




  3. #3
    Tamar E. Granor Guest

    Re: Update View / Cursor

    On 15 Jul 2003 06:36:18 -0700, "Paul Summerfield"
    <foxpo@quantumistic.co.uk> wrote:

    >
    >I have a select criteria for a user from here I make a cursor, and run all
    >the reports they need, but when they have finished all there reports, I need
    >to update the records to show the reports have been generated
    >


    If you're in VFP 8, take a look at the SYS(2040) function, which tells
    you whether a printed is previewed or printed. It gives you a way to
    be sure you've actually printed the report.

    Tamar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center