Long cells from a database

asked 2015-08-03 20:12:38 +0200

aristotle2600_ gravatar image

updated 2015-08-03 22:06:44 +0200

doug gravatar image

I have 2 issues actually. I have a big database of items. I want to grab only certain fields , from only certain entries. Autofilter lets me only see the records that match my selection criteria, but all the fields are still there. For anyone that knows SQL, I want to basically do

SELECT name, description, level  
WHERE type!='evil' AND sorc!=NULL  
FROM SpellsList

Now a solution I tried was to filter out the ones I want, then copy them to a new sheet, and then reference the fields I want in a 3rd sheet. The problem with this is that some of the fields are quite long; lots of text, the description field for example. If I look at the database itself, I can see the full text in the "content box" near the top of the Calc window. But when I reference the db, that only shows the formula I used to reference the database. I could just delete all the fields I don't want, but there are a lot of them, and that solution just isn't all that elegant. Is there a better way to do everything I want?

edit retag flag offensive close merge delete


have you tried to hide the columns you do not like? Right-click on column selector, in the pop-up menu hide.

doug gravatar imagedoug ( 2015-08-03 22:09:43 +0200 )edit

Whatever SQL you got there, it's a syntax violation to have §FROM§ clause after §WHERE§. With that aside, is your database MySQL, SQLite, the native HSQLDB or something else ? I understand going as far as using the integrated HSQLDB for something, but it's so slow compared to using a dedicated db like MySQL given it's a ZIP file that contains a bunch of pure text files and a binary file. Besides, don't use something as slow as SQLite, HSQLDB or similar for a Server, it's too slow. Continued ...

rautamiekka gravatar imagerautamiekka ( 2015-08-03 22:14:13 +0200 )edit

I read that some guy was using SQLite for the local healthcenter place or similar. He had a massive issue called lack of performance cuz SQLite isn't designed for multiuser environment, so it took literally minutes or even half an hour to work something like 200k customers and their data, not to mention having half a dozen staff members use it.

rautamiekka gravatar imagerautamiekka ( 2015-08-03 22:17:19 +0200 )edit