I would like to create an operational notes page where the distribution system operator can type in information like pump out of service and save the text so that it can be displayed on any client system. Is this possible?
Sure, this sort of thing is pretty common. You just set up a database table to hold the notes (maybe something like:
CREATE TABLE OperationNotes (
NoteId INTEGER AUTO_INCREMENT,
T_Stamp DATETIME NOT NULL,
Note MEDIUMTEXT NOT NULL)
(this is for MySQL)
And then you’d just make a screen to add/edit/view notes, using basic SQL bindings and the TextArea component. Check out the “Wiki”-style help of the demo project for some more inspiration.
When I try to create the table in MySQL I get this error.
Incorrect table definition; there can be only one auto column and it must be defined as a key
add a “PRIMARY KEY” clause onto that first column.