Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 6.0 sql select to cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00340471
Message ID:
00340472
Views:
21
Yes you can, but it take another line of code.

Try Use DBF('yourcursorname') IN 0 AGAIN ALIAS newcursorname

HTH
Jeff

>Hello Everyone,
>
>Is it possible to use a sql select to create a cursor and then do a replace in a field in the cursor. I tried this as below but get a 'CANNOT UPDATE THE CURSOR' error message.
>
>
>select name, section from tablename into cursor mycursor
>select mycursor
>replace all section with "A" for section = "V"
>
>I only want to change the values in the cursor, not the original table, and I intend to use the cursor for a report form.
>
>Can anyone help me with this issue?
>
>Thanks,
>
>Jim Harvey
>jharvey@netrax.net

It's Time to get a gun.

That's what I've been thinkin.

I think I can afford one, If I do a little less Drinkin.

www.TrueGeeks.com
Previous
Reply
Map
View

Click here to load this message in the networking platform