Hi All,
I am having a layer file which I am trying to join with SQL server view. The idea is to get the customer more atribute information.
The layer file is ArcSDE 9.3 / Oracle
SQL server 2005
Desktop 10.1
When I validate join I am getting the following error from ArcMAp
"Field names containing invalid characters can cause the join to fail, the following fields containing invalid characters:
- [start Date from<dbo.tableForLayerFiles> Contains invalid character ' '
- [start Date / Duration ]from<dbo.tableForLayerFiles> Contains invalid character ' /'
- [start Date / Duration ]from<dbo.tableForLayerFiles> Contains invalid character ' '
What date format 10.1 desktop is expecting here? Can anyone adcvice me on this?
The same layer file join with SQL server view worksfine in 9.3 and in defenition query I have given io_P_area.OBJECTTID > 0 and "Start Date" > date '30-01-2012', This works in desktop 9.3 environment
Please help
Cheers
Antony