Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select into cursor question??
Message
From
08/01/1999 11:46:12
 
 
To
08/01/1999 11:36:34
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00173861
Message ID:
00174061
Views:
32
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
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform