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 ....


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.com


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

________________________________________________________________________
This email was checked by MessageLabs SkyScan before entering Microgen.


________________________________________________________________________
This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]

Microgen Information Management Solutions
http://www.microgen.co.uk
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to