How to add one more colum?

Hello everyone, how can i add one more column called “delivery date” on this existing table?

Please help,

Thank you very much

You need to do this in to your database, not via Ignition (though you may be able to run an alter table with a system.db.runUpdateStatement - never tried).

In your SQL Workbench you’d write sometthing like ALTER TABLE joblist ADD COLUMN devlivery_date datetime; Some syntax may change depending on your particular SQL flavor and what constraints you want.

1 Like