Re: [Python-sybase-misc] select into and v.039

[Sébastien S. <sa...@us...>]

Hi Stephen,

are you sure that you are using python-sybase 0.39?

sable@incubus:~/sybase/python-sybase-0.39$ grep -r _LAZY_END_RESULT *
sable@incubus:~/sybase/python-sybase-0.39$

I think your backtrace corresponds to a prior version of python-sybase.

This may be linked to the use of setuptools in python-sybase 0.39. 
Setuptools will install a python_sybase-0.39-py2.4-linux-i686.egg file 
in your site-package, but not remove the old python-sybase files.

I think this could be solved by removing in 
/apps/python/lib/python2.4/site-packages/
the following files:
Sybase.pyc
Sybase.py
sybasect*

and then reinstalling version 0.39.

Then we can see if there is still a problem.

regards

--
Sébastien Sablé

Stephen Mock a écrit :
> I recently upgraded to version .039 from .037 and am having a problem
> with some basic sql.  It should create a temp table on the fly for me
> to select from, but i get an error caused by the "select ... into"
> statement.  It works perfectly fine with the older version.  Here's
> the code:
> 
>>>> import apresdb
>>>> c2 = apresdb.instance.cursor()
>>>> c2.execute("select iv0.ProdId, iv0.Account, iv0.StartPos, iv0.CurrPos, sum(iv1.StartPos) 'SumStartPos', sum(iv1.CurrPos) 'SumCurrPos' into tempdb..a_sum from  PortfolioInv iv0, PortfolioInv iv1 where iv1.ProdId = iv0.ProdId")
> Traceback (most recent call last):
>  File "<stdin>", line 1, in ?
>  File "/apps/python/lib/python2.4/site-packages/Sybase.py", line 546,
> in execute
>    self._set_state(_LAZY_END_RESULT)
>  File "/apps/python/lib/python2.4/site-packages/Sybase.py", line 695, in _start
>    if self._closed:
>  File "/apps/python/lib/python2.4/site-packages/Sybase.py", line 709,
> in _mainloop
>    # Send parameters.
>  File "/apps/python/lib/python2.4/site-packages/Sybase.py", line 753,
> in _raise_error
>    raise ProgrammingError('cursor is closed')
> Sybase.DatabaseError: Msg 3803, Level 16, State 1, Line 1
> The statement used to define the cursor 'ctmp2a956073b0' is neither a
> SELECT nor an EXECUTE.
> 
> 
> 
> Any help would be greatly appreciated.
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Python-sybase-misc mailing list
> Pyt...@li...
> https://lists.sourceforge.net/lists/listinfo/python-sybase-misc