Add a field to an existing table?
Add a field to an existing table?
Is it possible to use LiteTable component to add a field - like is seen in the demo for VirtualTable?
Re: Add a field to an existing table?
Do you need to add a new TField class to the dataset or a new field to the SQLite table?
Re: Add a field to an existing table?
I need to add the field to the SQLite table. I know how to do it via "ALTER TABLE", so can go that route if can't be done by calling a procedure in the TLiteTable component.
Re: Add a field to an existing table?
TLiteTable is a descendant of the standard class TDataSet, which provides access to data and is not intended to modify database schema. To add a new column to an existing table, use the statement ALTER TABLE ADD COLUMN
Re: Add a field to an existing table?
Thanks Maxim! That is the route I had taken. Think I understand why TVirtualtable has .AddField but TLiteTable does not.
Re: Add a field to an existing table?
Please don't hesitate to contact us with questions concerning our product usage.