Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
1707 Error using ALTER TABLE
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01347518
Message ID:
01347519
Views:
15
As a follow up, I tried this and the TRY/CATCH causes the ALTER TABLE to fail in the same way that having an ON ERROR routine enabled. I'm stumped.
        lcWasOnErr = ON("ERROR")
        TRY 
          ON ERROR
          ALTER TABLE myCursor ADD COLUMN NewField C(10) 
          ON ERROR &lcWasOnErr.
          =MessageBox(lcAlias + ": Added field '" + lcField + "' .")
        CATCH
          ON ERROR &lcWasOnErr.
          =MessageBox("*ERR* Failed to add field")
        ENDTRY 
Previous
Reply
Map
View

Click here to load this message in the networking platform