| Issue 246: | varchar can't execute | |
| 1 person starred this issue and may be notified of changes. | Back to list |
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
Status:
Hold
Sep 29, 2012
Closing due to no response.
Status:
NoFix
|