Le 16/04/12 14:49, Mark Stanton a écrit : Hi Mark,
>> - multiple table query/update support > > Multi-tabe query is available, surely? Where it's not available is in > file mode when there's no backing database engine. Or having I missed > somthing? > > Multi-table update support is an SQL limitation, isn't it? Sorry, I should have been more precise : Lotus Approach allowed a user to create a form based on a query of a collection of DBF tables and then be able to update them via the form (or an update statement) - of course, relationships/foreign keys needed to be involved, but it did work. This was a particular plus point over the single flatfile driver that we have always had with OOo and now LO. In other words, it allowed for updates/writes to cross-table flatfiles as far as I can recall. You can not do this with the flatfile driver of LO - only a single DBF file can be updated/written to at one time, and as for Calc or Excel, well they are just read only datasources within the framework of Base. I don't know how Lotus/IBM did this, but it was a very, very, neat feature. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
