My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 67: cursor.description returning None in the display_size,precision, and scale fields
1 person starred this issue and may be notified of changes. Back to list
Status:  Complete
Owner:  ----
Closed:  Dec 2009


 
Reported by jaywgra...@gmail.com, Aug 26, 2009
around line 314 in cursor.cpp the display size, precision, scale fields 
are set to Py_None. 

It seems to me you are getting the correct data from the SQLDescribeCol call 
around line 253 but just not using it. 
Sep 5, 2009
Project Member #1 mkleehammer
I agree about precision and scale, but SQLDescribeCol doesn't return the display 
size.  I'm adding precision and scale.  Was display size the value you wanted?

I'm sure I can use one of the SQL_DESC fields to get it, but it would require more 
calls per select.  Each time I add a call, someone notices that performance isn't 
quite what it was.
Status: Started
Sep 5, 2009
Project Member #2 mkleehammer
If you are interested, I've checked in the precision and scale changes:

http://github.com/mkleehammer/pyodbc/commit/ea32488a034a22b69b84ef60ad266803dc1b919b

They will be in the next build.  Please let me know about display size.  If you 
don't need that, I'll close this for now, or change the priority to low.

Sep 5, 2009
#3 jaywgra...@gmail.com
Scale and precision are all I need.  I'll try the next build.
Thanks!
Dec 31, 2009
Project Member #4 mkleehammer
(No comment was entered for this change.)
Status: Verified
Nov 21, 2010
Project Member #5 mkleehammer
(No comment was entered for this change.)
Status: Complete

Powered by Google Project Hosting