Okay so I see some weird stuff for a couple of sessions. In the "View Data" on the device, the column headers are not making sense with what I have setup in tracerplus connect. I think there is a bigger issue at play. Waiting on support.
Now I have even tried using form logic on an OnClick event for a button using:
SELECT COUNT(*) FROM Session6
and the Action Control ID updates from the default value of -1 to 0.
I even tried
SELECT 9 FROM Session6
thinking it might return the number 9 and no dice.
Trigger field is being triggered. It returns '0' for the simple count query. I followed a tutorial for testing and made a button use the fieldinput button action, target control to a test field, and the test field is the trigger for the field with the SQL variable. Thanks for any help.
I am trying to get the sum of a column with in a session when a user scans a barcode. The following is on a SQL variable field. Basically, when the index is entered of the item, I want to get the sum of a column for all references to the index.
SELECT SUM(Session6.Field14) FROM Session6 WHERE...
I have form logic to make a button, which resides on the 2nd tab, visible if a checkbox is selected (it is by default) which is also on the 2nd tab. The problem is that on startup the button shows visible on the first tab. Any ideas? Thanks.
Thanks. next question... When I was first learning this software I created a project, which has since been removed. I am noticing, however it is still making inserts into the database on my server. I do not now how to make it stop, but every few seconds it inserts new rows. I have also...
After adding fields in the desktop project, I would like to refresh the data source fields in connect so I can make the relationship. The only way I have gotten this to work when using a live profile is to recreate the profile. This can be time consuming when you have multiple sessions. Am I...