Re: [libreoffice-users] Re: Calc as a Flat File Database

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: 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