FiveTech Support Forums

Hey,

Every couple of day, while my program grows, I have to change (add) more fields into the online database

Now I go into my phpMyadmin and change the structure and continue.
I've seen that there are functions to change it from FWH.

What approach do you mostly take ?

Hi Marc

Sorry for my bad english, i use this code for add columns

if fieldpos("c_emdirec") < 1
gci_sqlexe("ALTER TABLE gci_empresas ADD c_emdirec CHAR(60) DEFAULT '' NOT NULL AFTER c_emname2")
gci_sqlexe("ALTER TABLE vcnewbos ADD tas_detrac NUMERIC(5,2) DEFAULT '0.00' NOT NULL AFTER des_newbos")
end if

if you need change colums this code :

        if len(cdo_cuenta) == 12
           gci_sqlexe("ALTER TABLE vcpatpcg MODIFY cdo_cuenta CHAR(14) DEFAULT '' NOT NULL")
        end if

gci_sqlexe is my function to invoke mysql in ADO or TDolphin maybe have other names

Exactly what I needed. Thanks all.