> >
> >
> > Michael A Chase wrote:
> > >
> > > On Fri, 20 Dec 2002 02:17:54 -0500 Jeff Thies
> > <[EMAIL PROTECTED]> wrote:
> > >
> > > > Paul Boutros wrote:
> > > > >
> > > > > > First time using Access.
> > > > > >
> > > > > > I've used my usual insert using placeholders and
> got an erro
On Fri, 20 Dec 2002 15:14:36 -0500 Jeff Thies <[EMAIL PROTECTED]> wrote:
>
>
> Michael A Chase wrote:
> >
> > On Fri, 20 Dec 2002 02:17:54 -0500 Jeff Thies
> <[EMAIL PROTECTED]> wrote:
> >
> > > Paul Boutros wrote:
> > > >
> > > > > First time using Access.
> > > > >
> > > > > I've used my u
On Fri, 20 Dec 2002 02:17:54 -0500 Jeff Thies <[EMAIL PROTECTED]> wrote:
> Paul Boutros wrote:
> >
> > > First time using Access.
> > >
> > > I've used my usual insert using placeholders and got an error about a
> > > count mismatch. Does Access not support placeholders?
> >
> > It definitely
Place holder example:
@dbi:ADO:File Name=.\access.udl> insert into tst(id,str) values (99,'this old ma n');
[1 row affected]
@dbi:ADO:File Name=.\access.udl> insert into tst(id,str) values (101,?);
Statement has 1 parameters:
Parameter 1 value: this old man
[1 row affected]
On Fri, Dec 20, 2002 a
On Fri, 20 Dec 2002 01:14:43 -0500, Jeff Thies wrote:
> I've used my usual insert using placeholders and got an error about a
>count mismatch. Does Access not support placeholders?
It does. But you'll get this confusing error message when using a field
name that Access doesn't recognise. Apparent
Paul Boutros wrote:
>
> > First time using Access.
> >
> > I've used my usual insert using placeholders and got an error about a
> > count mismatch. Does Access not support placeholders?
>
> It definitely does support place-holders, at least in the versions I've
> used. Can you post more info?
> First time using Access.
>
> I've used my usual insert using placeholders and got an error about a
> count mismatch. Does Access not support placeholders?
It definitely does support place-holders, at least in the versions I've
used. Can you post more info?
> Anything I should know about A
First time using Access.
I've used my usual insert using placeholders and got an error about a
count mismatch. Does Access not support placeholders?
Anything I should know about Access and DBI?
Also (a little off topic) how do I create an AutoNumber field?
Are there any advantages/disa