ShipRush SQL: How it Gets Data

ShipRush runs your SQL query when either of two things happen:

 

  1. The user double clicks on the ShipRush icon in the system tray
  2. A value is scanned with a bar code scanner

 

When you double click on ShipRush, the Search form pops up:

 

 

The text in the Search edit above is fed into the %SEARCHPARAM% merge code in your query. If the LIKE operator is used in the query, then partial lookups can be done:

 

WHERE o.OrderID LIKE '%SEARCHPARAM%%'

 

Enter a value in the Search box, and the query is executed:

 

 

Selecting the item on the list, and ShipRush pops up with all the data populated.

 

%SEARCHPARAM% is also populated automatically by a bar code scanner. If ShipRush is in the system tray, the Search form will pop up when a bar code is scanned. If the Search form is already active, scanning a bar code that results in a single result row will cause ShipRush to pop up automatically.

 

Trick: If ShipRush is in the system tray, scanning the bar code twice will take you all the way to the ShipRush shipping form without needing to touch the keyboard.

 

Trick: The F10 key is the same as pressing the Ship button. If defaults or templates are in use, simply scanning the bar code and pressing F10 can process the shipment.

 

ShipRush does not need to have focus to use a bar code scanner. It does not matter where the cursor is. When a bar code is scanned, ShipRush will automatically engage.

 

 

Next: Example of getting data from the Northwind database