Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor
Message
 
 
To
14/11/2002 08:12:34
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Re: Cursor
Miscellaneous
Thread ID:
00722615
Message ID:
00722621
Views:
21
Hi Emanoel,

You've a few choices (in no particular order):
1. Recreate cursor after updating remote table
2. Update the cursor in parallel with updating remote table
3. Make cursor updatable as shown in How to make SQL Pass-Through cursor updatable FAQ #8153.

>I´m using SQL Server 7 and VFP 7, How to for update the Cursor, for exemple:
>
>My cursor is:
>SQLEXEC(conection,"SELECT codigo,empres FROM empresa order by codigo","Cempresa")
>After, i'm updated my table,
>SQLEXEC(conexao,"UPDATE bd_juri..empresa SET empres=?wempresa WHERE codigo=?wcodigo")
>
>the table is updated, but tue cursor no
>
>How to?
>
>Thank's
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform