Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
All fields except one match key selected with combolist
Message
De
10/08/1999 14:09:13
 
 
À
09/08/1999 21:16:07
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00251721
Message ID:
00252117
Vues:
12
>David-
>
>Is there only one table involved? More? Relations? A parameterized view? Is the errant textbox showing the next or last record?

There are two tables. The primary table is the work order table. There is an operation table (two field table that maps operation codes to operation descriptions). The work order table is related to the operation table with an opcode field. I use this in a combolist to allow the user to select from a list of options that may apply to a work order. I also have a combolist that selects from an array of text options to fill one of the workorder fields. (Three combolists, the primary keylist and two that select values for specified fields).

No parameterized view.

The errant textbox seems to be showing the next record (where next is determined by the index order of the table).

Everthing about the tables is set up in the DE except that I do not autoopen the tables. This is so that I can specify the database to be used at run time.
In the LOAD I set the table's cursor's DB to my.dbc then fire the DE.opentables.

>
>What is your refresh code?
LOCAL lcproc
lcproc = SET("procedure")
SET PROCEDURE TO UTILS.PRG ADDITIVE    &&contains ibox udf

dodefault()

THISFORM.txtqtyinproc.valid           &&set color of txtbox depending on value
THISFORM.txtihcdate.valid             &&set color of txtbox depending on value

IF alltrim(THISFORM.txtcomment.value) <> alltrim(wojrn.comment)
	ibox("Houston, we have a problem")  &&trap for 'the problem'
ENDIF

SET PROCEDURE TO &lcproc
>
>Is the rowsource for the CBO the same as the source for the textboxes?

If you mean is the rowsource for the CBO the same as the controlsource for the textboxes the answer is yes, same alias. However, the rowsource only specifies the key field.

I notice that the interactivechange event does not fire when I use an ENTER while the combo's text field is selected, and this is the only event in which I force a refresh. I guess I could put a refresh in the programmatic change event though as far know, I can only change the combo's value interactively.
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform