- 论坛徽章:
- 0
|
请教大家, 用python访问Sybase的时候,是不是无法创建临时表? 有什么办法么?多谢了
>>> import Sybase
>>> ht=Sybase.connect("server1","user1","password1")
>>> hc=ht.cursor()
>>> hc.execute("select * into #tmp_tbl from tbl1 where 1=0")
会提示下面错误,
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "build/bdist.solaris-2.10-sun4u/egg/Sybase.py", line 734, in execute
File "build/bdist.solaris-2.10-sun4u/egg/Sybase.py", line 879, in _start
File "build/bdist.solaris-2.10-sun4u/egg/Sybase.py", line 893, in _mainloop
File "build/bdist.solaris-2.10-sun4u/egg/Sybase.py", line 938, in _raise_error
Sybase.DatabaseError: Msg 3803, Level 16, State 1, Line 65535
The statement used to define the cursor 'ctmp29baf8' is neither a SELECT nor an EXECUTE.
|
|