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 246: varchar can't execute
1 person starred this issue and may be notified of changes. Back to list
Status:  NoFix
Owner:  ----
Closed:  Sep 2012


 
Reported by dunshir...@gmail.com, Mar 11, 2012
I'm using altibase and python3,but can not work when the row is varchar;

ex:
iSQL> desc area_info;
[ ATTRIBUTE ]                                                         
------------------------------------------------------------------------------
NAME                                     TYPE                        IS NULL 
------------------------------------------------------------------------------
AREA_ID                                  INTEGER         FIXED       NOT NULL
CITY_CODE                                VARCHAR(10)     FIXED       NOT NULL
AREA_CODE                                VARCHAR(10)     FIXED       NOT NULL
AREA_NAME                                VARCHAR(50)     FIXED       NOT NULL
PARENT_PROV                              VARCHAR(10)     FIXED       NOT NULL
PARENT_NATION                            VARCHAR(10)     FIXED       NOT NULL


In [48]: s.execute("select * From area_info where area_code = ?",'0998')
---------------------------------------------------------------------------
Error                                     Traceback (most recent call last)
D:\Program Files\Console2\<ipython-input-48-142f0158a9a9> in <module>()
----> 1 s.execute("select * From area_info where area_code = ?",'0998')

Error: ('07006', '[07006] Restricted data type attribute violation (331803) (SQLBindParameter)')


Jun 23, 2012
Project Member #1 mkleehammer
I don't have an Altibase database.  Can you generate an ODBC trace?
Status: Hold
Sep 29, 2012
Project Member #2 mkleehammer
Closing due to no response.

Status: NoFix

Powered by Google Project Hosting