Re: [libreoffice-users] Re: Base - need to re-point a form

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

On 10/20/2012 11:19 AM, Dan Lewis wrote:
> On 10/20/2012 09:27 AM, John Clegg wrote:
> > 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!
> >
> > On 19 October 2012 16:52, V Stuart Foote <VStuart.Foote@utsa.edu> wrote:
> >
> > > 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
> > >
> > > ________________________________
> > >
> > > From: John Clegg [mailto:john.clegg@nailsea.net]
> > > Sent: Fri 10/19/2012 10:04 AM
> > > To: jomali
> > > Cc: Alexander Thurgood; users@global.libreoffice.org
> > > Subject: Re: [libreoffice-users] Re: Base - need to re-point a form
> > >
> > >
> > >
> > > Really? Mine doesn't
> > >
> > > On 19 October 2012 15:55, jomali <jomali3945@gmail.com> wrote:
> > >
> > > > 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
> > > >
> > > > On Fri, Oct 19, 2012 at 9:23 AM, John Clegg <john.clegg@nailsea.net
> > > > wrote:
> > > >
> > > > > 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.
>        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


--
For unsubscribe instructions e-mail to: users+help@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