General information
Category:
Coding, syntax & commands
Title:
ALTER TABLE on SPT Created Cursor..
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only