InfoMaker Shenanigans

I think what you are seeing is a mismatch between the column specifications and the underlying SQL Query/Stored Procedure.  Check that the version of the datawindow you are working on is the same version you see in the application.  Also, check that the SQL Query is what you expect, and I would check the order of the columns.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Thursday, March 31, 2011 11:07 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] InfoMaker Shenanigans

Generally speaking, I have created a custom tab screen using InfoMaker 10.5 and have since changed it to suit Development's needs with relatively little problem.

However, this time, I've added new fields to the table that feeds the custom tab, which works fine in every respect, except that one field doesn't show the data in the the associated column for the current member record, but some sort of total.  It's not a total of all of the records for that column, mind you, but some sort of negative number nowhere near what it's supposed to be.  Consequently, when someone tries to edit the custom tab, they get an error because Tessitura insists on writing back to the database where every field equals whatever it equals - as compared to what it has in the record currently.

And when you run a preview with a given customer number in InfoMaker, the amount it absolutely correct, so it doesn't appear to be InfoMaker's fault,

Any ideas?

Thanks, Tessiturians.

Matt Gonzales

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

I think what you are seeing is a mismatch between the column specifications and the underlying SQL Query/Stored Procedure.  Check that the version of the datawindow you are working on is the same version you see in the application.  Also, check that the SQL Query is what you expect, and I would check the order of the columns.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Thursday, March 31, 2011 11:07 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] InfoMaker Shenanigans

Generally speaking, I have created a custom tab screen using InfoMaker 10.5 and have since changed it to suit Development's needs with relatively little problem.

However, this time, I've added new fields to the table that feeds the custom tab, which works fine in every respect, except that one field doesn't show the data in the the associated column for the current member record, but some sort of total.  It's not a total of all of the records for that column, mind you, but some sort of negative number nowhere near what it's supposed to be.  Consequently, when someone tries to edit the custom tab, they get an error because Tessitura insists on writing back to the database where every field equals whatever it equals - as compared to what it has in the record currently.

And when you run a preview with a given customer number in InfoMaker, the amount it absolutely correct, so it doesn't appear to be InfoMaker's fault,

Any ideas?

Thanks, Tessiturians.

Matt Gonzales

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!