Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dropdown List Box and SQL Cursor Table
Message
From
27/06/1997 19:27:27
Linda Morgan
Garden City Community College
Garden City, Kansas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Dropdown List Box and SQL Cursor Table
Miscellaneous
Thread ID:
00037955
Message ID:
00037955
Views:
68
Using VFP 5.0
I have a dropdown list box which is populated with an SQL statement sent to a cursor table. This drop down box value is not tied to any source. table. It's function is to locate record information and populate several other txtboxes on the form. Is there any way to "refresh" the cursor table for subsequent adding records or editing records.

When I run the form, add a new record (using the dropdown list to interactively copy data to several txtboxes) everything works fine. If I add or edit a subsequent record, the dropdown list (populated by the cursor table) points to the same record that I used before. The incremental search doesn't work. The only way I can use the same record is to down arrow in the combobox and then uparrow at which point it will now accept the same record. Not what I want to do.

Thanks in advance

Linda
Next
Reply
Map
View

Click here to load this message in the networking platform