Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQL select into cursor
Message
From
29/07/1999 18:35:52
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Problem with SQL select into cursor
Miscellaneous
Thread ID:
00247995
Message ID:
00247995
Views:
67
I have a page frame with 2 pages. Page 1 contains some fields the user enters. Page 2 contains a grid. On page 1 the user sets some parameters and can then view the results on the grid on page 2. There are two sql statements. The first creates a table and sets the recordsource of the grid to that table. The user can then view it. The user can then come back to page one and set further parameters. A second SQL is executed which creates a cursor. The cursor is then set as the recordsource for the grid. When the SQL is executed the cursor has a subset of the records in the table. However, when the grid is viewed, it is populated with the entire base table,even thought the cursor is still selected. What am I doing wrong?
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
Next
Reply
Map
View

Click here to load this message in the networking platform