I am very new to GIS and am using the ArcMap 10 program.
Currently, I am trying to set up a query layer from a remote database. I am able to connect to the database, but I am having trouble making the query because the table I want to use has a "bigint" column. From what I have read, ArcMap does not support this data type directly, though some sources suggest that there is a workaround by manually writing a query in the "name" and "Query" fields instead of using the "List of tables" and "columns" selection menus. I've tried this "workaround", and have not succeeded.
Is there any way that I can use my database in a query layer without modifying the database at all? Or can I connect the database to ArcMap in another way?
Update I am using a Postgres DBMS.
أكثر...
Currently, I am trying to set up a query layer from a remote database. I am able to connect to the database, but I am having trouble making the query because the table I want to use has a "bigint" column. From what I have read, ArcMap does not support this data type directly, though some sources suggest that there is a workaround by manually writing a query in the "name" and "Query" fields instead of using the "List of tables" and "columns" selection menus. I've tried this "workaround", and have not succeeded.
Is there any way that I can use my database in a query layer without modifying the database at all? Or can I connect the database to ArcMap in another way?
Update I am using a Postgres DBMS.
أكثر...