Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dropdown List Box and SQL Cursor Table
Message
 
À
27/06/1997 19:27:27
Linda Morgan
Garden City Community College
Garden City, Kansas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00037955
Message ID:
00037956
Vues:
31
>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.

Probably you can use a view instead of cursor and issue =REQUERY()to refresh it (and REQUERY() method for the listbox).

> 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

Probably you can use a view instead of cursor and issue =REQUERY()to refresh it (and REQUERY() method for the listbox).

About second part, I didn't completely understand in which area you are adding or edit records and how it refers to that listbox RowSource cursor.
Could you provide more details?

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform