CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> Programming

 Access Table with Space in field name

Print topic Send  topic

Author Message
Tipu

Posts: 6
Posted: 04/09/2004, 2:42 AM

I have a access database table which have spaces in field name
For example table event have a field name event date.

since its getting updated from another application i can't change the field name to event_date or something els

and CC is giving me error if i try to use that field.

is there anyway i can stop it from happening

View profile  Send private message
Marcus


Posts: 49
Posted: 04/14/2004, 7:30 AM

Out of all databases, spaces in table names and field names are allowed only in MS Access. You will have to duplicate the database for use in CC and modify all those names by changing the space into a character like an underscore. Then you will have to write code necessary to periodically recocile the two databases.
View profile  Send private message
Stefan Hogedal
Posted: 04/16/2004, 2:52 PM

If you only need to read the table in CC I suggest making a Query that
renames the fields. CC will show the Querys after the Tables...

Example SQL syntax:

select [event date] as event_date from events

/Stefan

"Tipu" <Tipu@forum.codecharge> skrev i meddelandet
news:1440767007bce27@news.codecharge.com...
> I have a access database table which have spaces in field name
> For example table event have a field name event date.
>
> since its getting updated from another application i can't change the
field
> name to event_date or something els
>
> and CC is giving me error if i try to use that field.
>
> is there anyway i can stop it from happening
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

pcfountain

Posts: 35
Posted: 05/03/2004, 9:44 AM

When using an access database with spaces in field or table names, you need to enclose all names in square brackets:

Select [field name 1], [field name 2] from [table name] where [field name 1] = "access blows"

Hope that helps. ;-)
_________________
Paul Fountain
http://www.pcfountain.com
View profile  Send private message
arun
Posted: 06/29/2004, 12:20 AM

i need to the change the name of the field in my access database

plz help

Chris thompson
Posted: 07/09/2004, 7:47 AM

:-)
Thank you. Helped me out
Figo
Posted: 07/23/2004, 7:44 AM

Thank You very much .. the concept of enclosing the square brackets between the table name (select * from [tableName]) in cases where the table name have space between the name field was very helpful to me !!
Big Cheers,

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.