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: [email protected]
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
