Quoting Hiroshi Inoue <Inoue@tpf.co.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
