Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Closing Cursor
Message
De
31/07/2008 07:03:57
 
 
À
31/07/2008 06:08:50
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
MS SQL Server
Divers
Thread ID:
01335447
Message ID:
01335452
Vues:
15
Usually you can just let it stay open, and reuse the name. However, if you must close it, this is the way:
Use in Curs1
>Hello comunity
>
>i have the following script on my client/server application :
> for ex.
>
>Local msel as string
>text to msel textmerge noshow
>select ref from st (nolock) where ref like '1%'
>endtext
>
>
>if u_sqlexec(msel,[Curs1]) then
>select Curs1
> if not eof() then
> replace st.fieldA with Curs1.ref
> endif
>endif
>
>I need a command to close Cursor Curs1 after commit transaction, what command i do use :
>CLOSE ALL, CLEAR.......??
>
>Many thanks
>Luis Santos
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform