Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo display incorrect for first record in grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00046859
Message ID:
00048008
Vues:
25
>>Greetings. I am having some difficulty getting the first record in a grid to display properly. All columns are ok except for the one that contains a combo box. This column is blank. All columns in records two through four display properly.
>>
>>Has anyone seen behaviour like this? Thank you.
>
>Hi Mark,
>
> I have seen behaviour like this quite often, but for me was related to using relations. I found that the relations would get out of sync at some point during the creation of the form and it only recovered once it updated the second record in the browse. My patch was to SELECT the related table and then select back to the main table in the refresh of the form and that resolved the problem partially.
>
>I have found a definite culprite for messing up relations. If you have a view in your data environment that is loaded with NODATA it will desyncrhonized relationships on tables that make up the view.
>
>Hope this helps a bit. Let us know if you find a solution.
>
>Darrel

Correction, for posterities sake. My previous reply to Darrel's reply was incorrect.

The fix I found was to select the grid's view, skip forward one record, skip back a record, then refresh the grid. This seems to re-establish relationships and display look-up descriptions properly.

As for the first record, I can't remember exactly, but you may have to actually perform a seek on the child table after the aforementioned skipping to set the record pointer to the correct description. I guess you will have to do this for each linked lookup table.
----------
Mark Bucciarelli
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform