Ross Johnson wrote:
Alex Thurgood wrote:
Manolis Christodoulou wrote:
Nobody answered so far, please allow me to ask again...
Is there a way to have a table control in a form, that contains
fields from more than one database table? I know how can I do it
using queries or views, but then the table isn't editable. Any
workarround?
Not that I know of. I've just had a thought, though. Maybe you could
create a temporary table with a corresponding SQL statement and then
use that in your table control. I really don't know whether that
would work.
Oops. I misread you. A temporary table should work of course, but it
would be pretty messy doing it that way I suspect.
No, that won't be editable either. That is the same as using a view.
There is an IZ issue or RFE to do with editing data derived from
views. Currently, unless there is a field that Base can use as a
"bookmark" field (i.e. a primary key) then the rowset (or is it
resultset?) is read-only.
See:
http://qa.openoffice.org/issues/show_bug.cgi?id=62751
A previous related thread in [EMAIL PROTECTED] started here:
http://dba.openoffice.org/servlets/ReadMsg?list=users&msgNo=2934
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
