Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Closing Cursor
Message
From
31/07/2008 07:03:57
 
 
To
31/07/2008 06:08:50
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
MS SQL Server
Miscellaneous
Thread ID:
01335447
Message ID:
01335452
Views:
16
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform