hi,
Have a rowSet (Scroll_sensitive, updatable) filled with
a SQL-Statement <Select *,* FROM TAB1,TAB2 Where id1=id2>
Everything is working (navigate, insert, change and delete) but I
think suboptimal" :=)
Insert: After
oStmt.executeUpdate("Insert Into TAB1 (f1,f2,...)+_
Values('v1','v2',...))
oStmt.executeUpdate("Insert Into TAB2 ...
the rowSet seems to be unchanged (not reachable with navigation).
After creating a _new_ rowSet the newcommer is visible.
Delete: After
oStmt.executeUpdate("DELETE FROM TAB1 WHERE id1=id2)
the dialog does not change, the deleted row keeps visible.
After creating a _new_ rowSet the row is gone.
Recreating the rowSet seems not really efficient...
Have tried the use the SDBC method
oRoSe.deleteRow()
This results in "Delete privilege not available"
and Google does not report a code snippet
Use OOo 2.1, HSQLDB on ARCH-Linux
Thanks for a better idea
Wolfgang
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
