Re: SQL Cursors

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: kd (kd_at_discussions.microsoft.com)
Date: 06/14/04 

Date: Sun, 13 Jun 2004 21:58:01 -0700

I want to select the first 5 records from the result set and display the values of the fields as button texts and then on a button click(caption "Next"), display the next 5 records and go on till all the records are displayed.

"Eric den Doop" wrote:

> Hello, kd!
>
> You don't to open an sql result cursor because it's already opened:
>
> SELECT fld1, fld2 ;
> FROM yourtables ;
> WHERE something = .T.
> INTO CURSOR result
> * loop through records
> SCAN
> * print fld1 and fld2 to active window
> ? result.fld1, result.fld2
> ENDSCAN
> * to display all records:
> BROWSE
>
> What exactly do you mean with "display them". Do you want to display the
> result set in a form with textboxes etc, or in a browse window? Or perhaps a
> report? Let us know if you need more help.
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>
>

Quantcast