query1

L

lou sanderson

sometimes when i run a query based on a query, i'll get an error that says it
is looking for 'query1'.fieldname1 where fieldname1 is whatever fieldname i
happen to be using in my query and 'query1' is query1. the only problem is
there is no query in the database with the name query1, nor is 'query1'
referenced anywhere in the sql statement for the query i am running.

has anyone seen anything like this? anyone have any idea what is going on?

thanks,
lou
 
J

Joan Wild

Post the SQL of your query. Is it possible you have a lookup field in the
underlying table?
 
L

lou sanderson

Eh, I may have found it. I was performing an Int() in one of my fields, and
that kept the source fieldname but removed the source query name. I put the
full path back in(query_name.field_name) and that worked.

Thanks,
Lou
 
Top