Re: psqlODBC ODBC3.0/Column Names

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> Sent: 29 March 2002 16:29
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: RE: [ODBC] psqlODBC ODBC3.0/Column Names
>
>
> > -----Original Message-----
> > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > > > > You seem to be forgetting to call DataAdapter.Update method.
> > > >
> > > > Yes, thanks. Unfortunately though, both my problems remain.
> > > >
> > > > - The ODBC3 driver returns 'Column1','Column2' etc as
> the column
> > > > names (the 2.5 driver is fine).
> > >
> > > Hmm I see neither here.
> > > Please try the latest driver at
> http://w2422.nsk.ne.jp/~inoue/ . No
> > > explicit
> OdbcCommandBuilder is needed.
> >
> > Aha. The unicode enabled v3 driver is returning the column names
> > correctly. Thanks.
> >
> > I'm still not getting update/insert/delete commands though, either
> > with or without the OdbcCommandBuilder. I must admit
> confused by you
> > saying I don't need it though, I thought the whole point
> was that the
> > DataAdaptor *didn't*
> > spend time figuring out the queries & their parameters
> unless explicitly
> > told to (from the Microsoft docs):
>
> Sorry the statement
> OdbcCommandBuilder cbDB = new OdbcCommandBuilder(adDB);
> seems to be needed. I can add a row by adding the statement
> adDB.Update(dsDB);
> after the statement
> dsDB.Tables[0].Rows.Add(rwDB);

Strange, That works perfectly, thanks. I put it after the following line
which is:

dsDB.Tables[0].AcceptChanges();

Obviously that doesn't do quote what I thought.

Thanks again,

Regards, Dave.