Postgres Pro
Downloads
Home   >   mailing lists

Thread: QUESTION: OID and fake index do i "need" to use it?

QUESTION: OID and fake index do i "need" to use it?

From
"Corey W. Gibbs"
Date:
Good Evening Everyone,
 
I posted up a question Friday about some weird updating behavior when using ADO recordsets, and I just thought of something. 
 
On the connection setup in the ODBC datamanger, I am not using the dynamic OID and fake index thingy options.  Should I turn those on anyways even though I'm using a serial field in the table as a unique id for the row?  Or should I leave them off?  Will VB have an easier time of tracking what records it's currently working with if I turn them on?  Any help would be appreciated.  Only this one field does this and it's very frustrating.
 
thanks in advance
corey
 

Re: QUESTION: OID and fake index do i "need" to use it?

From
Hiroshi Inoue
Date:
> "Corey W. Gibbs" wrote:
>
> Good Evening Everyone,
>
> I posted up a question Friday about some weird updating behavior when
> using ADO recordsets, and I just thought of something.
>
> On the connection setup in the ODBC datamanger, I am not using the
> dynamic OID and fake index thingy options.  Should I turn those on
> anyways even though I'm using a serial field in the table as a unique
>  id for the row?  Or should I leave them off?  Will VB have an easier
> time of tracking what records it's currently working with if I turn
> them on?  Any help would be appreciated.  Only this one field does
> this and it's very frustrating.

I'm not sure if I'm understanding your problem.
You can download the latest snapshot dll from
   http://w2422.nsk.ne.jp/~inoue/.
You can check the * (Trial)Updatable Cursors *
DataSource option using the driver.

regards,
Hiroshi Inoue