Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement