I created a 2 table query using a data model. It ran at the time I created it. Then I saved it for future editing and use, but when I try to call it up, I get the msg "Expecting consistent number of columns in all rows of table" The related Help, says it may have an incorrect # of pipe symbols in the query definition.
Well, there is no corresponding sql to reference or any other way that I know to look at the "query definition"
Further info: When I can see the query the first time, the key field in the upper part says join! (note exclamation point), while the lower says just join. I tried to vary these before saving, but that didn't seem to do anything either.
Well, there is no corresponding sql to reference or any other way that I know to look at the "query definition"
Further info: When I can see the query the first time, the key field in the upper part says join! (note exclamation point), while the lower says just join. I tried to vary these before saving, but that didn't seem to do anything either.