Hello!
It has been a while since I created a new post myself, so here goes!
I am trying to create a new local system table, of which I have done dozens of times before, however I am getting a fun new error. The table is all set up in system tables just fine, however when I go to add a row, I get the error here:
"Last Error: DataWindow column type does not match GetItem type at line 7 in function of_get_nextid of object w_ref_tbl."
The table I am trying to create is pretty basic:
UP_POPULATE_REFERENCE_METADATA run just fine, updates in REFERENCE tables done. The only issue is in trying to add a column in Tessitura. I inserted one row via the database, worked just fine in the database, and everything looks good in Tessitura. I can edit the three columns, type anything in the name column, and choose whatever I want from the two dropdown columns which are pulling the correct information, save triggers for the last updates working just fine. But I still cannot add a new row without pulling that error. I in fact have multiple other local system tables set up using these exact columns, and they all work just fine. The only difference is that this one does not have an ID/Identity column, but there are plenty of system tables that do not have one of those.
Anyone got any ideas?
Thanks,
John
Try putting an identity column in there. Any difference?