Hi I am trying to make a SQL Query on LO 3.3.2 (Windows 7 + ODBC Oracle). I start in Design view, Selecting a table and selecting 3 fields to keep it simple. If I try to run the Query, I get this: Oracle SQL SQL View Error -AS-.png<https://docs.google.com/a/svenningsen.dk/leaf?id=0BzvkNAsNO_AxMDUyZGQyZTAtNDE3Yy00MTQ4LTk5ZjMtMzdiMzcyMDBhZmVk&hl=en&authkey=CPPgwpQH> If i Check the SQL command I get This: Oracle SQL SQL View -AS-.png<https://docs.google.com/a/svenningsen.dk/leaf?id=0BzvkNAsNO_AxODkxNjM0ZDItMmJlOS00ZjFkLWFlZGMtMzlkNDllYTM1MmFl&hl=en&authkey=CJaPybwI> As can be seen in the Blue mark " AS "BOOK" " has been added. If I remove that it works: Oracle SQL -AS-.png<https://docs.google.com/a/svenningsen.dk/leaf?id=0BzvkNAsNO_AxMzc2OTMzMmMtOGM3My00OGFiLWFjZTAtODRkNTY1MmU2NWFk&hl=en&authkey=COjhn4oC> If I save this SQL command, and open it in design view I get this: Oracle SQL Design View -AS-.png<https://docs.google.com/a/svenningsen.dk/leaf?id=0BzvkNAsNO_AxZjIyNDNhZGUtM2NjNy00MjhjLTk1N2EtYzdhYTAwNDFkMGRi&hl=en&authkey=CK-_lbEF>
If I look at the SQL againg in command view every thing show right but if I switch to design view, then it's back to the error. So to be working with this I have to stay in command view and save, close, and open in design view and not save... Best Regard's Rikard Svenningsen -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
