Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE on SQL Select cursor
Message
 
 
To
06/12/2002 14:17:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00730441
Message ID:
00730453
Views:
16
In VFP7 ALTER TABLE doesn't work on cursors with field names longer than 10 characters.

>In the tips in the back of the Sept 2002 UT magazine :
>
>Sometimes, you may want to add some fields to a cursor. Assuming, you have created your cursor in READWRITE mode, you could do the following:
>
>ALTER TABLE 'temp' ADD COLUMN cImage c(20)
>
>Since this mentions readwrite I assume it refers to a cursor created with a SQL Select
>
>SELECT ccompany FROM cutomer INTO CURSOR temp READWRITE
>ALTER TABLE 'temp' ADD COLUMN url m
>
>When I do this I get an 'Invalid operation for the cursor' message.
>
>I was hoping this would be a shortcut around the old dummy cursor Cartesian join trick. What am I missing?
>
>TIA
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform