Skip site navigation (1) Skip section navigation (2)

ODBC : problem with bookmark /precision

From: Andre THEVENIN <andre(dot)thevenin(at)hortus(dot)fr>
To: PostgreSQL-ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC : problem with bookmark /precision
Date: 2005-09-15 09:53:56
Message-ID: 432944B4.6010007@hortus.fr (view raw or flat)
Thread:
Lists: pgsql-odbc

Andre THEVENIN a écrit:

>
> Hi,
>
> I just begin to use PostGRE with ODBC on Win2000/VC++6
>
> I arrive to this kind of things
>
> void CODBCDlg::OnOpen()
> {
>    CString sql;
>    CComptes cpt(&m_fBase);
>    m_fBase.Open("ODBC;DSN=KEOPS");
>
>    sql.Format("SELECT * FROM [Comptes] WHERE [Type]=1",
>        cpt.GetDefaultSQL());
>
>    cpt.Open(cpt.snapshot,sql,CRecordset::useBookmarks);
>    cpt.AddNew();
>    cpt.m_Type=4;
>    cpt.m_Etat=2;
>    cpt.m_Nom="DD";
>    cpt.m_Date_ouverture=COleDateTime::GetCurrentTime();
>    cpt.Update();
>    CDBVariant mark;
>    cpt.GetBookmark(mark);
>
>    cpt.Close();
>    m_fBase.Close();
> }
>
> The Update works, but i have an error on GetBookmark
> Error 24000 : Invalid cursor state
>
> What can I do ?
>
The problem appears when my table contains a field of type "serial".

Has anyone an answer ?

-- 
André THEVENIN
Hortus Technologies
<andre(dot)thevenin(at)hortus(dot)fr>
04 99 61 47 80
06 19 01 48 20

J'ai mis toute ma vie à savoir dessiner comme un enfant.

(Pablo Picasso)








In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2005-09-15 13:19:27
Subject: Re: ODBC Driver on Windows 64 bit
Previous:From: Dave PageDate: 2005-09-15 08:12:01
Subject: Re: row count with libpq driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group