I am using Access 2007 with a pass-through query. The data values that I am retrieving are from a bit column (0, 1) but when the pass-through query runs the data that is returned is either 0 or -1. I am calling a stored procedure on my SQL database for this pass-through query, this stored procedure works and returns the positive bit number of 1. Am I missing something here?
This is just a guess, but true/false is frequently represented by -1/0 (more sufficiently as non-zero/zero, with -1 being a common choice for the non-zero) so is it possible a conversion to boolean is going on somewhere?