decimal values

[John Aherne]

I am using a pervasiveSQL database version 9 and 10 with pyodbc

I am getting some strange results with decimal values using python 2.5.1, pyodbc 2.1.7 and pyodbc.3.0.6 and pervasiveSQL 9.

I have a test rig using PervasiveSQL 10 and whatever I do this works using python 2.6 and pyodbc.2.1.8 or 3.0.6

I have some existing code that runs with python 2.5.1, pyodbc.2.1.7 ad pervasiveSQL 9.

I make what are trivial changes but not to the sql code and the new revision does not work.

The select wheref value = ? based on a decimal value in the database finds no result.

So I switch to running some test code and command line test code.

This does not work either.

What does work is if I use the sql 'in' selection method. where value in(?). Here I can use decimal, int or string and all work

For the select where value = ?, I have tried switching the parameter value to int, string, decimal all to no avail.

What I cannot pin down is whether I have a Pervasive ODBC problem or pyodbc problem.

The existing code runs on the current site without problems even after I updated the pyodbc from 2.1.7 to 3.0.6.

But any little test routines run from the command line fail on the same site. Total confusion.

If anyone has any pointers I would be glad to try them out and see where I get to.

Thanks for any info

John Aherne

[John Aherne]

Just thought I would add a sql trace to show better what is happening just in case it is helpful.