[python-win32] MS Access: silent overflow failure

[Mark Hammond]

> The small demo script below makes ADO calls to a Microsoft 
> Access (Jet)
> database via win32com. But it fails in a potentially dangerous way;
> "SELECT int * int;" can return None with no warning if the result is
> large enough. This can also occur if one or both of the operands is a
> column reference.
> 
> The same SQL run as a Query inside the Access GUI works as expected.
> Manually changing one of the ints to a Single by appending 
> ".0" works as
> expected.
> 
> Any ideas about where I need to look next to find the cause 
> of, and then
> fix, this behavior?

I'd suggest using VB to see if the behaviour is different than with Python.
If it is and we can narrow a test case to a very small snippet, then we can
probably sort out why.  If VB works the same, it is likely to be a "feature"
of ADO as implemented, and not much we can do.

Cheers,

Mark
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2092 bytes
Desc: not available
Url : http://mail.python.org/pipermail/python-win32/attachments/20070323/9c9c3b51/attachment.bin