Hello, Andrew Jensen schrieb:
Just to follow up for the list readers.
It`s nice you do that.
In my first test I had set both of the SQL view queries to 'Run SQL Direct' = TRUE, or in other words turning escape processing off. This allowed either SELECT statement to run correctly. The problem is only manifest when escape processing is on. Also, when escape processing is on and the inner join query is run not only is the resultset incorrect, but Base makes the returned resultset updateable. Of course an attempt to actually edit the records fails. I was wondering if this might have something to do with the change made to table aliases being or not being created. I believe it was turned off by default now, and that it can be re-instated with an option. I just have no clue how to set that option for an embedded database connection. ( besides, I can't quote where I read that so perhaps I am mistaken that it is an option now, and perhaps it has nothing at all to do with this problem )
I have wrote issue 76377 now. kind regards Regina --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
