Recent content by Brady Fearnow

  1. B

    SUM SQL Query In Same Session

    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.
  2. B

    SUM SQL Query In Same Session

    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.
  3. B

    SUM SQL Query In Same Session

    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.
  4. B

    SUM SQL Query In Same Session

    I even tried just the following and no dice: SELECT COUNT(*) FROM Session6; There are 7 records currently. What am I doing wrong? Thanks.
  5. B

    SUM SQL Query In Same Session

    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...
  6. B

    Button Becomes Visible On Multiple Tabs

    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.
  7. B

    Updating Data Source Fields

    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...
  8. B

    Updating Data Source Fields

    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...
Top