Hello, I'm working on a project and I need to create a a edit table. People right now fill a table on excel, but we want to build this table on Ignition Perspective and of course save this information on a DB. At this moment I have a table which is the one that I will use to save and watch the information at the table on ignition, but at the beginning the table on the DB is empty, and I try to put it on the table but I can't even watch the columns. Why this happend and how can i solve this???
Of course the DB is empty if you haven't inserted any rows yet.
I'm not sure what "watch the columns" means.
Have you created the columns in the database table yet?
Hello!
1st. you should create a named query
2nd. connect it to your database and write the query
3rd. add a binding to your props.data of the table (little chain icon on left of data)
4th. add the path to your previous created named query
and you got it.
No, first you should create the database table.
Did you mean the column headers didn't show up on the table? Perspective table requires at least one row of data to show the column headers. If you already have a database table and a named query that's pulling data from it, you might want to either add a row in the database table first or add a transform to your perspective table binding to add an empty row if there's nothing in your database table initially.
Yeah, thank you so much. I add some information at the Database, then the columns showed up