I'm having a problem executing a query against a Shape File.
In QuantumGIS I'm able to do so. But using thinkgeo it gives me a exception:
"Syntax error in query expression 'FREGUE~1'."
I'm just doing:
DataTable dt= layer.QueryTools.ExecuteQuery("SELECT ID,FREGUESIA FROM FREGUESIA");
is it because FREGUESIA is more then 8 character long?
sThinkGeoColumnQueryToolsProblem.zip (292 KB)
Rui,
Thanks for your information about this post.
This is our problem, and it’s not caused by that the table name is more than 8 character long.
I noticed that one of the column has the same name with the table name. I think this is the problem. By default, if your table name is more than 8 character long and we will replace the table name with the short path name(“FREGUE~1”), and so that the column name also will be replaced.
We will handler it as soon as possible. Any progress about it we will let you know first.
Anyway, if you run it well right now, and here are two optional workaround for you temporarily, one is to change the column name which has the same name with table. Another is that modifying the shape file name with no more than 8 characters long.
Sorry for the inconvenience caused to you.
Thanks,
Khalil
Ooops…
Bad luck, we here have a convention for some type of layers, namely the country administrative limits. Table name (or shape) and main name column should have the same name. example:
Country
ID| Country| Lang| Pop
So we have a problem.
Can you tell how much time it will take for you guys to fix this?
Rui,
We have fixed this issue and it should be availble in the latest Daily Build (4.0.99.0 or later). Please get it through helpdesk.thinkgeo.com/helpdesk/login.aspx.
Thanks,
Ben
Still not there…only:
WebEditionFull4.0.98.0DllPackage.zip
I’ll wait, maybe your automated building system has run yet…
Rui,
The auto build might be completed in a couple hours, I don’t know when it will be available for you to download. Anyway, it will definitely be ready in tomorrow. Let me know if you still have issues then.
Thanks,
Ben