Base - need to re-point a form

users
#21

Hmmmmm It isn't quite that simple in Windows (no command line mysql client)
but I tried HeidiSQL and I can connect and amend data with no problems

#22

Hi John,

Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working
here first!). Connecting to a database on xeround.com
<http://xeround.com> (actually hosted on Amazon EC2 servers, using
port 18993. JDBC driver class com.mysql.jdbc.Driver
using mysql-connector-java-5.1.22-bin.jar

So I set up a free instance with xeround from my Macbook OSX Mountain
Lion 10.8.2 and created a table via the phpmyadmin interface.
Then I setup an ODB file using the mysql JDBC connector 5.1.22, pointed
it at the address and port given to me by xeround.

My db currently has one table, containing an INT(10) unsigned not null
auto_increment primary key, a varchar(250) field, and a mediumblob not
null field.

I can connect fine, I can also add, change or modify my records. Since
one of my fields was a BLOB, I had to create a form in order to be able
to add data to from within the LO ODB file, but it works just fine and
is actually pretty speedy.

Alex

#23

What are you talking about? Of course there is a command line interface to
MySQL in Windows. I use it all the time. Just go to Run and type mysql in
the Open: box. You'll get a Command prompt with mysql command line ready to
go.

John

#24

Really? Mine doesn't

#25

Perhaps a Windows environment issue? See this thread (and similar) at StackOverflow on the SE:
http://stackoverflow.com/questions/2259718/mysql-environment-variable-on-windows

Stuart

#26

OK, all fixed at last - by a clunky method, but hey - it worked!

I had the data in a CSV so I loaded that into an ODS sheet, then pasted
from there into a new table via Base, creating a new primary index in the
process. That worked!

#27

This is a bit late. SQL can be used to do many things including defining a primary key. I'm not sure right now what the required SQL statement should be. I do know that it requires using Tools -> SQL. This opens a dialog in which you can enter SQL statements and execute them.
      This would also require getting the HSQLDB guide for version 1.8. The version on the hsqldb website is for 2.8.

--Dan

#28

See "Re: [libreoffice-users] Cannot add primary key after saving without primary key." as a subject line
in this list by Dan Lewis. Also read other responses after.

Hope this helps
Paul