Does anyone know how to add a column to an sqlite database through the sqlite utility interface. I tried the SQL statement , ALTER TABLE table Name ADD column variable, and it did not work. Anyone know any other way? Thanks Steve
Shum [Ming Yik] wrote: >Hi, > >I would like to ask ...: > >1.) Add dummy DTOS() ... and other functions into SQLite >So that perform same syntax with other SQLs... > >ie.: SELECT * mytable where DTOS(TSTDATE)>='20050101' ... > >Shum >www.mingyik.com > > > >