Cursor Field Name

Hi,
How do I replace a field name in a cursor without losing data?

Trey
Mon Jan 05 15:47:44 CST 2004

how do you mean "losing data" ?
how is the cursor created to begin with?
you could probably get around having to rename the column in the first
place...[maybe not, but worth a shot :)]

"Roger Cantillo" <rogerc@axiomsw.com> wrote in message
news:%23wTVCx80DHA.1660@TK2MSFTNGP09.phx.gbl...
> Hi,
> How do I replace a field name in a cursor without losing data?
>
>

Leemi
Mon Jan 05 16:56:13 CST 2004

Hi Roger:

>Hi,
>How do I replace a field name in a cursor without losing data?

Can you create a table with the same structure, APPEND the data from the
cursor, change the field name in the table, and then use a SQL-SELECT
command to recreate the original cursor?


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2000

Cindy
Mon Jan 05 20:53:24 CST 2004

In news: %23wTVCx80DHA.1660@TK2MSFTNGP09.phx.gbl,
Roger Cantillo <rogerc@axiomsw.com> wrote:
> How do I replace a field name in a cursor without losing data?

Hi Roger,

CREATE CURSOR Test (Field1 I, Field2 C(10))
ALTER TABLE Test ;
RENAME COLUMN Field1 TO HelloWorld

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Fred
Mon Jan 05 22:11:18 CST 2004

Renaming a field in a cursor to a long name (longer than 10 characters)
would not be recommended as you couldn't do it a second time if needed.

Fred
Microsoft Visual FoxPro MVP

"Cindy Winegarden" <cindy.winegarden@mvps.org> wrote in message
news:uVoCmFA1DHA.1188@TK2MSFTNGP11.phx.gbl...
> In news: %23wTVCx80DHA.1660@TK2MSFTNGP09.phx.gbl,
> Roger Cantillo <rogerc@axiomsw.com> wrote:
> > How do I replace a field name in a cursor without losing data?
>
> Hi Roger,
>
> CREATE CURSOR Test (Field1 I, Field2 C(10))
> ALTER TABLE Test ;
> RENAME COLUMN Field1 TO HelloWorld
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy.winegarden@mvps.org www.cindywinegarden.com
>
>
>