Brian you get the big gold star today. I should probably have stated more exactly what the field name was. The only response, that is might have embedded spaces wasn't the case this time, but that wasn't the fault of the responder since I wasn't specific about what the field was.
It was called MIN So I suppose that MIN is a keyword (minimum?) and now you have made it clear what my initial error was. Thanks. Will In a message dated 3/29/2004 5:41:22 AM Eastern Standard Time, [EMAIL PROTECTED] writes: > Just to add, > > And if they clash with SQL keywords like DATE, USER or STATUS. > So it's just generally safer to enforce them, as you never know what > keywords are likely to be added in the future. > > Brian > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of 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 .... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
