Re: VB / SQL questions

2004-03-29 Thread FFT2001
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

RE: VB / SQL questions

2004-03-29 Thread Brian Leach
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

RE: VB / SQL questions

2004-03-26 Thread Larry Hiscock
> 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

Re: VB / SQL questions

2004-03-26 Thread FFT2001
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