Search results

The Field_Index field is a varchar, so the value needs to be wrapped in single quotes. Sorry should have given you the data types as well :)

After modifying the drop down you may need to force a refresh of the drop down contents, either by a filter refresh or closing and reopening the form. Also, if you want to post your SQL we can try it out over here to see wha t we can find.

Hi Andy, The drop down data is stored in tables as well. Here is the table definition for the drop downs (For session 1): Tablename: Session1_DD Field list: Field_Index, DisplayValue, FilterValue, DBValue Let us know if this helps.

Hi Andy, No, it is not possible to navigate the table structure of the TracerPlus database. However, take a look at this knowledge base article on writing SQL statements in TracerPlus. https://support.tracerplus.com/index.php?/Knowledgebase/Article/View/216/0/writing-sql-queries-for-tracerplus...

Hi Andrew, This is available at the bottom of the Form Logic dialog. Select the row you would like to add a comment to and type it in the text field on the bottom right. You can also Enable/Disable the rule to the left of the Comments field. Let me know if this is not what you meant.

No, you cannot place multiple controls on the form all pointing tot the same field. You can however fake this behavior by adding an additional field to your form and setting its' type to Calculated with a function of Add from the original field. This will copy the contents of one field into...

Hi Andrew, Are you referring to a tab on one of your data collection forms, or the home screen (Launcher)? If you are referring to the Entry Form, you should be able to set this by designating one of the fields on the first tab to be the 'Start on Field'. You can do this in the 'Advanced'...

Hi Karl, Have you tried changing the Event to be all SyncComplete? They should be performed in sequence so if the DB Delete all is triggered on that event it should be immediately followed up with a Execute SQL, and finally the ShowMessage. Let me know if this helps.

Yes, but Excel will always contain 255 columns regardless of the number of columns that have been imported. You will want to make sure you only map the required columns. One thing to try would be to close down TracerPlus Connect and open the task manager. Make sure there are no instances of...

Hi Alex, How many fields do you have mapped in the process configuration to that Excel spreadsheet? Excel can be rather slow if you have a large number of columns mapped. This is because it needs to loop through all of the mapped columns to retrieve the data. If possible try reducing the...

Hi Karl, You may need to do something like an execute SQL action to test for the record count. I'm not sure you can check against the label like you have there. The SQL would look like 'SELECT COUNT(*) FROM Session1' This will place the record count of session 1 into your action control ID...

Hi Karl, Could you check against the data somehow after the sync has been attempted? For example, if you sync the record over, and it is supposed to be removed from the handheld after the sync, can you then check the record count of the session is equal to zero. So maybe something like on sync...

Could you try something like this...? SELECT Field1 FROM Session1 WHERE Field1 = ('0'+'[*0*]') That should pad the leading zero to the value entered on the form.

I've been looking around on their website for any information regarding a scan wedge, with no luck so far. I'll continue to research this and see if I can find anything. I'll keep you posted.

Hi Tom, I'm not too familiar with that device, but my guess is the scanner is not supported in TracerPlus. The standard way to get around this is to start up the manufacturers bar code wedge application. A bar code wedge application is basically a program that runs in the background, and...

You can time stamp each record by adding a field to your form and change its data type to DateTime. You can adjust the format as needed. Currently the only way to get sync time stamps would be to look at the log file.

Hi Anthony, You can add a field to your form that captures the Device ID of the device every time a record is saved. This data can then be synced to your database table along with the other field information stored with your record. This would allow you to see the device that sent the data in...