From: | sun(at)consumer(dot)org(dot)il |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | Shachar Shemesh <psql(at)shemesh(dot)biz>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: ODBC Open cursors on views |
Date: | 2003-08-19 10:36:51 |
Message-ID: | 1061289411.3f41fdc3c9354@latenight.fiasco.org.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Quoting Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>:
>
>
> Shachar Shemesh wrote:
>
> [snip]
>
> > If more than one table participates in the view, who's CTID do I need
> to get? Is
> > it enough to take one of the tables at random?
>
Hi,
You said that static readonly cursors worked for you. I'm trying the following
code, without success:
UpdateData(TRUE);
CString sql="select * from \"ACCOUNTLEDGER\"";
try {
if( m_crs==NULL ) {
m_db.OpenEx(NULL);
m_crs=new CRecordset( &m_db );
}
m_crs->Open(CRecordset::snapshot, sql, CRecordset::readOnly );
RefreshData();
} catch( CDBException *cdbexcept )
{
MessageBox( cdbexcept->m_strError, "SQL error", MB_ICONEXCLAMATION );
}
I get the same error (attribute "ctid" not found).
Am I doing something wrong?
Shachar
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Felipe Machado | 2003-08-19 10:45:08 | Re: large objects and pg 7.3.x |
Previous Message | Hiroshi Inoue | 2003-08-19 04:58:19 | Re: ODBC Open cursors on views |