Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid becomes blank after a tableupdate
Message
De
05/03/2002 10:01:04
 
 
À
05/03/2002 09:53:51
Anthony Yates
Great Lakes Solutions, Inc.
Grand Rapids, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00628120
Message ID:
00628394
Vues:
21
Does your grid match all of the criteria listed below.

1. Is based on a cursor.
2. The cursor gets reset by a sql-select statement.

I have also had to save the recordsource to a variable, change it to point to a dummy cursor, perform all the necessary updates, change the recordsource back to the correct cursor, and then fix all of the columns, headers, etc.

Not the best answer, I know, but I haven't found a better way. Perhaps someone else will weigh in.

>The "go top" and refresh the grid did not do it.
>
>But I did come across this: It works, but the wrong data appears in the grid.
>
>
>PRB: Cursor-Based Grid Goes Blank If SQL SELECT Resets Cursor
>
>SYMPTOMS
>If a grid's RecordSource property is set to a cursor, and then the SQL SELECT command resets the cursor, the grid appears blank if the RecordSource property is not set back to itself.
>
>The following command will refresh the grid properly if a SQL SELECT is run to rebuild the cursor, but if the grid's column or header properties have been customized, these customized changes will be lost and the grid's column and header properties will change back to their default settings:
>
> THISFORM.GRID1.RECORDSOURCE=THISFORM.GRID1.RECORDSOURCE
Brian McCord
President
Sagacity Systems
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform