topic Re: Make Query Table tool - need help please!! in Geoprocessing Questions

Make Query Table tool - need help please!!

JaysonLindahl — Wed, 26 Jan 2011 18:39:43 GMT

I am having trouble using this tool. I'm using 9.3.1 and have built a personal geodatabase with a table and feature class. The column data types are both TEXT.

When I try to relate the tables with an SQL expression, I receive an error message.

"There was an error with the expression. General function failure [GOM_WELLBOT]. Too few parameters. Expected 1."

This is my expression: A_Alerts.queryid = GOM_WELLBOT.apiid

**Update**
I now have moved my data into SDE. Now when I run the make query tool from arctoolbox in catalog, I receive a new SQL verification error:
"There was an error with the expression. Underlyling DBMS eror [ORA-00904:xxxxxxxxxxx invalid identifier xxxxxx"

Re: Make Query Table tool - need help please!!

LorettaBogert-O_Brien — Tue, 13 Sep 2011 17:44:58 GMT

Has there been a resolution to this problem? I am getting the same error when trying to use the Make Query Table tool in ArcMap 10.0 with a feature layer and a separate attribute table which are both in the same personal geodatabase. I am trying to duplicate features in a feature class to match all the entries in an attribute table, joining on a common variable. I got no errors, just an empty output layer when I ran it first, i.e. all the fields were there but there were no features at all.

Then I ran verify on my expression (FeatureLayerName.Legal_Id = AttributeTable.Legal_Id), and it gives the error:
"There was an error with the expression. General function failure. [AttributeTable] Too few parameters. Expected 1."

Re: Make Query Table tool - need help please!!

markdenil — Mon, 19 Sep 2011 16:01:50 GMT

Comparing the Script Sample for MakeQueryTable to your snippits,
It looks to me that You are not using the form:
database.table.field to identify each field you want to reference.
You simply use table.field
If Arc cannot find the item requested, it will return an error such as you are getting.