Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it good practice to create temporary dbfs then ....
Message
From
05/01/2006 10:56:58
 
 
To
05/01/2006 10:34:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01082941
Message ID:
01083567
Views:
14
>Why would you want to alter the stucture of the cursor? You should have built it correctly in the first place, since it is a cursor. You probable want to alter the data in the cursor.
>>
>>Uless your code will ALTER TABLE on the cursor, in which case the 10 character field name limit does come into play.

You may need to change the structure of the cursor, if the cursor is created by a SQL Select statement. For instance I often do like this
Select * From xx into cursor curdummy readwrite
Alter table curdummy add column newmemo m
This is much easier than listing all the fields in combination with Cast.
Previous
Reply
Map
View

Click here to load this message in the networking platform