Thank you very much Ed,,
there it is..
Mark
>Any read-only cursor can be converted to read-write one programmatically and subsequently its structure can be changed:
>Select MyField From MyTable Into Cursor tmpReadonly NOFILTER
>cDbf=dbf()
>Select 0
>Use (cDbf) AGAIN ALIAS tmpReadWrite
>Use In tmpReadonly
>Alter Table tmpReadWrite Add Column MyNewField C(10)
>
>>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
>>
>>>Hi 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...
>>>
>>>It is possible, but I wouldn't do it. With the SELECT statement you can create exactly the table you want. What kind of manipulation are you trying to do?
>>>
>>>Christof
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only