Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing records from a cursor...
Message
From
21/09/1999 20:40:28
 
 
To
21/09/1999 10:32:14
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00267084
Message ID:
00267403
Views:
18
>I created a cursor to be used in a report built off of several files. Some records are basically not needed because several fields (8 to be exact) have 0.00 balances in them. The client would prefer these records not be listed. Right now, I have accomplished this by using the FOR statement in the REPORT call and listing a large list of record/field comparisons to exclude from the report (FOR begbal<>0.0 or endbal<>0.0...).
>
>Is there a way to remove records from a cursor after the SELECT statement created it?

You may reopen the cursor to make it read-write:

Select curReadonly
Use (dbf()) in 0 again alias curReadwrite
Use in curReadonly
Select curReadwrite

and now you may apply regular Delete command.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform