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