General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
Look what i figured out. I dont understand why this works, but it does
*If I add the first field with the code ALTER TABLE ALIAS(m_alias)
*I can then add the rest fields with ALTER TABLE DBF(m_alias)
IF UPPER(m_alias)="SMFALIAS"
&& executing from program 1
ALTER TABLE ALIAS(m_alias) ADD COLUMN age c(4)
ELSE
&& executing from program 2
ALTER TABLE DBF(m_alias) ADD COLUMN age c(4)
ENDIF
*intersting why does the code DBF() work now from both programs
ALTER TABLE DBF(m_alias) ADD COLUMN room c(4)
ALTER TABLE DBF(m_alias) ADD COLUMN FIRSTE c(25)
ALTER TABLE DBF(m_alias) ADD COLUMN firsth c(25)
ALTER TABLE DBF(m_alias) ADD COLUMN lasth c(30)
Now I changed it as one of you told me to
I dont know why the code was written this way, its pretty old code.
I changed it to
ALTER TABLE (m_alias) ADD COLUMN age c(4)
ALTER TABLE (m_alias) ADD COLUMN room c(4)
ALTER TABLE (m_alias) ADD COLUMN FIRSTE c(25)
ALTER TABLE (m_alias) ADD COLUMN firsth c(25)
ALTER TABLE (m_alias) ADD COLUMN lasth c(30)
and everything is working now
Previous
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