[egenix-users] unixODBC SQLSEVER OUPUT issue

[akm]

On Tue, Apr 21, 2009 at 4:50 PM, Charlie Clark <charlie at egenix.com> wrote:
> Am 21.04.2009, 12:57 Uhr, schrieb akm <a.km.mail at gmail.com>:
>
>>>>> conn.execute(query_insert2, data)
>>>>> print conn.fetchone()
>> Traceback (most recent call last):
>>  File "<stdin>", line 1, in <module>
>> mx.ODBC.Error.ProgrammingError: missing result set
>
> It's an insert statement. Why should it have any results?

OUTPUT  is A SQL Server 2005 feature that helps in returning the
actual data from a table soon after an insert. Applications require
return values such as the new identity value, the computed column
value or the default value generated by the default constraint.

>
> Charlie
> --
> Charlie Clark
> eGenix.com
>
> Professional Python Services directly from the Source
>>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> ________________________________________________________________________
>
> ::: Try our new mxODBC.Connect Python Database Interface for free ! ::::
>
>
>   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
>    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
>           Registered at Amtsgericht Duesseldorf: HRB 46611
>               http://www.egenix.com/company/contact/
>