Hello Pierre-Yves, > I failed to run this UNION query: > > SELECT "E-mail" from "1.2 BUR-Fournisseurs" UNION SELECT "E-mail" from > "Personal Address book" > > with my Thunderbird Address book. > > A pity because this was my plan for searching in ALL books together for > a lost contact (this is not featured in Thunderbird). > > Q.1 Is the 'UNION' statement not in the suppoirted dialect for > Thunderbird source?
Yes, unfortunately it isn't supported there. > Q.2 What are the other limitations for TB? Where is the oc about this? What do you mean with "oc"? Basically, the Thunderbird integration is backed by a rather basic SQL engine only, so there are a lot of things you won't be able to do. Counting the things you can do in SQL there is probably faster, but nobody did so far. In other words: sorry, there is no documentation about what is supported. > Q.3 Shall I meet the same limitations for other external sources? Mainly > ODBC ans SqLite, and OOCalc? ODBC and SQLite: no. OOCalc: yes. For Thunderbird and Calc, the same parser / "engine" is used, ditto for dBase and text files and other address book types. All those basically share the same SQL support. Other DB types do not use OOo's own small engine, but rely on the DB's engine. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
