Thanks guys for your replys,, for a moment I thought I saw a posting
in wich you can actually do the Modi Struc for a View cursor,,
but I think is different.
What I wanted to do is,that usually I work with large tables for diff
projects and certain fields (not all the fields) for example,
name, address , city state zip dpb fields need to be formated in a specific
format for BuscroEktajet machines for Bulk Mail processing and I tough
if I created a cursor with the req fields and then add some temp ones
then most of the formating routines will run wayyy faster in memory rather
than I/O process in the original table.
that's all, some of my tables are about 1.5M records and 500,00 recds

thanks
Mark


>>>>>I think someone ask this before , but once you get your cursor
>>>>>after a " Select fields, into cursor Mycursorx', can I change
>>>>>that cursor (Mycursor) structure somehow, or it is Read-Only
>>>>>always...
>>>>>
>>>>>Mark Oliva
>>>>
>>>>Mark,
>>>>
>>>>Before you select into your cursor, create the cursor with CREATE CURSOR... The cursor will then be read/write. I have never tried modifying the structure of of cursor after it is created, but I see no reason you could not.
>>>>
>>>>regards,
>>>
>>>Any time you SELECT...INTO CURSOR, the resulting cursor is read-only, no matter what you do before hand. You can fake it out by USE DBF('thatcursor') ALIAS rwcursor into making a R/W cursor. Your SELECT statement must not be a "filtered-view" so use the NOFILTER clause in your SELECT.
>>
>>Fred,
>>
>>you're right. I was thinking of views. Oh well.
>>
>>regards,
>
>Jim, no problem. At first I thought you had a neat trick to create a R/W SQL cursor. I'm always looking for new thingies to try, especially if they solve some sort of thorny problem!