Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding column to a cursor based on SQL table?
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Adding column to a cursor based on SQL table?
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01536972
Message ID:
01536972
Views:
85
Hi,

I never had a problem with the following code when working with the VFP database. But I get error with the SQL Server
*-- I get a cursor C_TBLFROMSQL from a table in SQL or VFP (code not shown)
*-- In this case (the problem) the table is in SQL Server

select C_TBLFROMSQL
local array aDbfStruct[1]
afields( aDbfStruct )

create cursor EMPL_WO from array aDbfStruct

*!!!!-- I get error on the following ALTER TABLE line
alter table EMPL_WO add column SORT_ORD N(6,0)
Is the problem on the ALTER TABLE .. ADD COLUMN because VFP does not allow changing structure of the cursor created based on SQL server table?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Next
Reply
Map
View

Click here to load this message in the networking platform