Hello!

I have an access database, with a field name "GROUP". As "GROUP" is a reserve word thus using SQL query from ASP page I cannot insert data into this field.


Sql="Insert into patient(NAME, GROUP) VALUES ('ZEESHAN AHMED', 'A+')"


Is there any solution for this Issue. Please note that I CANNOT change the field name.


Thank you,
Zeeshan Ahmed

__________________
Zeeshan Dar
itHighway
Get in Touch with People Texting your Website
Advanced Real Estate Listings Solution - FREE Hosting

Sounds like the person who designed the datastore needs a good talking to. IMO you cannot use reserved words under any circumstances.

;;Please note that I CANNOT change the field name.
I assume the page has never worked. If I may say so, you should have the ability to change a development datastore. What are your hurdles?

BTW This is also a reserved word in SQLServer and mySql

I am very interested to hear if there is a solution

Wind is your friend
Matt

A good habbit to get into for future. Prefix table and fields names with some relavent characters, Eg:
tablename = tblSomeName
fieldName = fldSomeName

This way you never have to worry about learning the reserved word list nor ever using one by mistake.

Wind is your friend
Matt

Please try

Sql="Insert into patient([NAME], [GROUP]) VALUES ('ZEESHAN AHMED', 'A+')"

Shibu Narayanan
Software Associates