Search results

  1. OliverR

    How to format date in a SQL statement?

    Hey guys, I'm using a SQL statement to insert the date into a session field, but I can't seem to find how to format it to "dd/MM/yyyy" format (or any other format, for that matter). Here's what I've got that's working so far: INSERT INTO Session1 SELECT GETDATE() That's simple enough...
  2. OliverR

    Connect says 'no records found' even though there are records

    Hi guys, This is doing my head in. I want to set up a sync profile that syncs from an Access query to a TracerPlus session. The query works fine in Access, and I can also see the data fine in the Data Viewer in Connect Management Studio. However, when I hit the sync button, it says 'no records...
  3. OliverR

    Sync via service on cradle connection

    Hi guys, This article in the Knowledgebase describes how to set up an application to start a sync automatically when the device is cradled. However, it says at the bottom "with TracerPlus Connect open (...)". Does that mean this doesn't work with the Sync Service? I've tried to get it to work...
  4. OliverR

    Grid filtering on calculated time field

    Hi guys, I'm trying to create a simple timing app but am struggling with something. Basically there are 2 date/time fields that contain a start time and stop time, and then a calculated field that contains the duration (ie. stoptime minus starttime). I want to have a grid that shows only those...
  5. OliverR

    Use a timestamp to name export files

    Another request we get frequently is the ability to use a timestamp as a filename for an exported file. That way a user can do multiple exports over a period of time. This can be handy in the case of recurring inventories, to easily compare between inventories on different dates. Again, I know...
  6. OliverR

    Specify export location in TracerPlus Desktop

    I was sure this option already existed. I went to look for it just now because a client asked about it, and I was surprised to find that there is no such option. Or I'm just overlooking it... I guess it's the "database location" setting that I was thinking about. That's not what I need, though...
  7. OliverR

    Belgium based reseller

    We are a reseller located in Belgium. We've been actively using the TracerPlus software ourselves in many different projects for years now, and so have quite a bit of experience developing applications for various purposes. Aside from reselling TracerPlus to customers in the EMEA region we also...
  8. OliverR

    Using SQL command to insert static values

    Hi, I'm trying to insert static values into a session by pressing a button. The idea is that the last line of the exported csv file will contain a line like for example: *****END OF FILE***** So I added a button to my form and used the form logic to have it execute the following SQL when it's...
  9. OliverR

    Using SQL command to sum decimal values

    Hi guys, I'm trying to get a field to display the SUM of a column in a session, but running into problems. The problem being that the values stored in the column are DECIMAL values (they're weights of boxes). I tried to convert the values to decimal using the following code: SELECT...
  10. OliverR

    Scanning usernames in the Login form

    Hi guys, A customer of ours would want their users to scan a username (eg. printed as a barcode or QR code on their badge) and then enter a 6-digit numeric password to log into their TracerPlus application. This to prevent their users having to type in their usernames, because they are quite...
  11. OliverR

    This project was created using a newer version. Except... it wasn't

    Hi guys, Whenever I open a project in TracerPlus Desktop v9.0 (build 1167), it gives me a warning saying that the project was created using a newer version, see screenshot below. This isn't the case, though. It seems to do this every time, with any project I create. Not a huge problem, but kind...
  12. OliverR

    Triggering a stored procedure from the mobile device

    Hi all, I figured I'd post my question here instead of sending an e-mail :-) A lead of ours is looking to implement a TracerPlus solution in their production environment. One thing he would very much like to be able to do is trigger a Stored Procedure on their ODBC database from the mobile...
Top