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

Thanks all - appreciated!!

My background is 30 years in the Computer Business - Training, installations, support etc etc.
Since retiring I left Windows behind and changed to Linux.
What I'm not is a Programmer - except with BASIC about 20 years ago!!!

My needs are to have a SOLID, RELIABLE simple Members Database that does not crash all the time and take the data with it as well. I don't even need a RDB as I have one table, one Form and a few queries, it is single user on a single machine. My Form only uses Text Boxes, Drop-Down Boxes, Check Boxes and Photos and Graphics. End of story!! i don't want to become a DB expert just a basic layout person and every day user.

I did not think this would be a big problem in Linux - how wrong I was. I have battled with Base for several years and after my last crash in January, (Data lost, as is common, even with MySQL. The file is still there but it can not be accessed).

I thank Jarasow for his help with Kexi but after 10 crashes in 2 weeks and some missing features and no help to try and get Drop-boxes to work I had to give up on it. It does look very promising but has a way to go yet I fear.

So Alexander has told me how to save my Form (that helps a lot) and I decided to get back into Base as it seems to be the only way to go for me. But MySQL is giving me up-hill. It does not seem to want to save an empty Table for me to import my CSV into and gives me this error ...

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` varchar(21), `NULL` ' at line 1"

I seem to remember this from when I first set it up last year. It's not MY SQL - this is what the program did!! Also my first line of the CSV is the column names only and it works OK with Calc and did so as well with Kexi!! So where is the problem??!!
So I'm unable to populate the DB in MySQL for Base to link to it!!

Thanks all.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.