Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter table sometimes does not work
Message
From
24/04/2007 11:04:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Alter table sometimes does not work
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01219350
Message ID:
01219350
Views:
50
i have the following code which works sometimes and does not work at other times without giving any error.

set excl on
use tbsale2 in 0 excl
sele tbsale2
if type('tbsale2.ngroupname')='U'
alter table tbsale2 add ngroupname N(6)
endif

since it works sometimes i assume the code is correct, a read only on the table should give me an error, however i get no error and the field does not get added, i am a bit lost here, any suggestions?
Next
Reply
Map
View

Click here to load this message in the networking platform