> You cannot update queries joining two tables, unless
> they contain (IIRC - would have to look into the code or ask
> my colleague :) ) a JOIN. That means that "SELECT A.a, B.b
> from A, B where A.b = B.ID" is not updatable. Try changing
> the connection between A and B: In the query design,
> double-click the connection line, and change it's Type to
> something else - does this help?
It didn't. The standard INNER JOIN indeed generates "Where x = y" statement.
Changing it to LEFT JOIN generates a JOIN (RIGHT JOIN doesn't seem to be
supported):
SELECT `categorymaster`.`Category`, `categorymaster`.`Description`,
`stockmaster`.`ItemNo`, `stockmaster`.`Description` FROM { OJ
`newstock`.`stockmaster` `stockmaster` LEFT OUTER JOIN
`newstock`.`categorymaster` `categorymaster` ON `stockmaster`.`Category` =
`categorymaster`.`Category` }
But the generated form on this query also does *not* allow any editing.
Any further ideas?
Cheers
Gert
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
