ck
> Sent: 26 March 2004 18:20
> To: U2 Users Discussion List
> Subject: RE: VB / SQL questions
>
> > Can someone tell me why I need
> > INSERT INTO test([field1], field2
> > instead of
> > INSERT INTO test(field1, field2
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Larry Hiscock
Sent: 26 March 2004 18:20
To: U2 Users Discussion List
Subject: RE: VB / SQL questions
> Can someone tell me why I need
> INSERT INTO test([field1], field2
> instead of
> INSERT INTO test(field1, field2
Brackets are required around field and file names if they
> Can someone tell me why I need
> INSERT INTO test([field1], field2
> instead of
> INSERT INTO test(field1, field2
Brackets are required around field and file names if they contain spaces or
other non-alphanumeric characters.
Larry Hiscock
Western Computer Services
http://www.wcs-corp
OK thanks for the heads up on using SQL INSERT and UPDATE instead of ADO Recordsets
and also using the Prepared property. That made my program run about 7 times faster.
Can someone tell me why I need
INSERT INTO test([field1], field2
instead of
INSERT INTO test(field1, field2
in other