Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refresh grid after insert to sql server table
Message
 
 
À
04/01/2004 23:16:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00863764
Message ID:
00863968
Vues:
8
irwan,

One fast way is to do a parallel insert into the VFP cursor that is being displayed in the grid:
SQLExec( ..., "insert into... )
insert into vfpcursor ...
thisform.grdX.Refresh()
A slower way is to repull the data back down from SQL, but then you have to clear the RecordSource of the grid to keep it from self destructing during the select and restore it afterwards. You can also use a seperate cursor that's zapped/appended to.

You could also use a RemoteView which would support a requery() operation.

>hi all, i've unsolve problem, how do i refresh my grid after i insert/update to sql server table, i've used =requery() but 'not support for sql pass-thru...'
>i've used mysql 3.51 as backend. thank's
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform