Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


Hi all:

        Using Google I found some web sites where I could learn my first
lessons about SQL. With this I could solve my problem to Group my data
in BASE.

        But then, I found that the file Spreadsheet that I've using was locked
(user permissions). Well I made a copy of the file with my permissions
and then make the db with Base conection and I could group with Wizard
of BASE.

        Thank so much to all that thought to help me but not had time.


P.D.: Web site I used: https://www.1keydata.com/es/sql/

Regards,

Jorge Rodríguez




El dom, 08-05-2016 a las 21:54 -0600, jorge escribió:
Good night, hi all:

      I have two options when I conect to a external spreadsheet data with
BASE:

1) Conect with the third option when start the wizard selecting:
spreadsheet.

In this case we can import the structure and data from it.

The first options is keep the conections with the original spreadsheet,
in other words, we can't modifie the structure import and use functions
when make a Consult for example (At least with my little knowledge).

Depend what you are going to do with data, is enough as is.

2) The second option is when we conect to external data because we need
to work we them with all options that usually offer BASE when we create
a new data base. In this situations we need import data but then split
conection with original data and make an independent data base.

At least I can't do this with BASE.

Would you please answer this:

a) With SQL options we can use the function "group" or other funtions
when make a Consult to solve my problem ? or with a Macro ?

b) If not (Point a)), where I can expose this situation that would be
improbe BASE in the future ?

-- 
Atentamente,

Jorge Rodríguez



-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.