Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE on SPT Created Cursor..
Message
From
06/08/2002 04:00:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
ALTER TABLE on SPT Created Cursor..
Miscellaneous
Thread ID:
00686490
Message ID:
00686490
Views:
84
On the following code example in VFP7...

SQLEXEC(h,'select * from ARTICLE',"XXX")
ALTER TABLE XXX ADD &cPicGname g(4)

I get "Function is not supported on remote tables (Error 1525)"

What's the easiest way to add the column to the table?
Note that I have an additional consideration in that I may need
to add one to ten columns and the cursor could sometimes be very large
so a select is not the best.

I was hoping for something like:
USE DBF("XXX") AGAIN IN 0 ALIAS yyy
ALTER TABLE yyy ADD &cPicGname g(4)


BR
Tim
Next
Reply
Map
View

Click here to load this message in the networking platform