Re: SQL Cursors

From: Eric den Doop (ericdendoop_at_xspamblockxfoxite.com)
Date: 06/13/04 

Date: Sun, 13 Jun 2004 17:30:43 +0200

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

Relevant Pages

  • RGB Color Balance
    ... I am writing a display driver for Windows Ce 5.0. ... // init cursor related vars ... // check for line overlap with cursor and turn off cursor if overlaps ...
    (microsoft.public.windowsce.platbuilder)
  • Re: How to show/hide cursor on attach/deattach usb mouse
    ... Along with that Display Driver is modified with RequestDeviceNotifications, ... and switching on/off the cursor. ... handling USB mouse device notifications. ...
    (microsoft.public.windowsce.platbuilder)
  • Re: General structure of disassembler
    ... 'regular' comments on source should display to the right of the ... He can move the cursor up and down and left and right in this text ... So does it when he moves to absolute source offset #0. ... In this scenario the root leaf ALWAYS holds ...
    (comp.programming)
  • Re: Another Castalia 5/Delphi 2007 preview video
    ... Finally, add an option at the top of the class combo for classless methods and all methods, which would then display those. ... When you press ESC to go back to the bookmark, it's hard to see where the cursor is. ... Some of these request may seem similar to those of another product, but let's face it, Castillia lives in the shadow of CodeRush. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How to show/hide cursor on attach/deattach usb mouse
    ... It should be obvious that the answer to that depends on the display driver. ... There's no 'enable/disable cursor here' function. ... that receive notifications and use ShowCursor....it works ?? ...
    (microsoft.public.windowsce.platbuilder)