Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-17 Thread Tom Davies
Hi :)
new and improved is hopefully a duplication rather than a contradiction!  
lol.  Not always true, of course.  

English (US) does tend to use different prepositions under English (GB).  Out 
advertising people also seems to just muddle them down to try to reinforce 
their message.  Council estate kids and common usage also messes things into.  
Regards from 
Tom :)  






 From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org 
Sent: Wednesday, 17 July 2013, 2:46
Subject: Re: [OT] Re: [libreoffice-users] HSLQLDB syntax
 

At 21:06 16/07/2013 -0400, Mark LaPierre wrote:
As long as we are going to entertain off topic, how about this.

[One] common figure of speech in English is the use of Try and 
where the meaning is Try to.  I.E. I'm going to try and drive my 
car backwards for three miles.  When I see it, or hear it, I wonder, 
Are they going to try the car, or are they going to drive the 
car?  Make up my mind!

I have to say I also prefer try to to try and, but Henry Fowler 
says of the figure of speech given the classy Greek name hendiadys 
(or one-through-two):

... 'nice and warm', 'try and do better', 'grace and favour', 
instead of 'nicely warm', 'try to do better', 'gracious favour' are 
true examples.

See http://en.wikipedia.org/wiki/Hendiadys .  Advertisers use it when 
they claim their product is new and improved (which is a 
contradiction), meaning newly improved.

Brian Barker


-- 
To unsubscribe e-mail to: users+unsubscr...@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




-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-17 Thread Tom Davies
Hi :)
+1
to all that, especially the Once you are up to date, I'm sure they'd 
appreciate any help you can offer..  Plus, making yourself familiar with 
HsqlDb 1.8 is a good plan anyway.  HsqlDb is java based but it's small and fast 
so as an external back-end it's good for most uses.  

My workplace is considering buying a specialist database that uses Firebird as 
a back-end so i kinda hope Base goes that way too.  Unfortunately they have 
left the final purchase decision up to someone outside the organisation that is 
fairly clueless about compatibility and the alternative back-end is Access.  
Regards from
Tom :)  






 From: V Stuart Foote vstuart.fo...@utsa.edu
To: users@global.libreoffice.org users@global.libreoffice.org 
Sent: Wednesday, 17 July 2013, 0:55
Subject: RE: [libreoffice-users] HSLQLDB syntax
 

Mark,

Hey why should you care that it is off topic, no one else seems to understand 
the concept ;-)

So, regards movement toward a non-Java JRE dependent default SQL DB for 
integration with the Base component. 

Several Bugzilla items worth reviewing:

considering and rejecting SQLite as replacement
https://bugs.freedesktop.org/show_bug.cgi?id=38811

find a replacement for HSQLDB v1.8
https://bugs.freedesktop.org/show_bug.cgi?id=51781

considering an update to HSQLDB v2.x
https://bugs.freedesktop.org/show_bug.cgi?id=44854

move default to FireBird not HSQLDB in Base -- this is the current development 
effort
https://bugs.freedesktop.org/show_bug.cgi?id=51780

Finally, here is the Wiki based project coordination for implementing 
FirebirdSQL
https://wiki.documentfoundation.org/Development/Base/FirebirdSQL

Once you are up to date, I'm sure they'd appreciate any help you can offer.

Stuart


From: Mark LaPierre [marklap...@aol.com]
Sent: Tuesday, July 16, 2013 6:13 PM
Subject: Re: [libreoffice-users] HSLQLDB syntax

Well actually, I was going to ask what might replace HSQLDB but I
thought it might be a bit too far off topic.



-- 
To unsubscribe e-mail to: users+unsubscr...@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




-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-17 Thread anne-ology
   and what about 'genuine imitation'  ;-)

   Yes, I'm ashamed to admit that the USofA probably is the worse for
producing slang  ;-)
and bad grammar - as Professor Higgins [My Fair Lady] said,
'and in America, they haven't used it for years'  ;-)



From: Tom Davies tomdavie...@yahoo.co.uk
Date: Wed, Jul 17, 2013 at 5:24 AM
Subject: Re: [OT] Re: [libreoffice-users] HSLQLDB syntax
To: users@global.libreoffice.org users@global.libreoffice.org


Hi :)
new and improved is hopefully a duplication rather than a contradiction!
lol.  Not always true, of course.

English (US) does tend to use different prepositions under English (GB).
Out advertising people also seems to just muddle them down to try to
reinforce their message.  Council estate kids and common usage also messes
things into.
Regards from
Tom :)





 From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org
Sent: Wednesday, 17 July 2013, 2:46
Subject: Re: [OT] Re: [libreoffice-users] HSLQLDB syntax


At 21:06 16/07/2013 -0400, Mark LaPierre wrote:
As long as we are going to entertain off topic, how about this.

[One] common figure of speech in English is the use of Try and
where the meaning is Try to.  I.E. I'm going to try and drive my
car backwards for three miles.  When I see it, or hear it, I wonder,
Are they going to try the car, or are they going to drive the
car?  Make up my mind!

I have to say I also prefer try to to try and, but Henry Fowler
says of the figure of speech given the classy Greek name hendiadys
(or one-through-two):

... 'nice and warm', 'try and do better', 'grace and favour',
instead of 'nicely warm', 'try to do better', 'gracious favour' are
true examples.

See http://en.wikipedia.org/wiki/Hendiadys .  Advertisers use it when
they claim their product is new and improved (which is a
contradiction), meaning newly improved.

Brian Barker


-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-17 Thread Mark LaPierre
Access is no back end.  As a front end it's fairly adaptable as long as 
the total file size does not exceed 2 Gb.  That 2 Gb limit pretty much 
rules it out as a back end for anything but very light weight databases.


On 07/17/2013 06:37 AM, Tom Davies wrote:

Hi :)
+1
to all that, especially the Once you are up to date, I'm sure they'd appreciate any 
help you can offer..  Plus, making yourself familiar with HsqlDb 1.8 is a good plan 
anyway.  HsqlDb is java based but it's small and fast so as an external back-end it's 
good for most uses.

My workplace is considering buying a specialist database that uses Firebird as 
a back-end so i kinda hope Base goes that way too.  Unfortunately they have 
left the final purchase decision up to someone outside the organisation that is 
fairly clueless about compatibility and the alternative back-end is Access.
Regards from
Tom :)







From: V Stuart Foote vstuart.fo...@utsa.edu
To: users@global.libreoffice.org users@global.libreoffice.org
Sent: Wednesday, 17 July 2013, 0:55
Subject: RE: [libreoffice-users] HSLQLDB syntax


Mark,

Hey why should you care that it is off topic, no one else seems to understand 
the concept ;-)

So, regards movement toward a non-Java JRE dependent default SQL DB for 
integration with the Base component.

Several Bugzilla items worth reviewing:

considering and rejecting SQLite as replacement
https://bugs.freedesktop.org/show_bug.cgi?id=38811

find a replacement for HSQLDB v1.8
https://bugs.freedesktop.org/show_bug.cgi?id=51781

considering an update to HSQLDB v2.x
https://bugs.freedesktop.org/show_bug.cgi?id=44854

move default to FireBird not HSQLDB in Base -- this is the current development 
effort
https://bugs.freedesktop.org/show_bug.cgi?id=51780

Finally, here is the Wiki based project coordination for implementing 
FirebirdSQL
https://wiki.documentfoundation.org/Development/Base/FirebirdSQL

Once you are up to date, I'm sure they'd appreciate any help you can offer.

Stuart


From: Mark LaPierre [marklap...@aol.com]
Sent: Tuesday, July 16, 2013 6:13 PM
Subject: Re: [libreoffice-users] HSLQLDB syntax

Well actually, I was going to ask what might replace HSQLDB but I
thought it might be a bit too far off topic.



--
To unsubscribe e-mail to: users+unsubscr...@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







--
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-17 Thread Tom Davies
Hi :)
http://www.lasa.org.uk/aims/choosing-the-right-package/

Just under the bullet-points it claims 

You can purchase AIMS Core which allows up
to 15 concurrent users. This version of AIMS is available in either Access or 
SQL versions.
 

So it's a bit unclear whether the Access version is using the normal jet-engine 
or  Microsoft SQL Server as it's back-end.  Either way i think there is a 
potential problem at being able to run their front-end, or use another 
front-end, on non-MS platforms such as Android tablets, Macs, iPads.  I suspect 
the Firebird back-end is more likely to be faster and more compatible with more 
platforms.  

Regards from
Tom :)  






 From: Mark LaPierre marklap...@aol.com
To: users@global.libreoffice.org 
Sent: Wednesday, 17 July 2013, 23:30
Subject: Re: [libreoffice-users] HSLQLDB syntax
 

Access is no back end.  As a front end it's fairly adaptable as long as 
the total file size does not exceed 2 Gb.  That 2 Gb limit pretty much 
rules it out as a back end for anything but very light weight databases.

On 07/17/2013 06:37 AM, Tom Davies wrote:
 Hi :)
 +1
 to all that, especially the Once you are up to date, I'm sure they'd 
 appreciate any help you can offer..  Plus, making yourself familiar with 
 HsqlDb 1.8 is a good plan anyway.  HsqlDb is java based but it's small and 
 fast so as an external back-end it's good for most uses.

 My workplace is considering buying a specialist database that uses Firebird 
 as a back-end so i kinda hope Base goes that way too.  Unfortunately they 
 have left the final purchase decision up to someone outside the organisation 
 that is fairly clueless about compatibility and the alternative back-end is 
 Access.
 Regards from
 Tom :)





 
 From: V Stuart Foote vstuart.fo...@utsa.edu
 To: users@global.libreoffice.org users@global.libreoffice.org
 Sent: Wednesday, 17 July 2013, 0:55
 Subject: RE: [libreoffice-users] HSLQLDB syntax


 Mark,

 Hey why should you care that it is off topic, no one else seems to 
 understand the concept ;-)

 So, regards movement toward a non-Java JRE dependent default SQL DB for 
 integration with the Base component.

 Several Bugzilla items worth reviewing:

 considering and rejecting SQLite as replacement
 https://bugs.freedesktop.org/show_bug.cgi?id=38811

 find a replacement for HSQLDB v1.8
 https://bugs.freedesktop.org/show_bug.cgi?id=51781

 considering an update to HSQLDB v2.x
 https://bugs.freedesktop.org/show_bug.cgi?id=44854

 move default to FireBird not HSQLDB in Base -- this is the current 
 development effort
 https://bugs.freedesktop.org/show_bug.cgi?id=51780

 Finally, here is the Wiki based project coordination for implementing 
 FirebirdSQL
 https://wiki.documentfoundation.org/Development/Base/FirebirdSQL

 Once you are up to date, I'm sure they'd appreciate any help you can offer.

 Stuart

 
 From: Mark LaPierre [marklap...@aol.com]
 Sent: Tuesday, July 16, 2013 6:13 PM
 Subject: Re: [libreoffice-users] HSLQLDB syntax

 Well actually, I was going to ask what might replace HSQLDB but I
 thought it might be a bit too far off topic.



 --
 To unsubscribe e-mail to: users+unsubscr...@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






-- 
     _
    °v°
   /(_)\
    ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
To unsubscribe e-mail to: users+unsubscr...@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



-- 
To unsubscribe e-mail to: users+unsubscr...@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



[OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Felmon Davis

On Sun, 14 Jul 2013, Doug wrote:


On 7/15/2013 12:25 PM, Felmon Davis wrote:

On Mon, 15 Jul 2013, anne-ology wrote:


  And just what is HSLQLDB  ;-)

This is not an acronym. It can't be pronounced as a word. (See dictionary
definition in URL below.)


the definition says:

-
 : a word (as NATO, radar, or laser) formed from the initial letter or 
letters of each of the successive parts or major parts of a compound 
term; also : an abbreviation (as FBI) formed from initial letters : 
initialism 
-


I'm missing the part about being pronounced as a word.



  oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
   wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's 
being

meant by what's being said  ;-)

 see -  http://www.merriam-webster.com/dictionary/acronym

  AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)


do you know SPQR? or INRI? or Q.E.D.?

None of these are acronyms either.



Senatus PupulusQue Romanus: did you know that the Roman street catchbasins
and manhole covers are marked SPQR? Yes, today.


interesting; never been to Rome, sorry to say.


Iesus Nazarenus Rex Iudaeorum


I just read today that according to one author, this was supposed to 
be a description of his 'crime', viz. insurrection against Roman 
authority.


anyway, off topic; my apologies.

F.


Quod Erat Demonstrandum

--doug





--
Felmon Davis

What a strange game.  The only winning move is not to play.
-- WOP, War Games

--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax (OT)

2013-07-16 Thread Doug

On 7/16/2013 2:02 AM, Felmon Davis wrote:



Iesus Nazarenus Rex Iudaeorum


I just read today that according to one author, this was supposed to 
be a description of his 'crime', viz. insurrection against Roman 
authority.


anyway, off topic; my apologies.

F.

The translation, of course, is, Jesus the Nazarene King of the Jews 
and if he was truly King of the Jews, it could be argued that this was
insurrection against Roman authority, but Biblically, it would seem that 
this is what the Jews accused him of stating, since they complained
to Pilate that the sign should read, He _said_ he was King of the 
Jews.  And Pilate replied, What I have written, I have written.


BTW, the first Latin Senatus PopulusQue Romanus had Populus misspelled. 
Sorry about that.


--doug

--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax (OT)

2013-07-16 Thread Felmon Davis

On Mon, 15 Jul 2013, Doug wrote:


On 7/16/2013 2:02 AM, Felmon Davis wrote:



Iesus Nazarenus Rex Iudaeorum


I just read today that according to one author, this was supposed to be a 
description of his 'crime', viz. insurrection against Roman authority.


anyway, off topic; my apologies.

F.

The translation, of course, is, Jesus the Nazarene King of the Jews and if 
he was truly King of the Jews, it could be argued that this was
insurrection against Roman authority, but Biblically, it would seem that this 
is what the Jews accused him of stating, since they complained
to Pilate that the sign should read, He _said_ he was King of the Jews. 
And Pilate replied, What I have written, I have written.


sure, Pilate executed him for insurrection.

but I messed up my main point which was, I didn't realize they 
actually hanged a sign on the cross naming the offense. I thought it 
was some later-day artist's fancy.


BTW, the first Latin Senatus PopulusQue Romanus had Populus misspelled. Sorry 
about that.


yeah, I know but I've played enough Latin on the list for now; I did 
look up 'pupulus' though and it's funny: means 'little boy' or a 
'puppet'. may be more truth in that!


F.

--
Felmon Davis

Let patience grow in your garden always.

--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread anne-ology
   acronyms ... acronyms ... acronyms ...  ;-)   :-(   ;-)   :-(
;-)   :-(

   Yet thank you for this explanation.



From: Tom Davies tomdavie...@yahoo.co.uk
Date: Mon, Jul 15, 2013 at 11:15 AM
Subject: Re: [libreoffice-users] HSLQLDB syntax
To: anne-ology lagin...@gmail.com, Mark LaPierre marklap...@aol.com
Cc: Mail List LibreOffice users@global.libreoffice.org


Hi :)
My guess is that he meant

H Sql Db

SQL = the standard language used by most database programs.  Most add a
little bit (few extra commands and stuff) to the basic language to help
ensure that people can't easily switch to another program even though they
all ostensibly use Sql.

Db = Database

H is the only bit that distinguishes exactly which program is being talked
about.

Note that other programs also use Sql or Db in their name.  For example
MySql/MariaDb, Postgresql.  Only Access doesn't have any of that in it's
name.  Of course MS make many claims that Access does use Sql but it's such
a heavily tweaked version of Sql that it's almost unrecognisable.  If you
learn Access then you need to forgetre-learn if you want to switch to
anything else.  The others tend to just have a few differences so it's not
so tough to move between them.  At least, so i have heard.

Regards from
Tom :)



  --
 *From:* anne-ology lagin...@gmail.com
*To:* Mark LaPierre marklap...@aol.com
*Cc:* Mail List LibreOffice users@global.libreoffice.org
*Sent:* Monday, 15 July 2013, 16:38
*Subject:* Re: [libreoffice-users] HSLQLDB syntax

  And just what is HSLQLDB  ;-)

  oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

  see -  http://www.merriam-webster.com/dictionary/acronym

  AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)
before then communication was simply speaking to be
understood  ;-)

  BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:


 On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
  HSLQLDB is a bit picky about the syntax

 Does anyone know where I can find a good reference on HSLQLDB syntax?

 --
_
°v°
  /(_)\
^ ^  Mark LaPierre
 Registered Linux user No #267004
 https://linuxcounter.net/
 


-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread anne-ology
   Thanks  :-)

   Now ... I thought Java was an out-dated thing -
 which no one used anymore and that should be dis-connected
from action  ;-)

   So it's come back with a convoluted acronym and websites hither 'n
yon  ;-)   ;-)   ;-)

   I guess I'll always remain behind in this electronic world ...
maze   ;-)




From: V Stuart Foote vstuart.fo...@utsa.edu
Date: Mon, Jul 15, 2013 at 11:34 AM
Subject: RE: [libreoffice-users] HSLQLDB syntax
To: Mail List LibreOffice users@global.libreoffice.org


STOP!

Anne, glad you're back but seriously?

HSQLDB  is the short title and Web address for HyperSQL, the Java language
based SQL relational database that StarOffice then Sun chose as the
imbedded database for the project.

Currently we include the 1.8 release, and efforts will either see that
ripped out of LibreOffice to be replaced, or the version of HSQLDB will be
upgraded to a current 2.3 release.

Mark, et al., all the details you could ever want  are on the project
webpage at hsqldb.org, just mind the version differences.

Stuart



From: Tom Davies [tomdavie...@yahoo.co.uk]
Sent: Monday, July 15, 2013 11:15 AM
To: anne-ology; Mark LaPierre
Cc: Mail List LibreOffice
Subject: Re: [libreoffice-users] HSLQLDB syntax

Hi :)
My guess is that he meant

H Sql Db

SQL = the standard language used by most database programs.  Most add a
little bit (few extra commands and stuff) to the basic language to help
ensure that people can't easily switch to another program even though they
all ostensibly use Sql.

Db = Database

H is the only bit that distinguishes exactly which program is being talked
about.

Note that other programs also use Sql or Db in their name.  For example
MySql/MariaDb, Postgresql.  Only Access doesn't have any of that in it's
name.  Of course MS make many claims that Access does use Sql but it's such
a heavily tweaked version of Sql that it's almost unrecognisable.  If you
learn Access then you need to forgetre-learn if you want to switch to
anything else.  The others tend to just have a few differences so it's not
so tough to move between them.  At least, so i have heard.

Regards from
Tom :)




 From: anne-ology lagin...@gmail.com
To: Mark LaPierre marklap...@aol.com
Cc: Mail List LibreOffice users@global.libreoffice.org
Sent: Monday, 15 July 2013, 16:38
Subject: Re: [libreoffice-users] HSLQLDB syntax


   And just what is HSLQLDB  ;-)

   oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

  see -  http://www.merriam-webster.com/dictionary/acronym

   AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)
before then communication was simply speaking to be
understood  ;-)

   BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:


 On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
  HSLQLDB is a bit picky about the syntax

 Does anyone know where I can find a good reference on HSLQLDB syntax?


-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread anne-ology
   Ah, Latin ... yes, I remember it ... a language which should again
be taught to students;
then maybe these slang terms, these acronyms, these non-words,
... ... ... would cease to exist, huh?   ;-)

   BTW - is there a word for a string of non-pronounceable letters
which ...
ah, maybe it's the same word used for those 2 lines
between the nose  upper lip, huh?  ;-)




From: Doug dmcgarr...@optonline.net
Date: Sun, Jul 14, 2013 at 2:31 PM
Subject: Re: [libreoffice-users] HSLQLDB syntax
To: users@global.libreoffice.org


On 7/15/2013 12:25 PM, Felmon Davis wrote:

 On Mon, 15 Jul 2013, anne-ology wrote:

And just what is HSLQLDB  ;-)

 This is not an acronym. It can't be pronounced as a word. (See dictionary
definition in URL below.)


   oh, memorizing acronyms seems to me a mighty complicated way to
 organize one's thoughts ...
wouldn't it be simpler - easier - to just state the
 object(s) rather than leaving the listener trying to interpret what's
 being
 meant by what's being said  ;-)

  see -  
 http://www.merriam-webster.**com/dictionary/acronymhttp://www.merriam-webster.com/dictionary/acronym

   AND - did you happen to notice in that URL, this phenomenon only
 started in 1943 ;-)


 do you know SPQR? or INRI? or Q.E.D.?

None of these are acronyms either.

Senatus PupulusQue Romanus: did you know that the Roman street catchbasins
and manhole covers are marked SPQR? Yes, today.

Iesus Nazarenus Rex Iudaeorum

Quod Erat Demonstrandum

--doug

-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Brian Barker

At 02:02 16/07/2013 -0400, Felmon Davis wrote:

On Sun, 14 Jul 2013, Doug wrote:
This is not an acronym. It can't be pronounced as a word. (See 
dictionary definition in URL below.)


the definition says:
-
 : a word (as NATO, radar, or laser) formed from the initial letter 
or letters of each of the successive parts or major parts of a 
compound term; [...]

-

I'm missing the part about being pronounced as a word.


May I help?  I think I can.  It's right there in the second word of 
the definition: it says it's a *word*, so it'll be pronounced as, er, a word!


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Felmon Davis

On Tue, 16 Jul 2013, Brian Barker wrote:


At 02:02 16/07/2013 -0400, Felmon Davis wrote:

On Sun, 14 Jul 2013, Doug wrote:
This is not an acronym. It can't be pronounced as a word. (See dictionary 
definition in URL below.)


the definition says:
-
 : a word (as NATO, radar, or laser) formed from the initial letter or 
letters of each of the successive parts or major parts of a compound term; 
[...]

-

I'm missing the part about being pronounced as a word.


May I help?  I think I can.  It's right there in the second word of the 
definition: it says it's a *word*, so it'll be pronounced as, er, a word!


ah, now I see where that comes from!

deviates from http://en.wikipedia.org/wiki/Acronym which counts the 
following formations as acronyms:


BBC: British Broadcasting Corporation
OEM: Original Equipment Manufacturer
USA: The United States of America
FGM: Female Genital Mutilation

or maybe it doesn't deviate after all since they can also be 
pronounced as words (any string of initials can).


I'm going to let Anne-ology make the call.

F.


--
Felmon Davis

Get on the bandwagon quickly or end up with the broom.

--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Mark LaPierre

On 07/15/2013 11:44 AM, V Stuart Foote:



STOP!

Anne, glad you're back but seriously?

HSQLDB  is the short title and Web address for HyperSQL, the Java language
based SQL relational database that StarOffice then Sun chose as the
imbedded database for the project.

Currently we include the 1.8 release, and efforts will either see that
ripped out of LibreOffice to be replaced, or the version of HSQLDB will be
upgraded to a current 2.3 release.

Mark, et al., all the details you could ever want  are on the project
webpage at hsqldb.org, just mind the version differences.

Stuart



Hey Stuart,

Thanks for the tip on the version.  I was not aware of that small fact. 
 I was starting to read the 2.3 documentation.



--
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


--
To unsubscribe e-mail to: users+unsubscr...@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


Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Tom Davies
Hi :)
I think it's a heavily tweaked 1.8 so not everything will work the way it's 
meant to.  Still, it would be great to have some idea of where LO's version is 
different from the upstream original.  Hmm, or perhaps just waitsee what 
goes into LO to replace it.  
Regards from 
Tom :)  






 From: Mark LaPierre marklap...@aol.com
To: users@global.libreoffice.org 
Sent: Tuesday, 16 July 2013, 23:22
Subject: Re: [libreoffice-users] HSLQLDB syntax
 

On 07/15/2013 11:44 AM, V Stuart Foote:


 STOP!

 Anne, glad you're back but seriously?

 HSQLDB  is the short title and Web address for HyperSQL, the Java language
 based SQL relational database that StarOffice then Sun chose as the
 imbedded database for the project.

 Currently we include the 1.8 release, and efforts will either see that
 ripped out of LibreOffice to be replaced, or the version of HSQLDB will be
 upgraded to a current 2.3 release.

 Mark, et al., all the details you could ever want  are on the project
 webpage at hsqldb.org, just mind the version differences.

 Stuart


Hey Stuart,

Thanks for the tip on the version.  I was not aware of that small fact. 
  I was starting to read the 2.3 documentation.


-- 
     _
    °v°
   /(_)\
    ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
To unsubscribe e-mail to: users+unsubscr...@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



-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Mark LaPierre
Well actually, I was going to ask what might replace HSQLDB but I 
thought it might be a bit too far off topic.


On 07/16/2013 07:04 PM, Tom Davies wrote:

Hi :)
I think it's a heavily tweaked 1.8 so not everything will work the way
it's meant to.  Still, it would be great to have some idea of where LO's
version is different from the upstream original.  Hmm, or perhaps just
waitsee what goes into LO to replace it.
Regards from
Tom :)



*From:* Mark LaPierre marklap...@aol.com
*To:* users@global.libreoffice.org
*Sent:* Tuesday, 16 July 2013, 23:22
*Subject:* Re: [libreoffice-users] HSLQLDB syntax

On 07/15/2013 11:44 AM, V Stuart Foote:
 
 
  STOP!
 
  Anne, glad you're back but seriously?
 
  HSQLDB  is the short title and Web address for HyperSQL, the Java
language
  based SQL relational database that StarOffice then Sun chose as the
  imbedded database for the project.
 
  Currently we include the 1.8 release, and efforts will either see
that
  ripped out of LibreOffice to be replaced, or the version of
HSQLDB will be
  upgraded to a current 2.3 release.
 
  Mark, et al., all the details you could ever want  are on the project
  webpage at hsqldb.org, just mind the version differences.
 
  Stuart
 

Hey Stuart,

Thanks for the tip on the version.  I was not aware of that small fact.
   I was starting to read the 2.3 documentation.


--
 _
 °v°
   /(_)\
 ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
mailto:unsubscr...@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





--
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


--
To unsubscribe e-mail to: users+unsubscr...@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


RE: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread V Stuart Foote
Mark,

Hey why should you care that it is off topic, no one else seems to understand 
the concept ;-)

So, regards movement toward a non-Java JRE dependent default SQL DB for 
integration with the Base component. 

Several Bugzilla items worth reviewing:

considering and rejecting SQLite as replacement
https://bugs.freedesktop.org/show_bug.cgi?id=38811

find a replacement for HSQLDB v1.8
https://bugs.freedesktop.org/show_bug.cgi?id=51781

considering an update to HSQLDB v2.x
https://bugs.freedesktop.org/show_bug.cgi?id=44854

move default to FireBird not HSQLDB in Base -- this is the current development 
effort
https://bugs.freedesktop.org/show_bug.cgi?id=51780

Finally, here is the Wiki based project coordination for implementing 
FirebirdSQL
https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
 
Once you are up to date, I'm sure they'd appreciate any help you can offer.

Stuart


From: Mark LaPierre [marklap...@aol.com]
Sent: Tuesday, July 16, 2013 6:13 PM
Subject: Re: [libreoffice-users] HSLQLDB syntax

Well actually, I was going to ask what might replace HSQLDB but I
thought it might be a bit too far off topic.



-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Tom Davies
Hi :)
Off-topic is relative.  Luckily not one of my relatives!  This thread has been 
all the way to ancient Rome.

Sorry if my grammer is a bit off.  She still hasn't recovered from lunch.  
Regards from 
Tom :)  






 From: Mark LaPierre marklap...@aol.com
To: Tom Davies tomdavie...@yahoo.co.uk 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
Sent: Wednesday, 17 July 2013, 0:13
Subject: Re: [libreoffice-users] HSLQLDB syntax
 

Well actually, I was going to ask what might replace HSQLDB but I 
thought it might be a bit too far off topic.

On 07/16/2013 07:04 PM, Tom Davies wrote:
 Hi :)
 I think it's a heavily tweaked 1.8 so not everything will work the way
 it's meant to.  Still, it would be great to have some idea of where LO's
 version is different from the upstream original.  Hmm, or perhaps just
 waitsee what goes into LO to replace it.
 Regards from
 Tom :)


     
     *From:* Mark LaPierre marklap...@aol.com
     *To:* users@global.libreoffice.org
     *Sent:* Tuesday, 16 July 2013, 23:22
     *Subject:* Re: [libreoffice-users] HSLQLDB syntax

     On 07/15/2013 11:44 AM, V Stuart Foote:
      
      
       STOP!
      
       Anne, glad you're back but seriously?
      
       HSQLDB  is the short title and Web address for HyperSQL, the Java
     language
       based SQL relational database that StarOffice then Sun chose as the
       imbedded database for the project.
      
       Currently we include the 1.8 release, and efforts will either see
     that
       ripped out of LibreOffice to be replaced, or the version of
     HSQLDB will be
       upgraded to a current 2.3 release.
      
       Mark, et al., all the details you could ever want  are on the project
       webpage at hsqldb.org, just mind the version differences.
      
       Stuart
      

     Hey Stuart,

     Thanks for the tip on the version.  I was not aware of that small fact.
        I was starting to read the 2.3 documentation.


     --
          _
          °v°
        /(_)\
          ^ ^  Mark LaPierre
     Registered Linux user No #267004
    https://linuxcounter.net/
     

     --
     To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
     mailto:unsubscr...@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




-- 
     _
    °v°
   /(_)\
    ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
To unsubscribe e-mail to: users+unsubscr...@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



-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Keith Bates
The base of the misunderstanding is the shift in meaning of the word 
acronym over the last few decades. It used to mean an abbreviation which 
formed a word- such as radar. Now it seems to be used more for an 
abbreviation which is more familiar than the original terms. e.g. most 
people know the BBC or the Beeb but fewer know it stands for British 
Broadcasting Corporation. In my experience bureaucracies spawn all kinds 
of meaningless terms which then get abbreviated-- these abbreviations 
become known as acronyms because everyone knows what the FHSAP does but 
nobody knows what the abbreviation stands for. (I just made that 
abbreviation up- there probably is one somewhere in your local, state or 
regional bureaucracy).


It's similar with the word electrocution which everyone over 50 knows is 
a fatal electric shock. Everyone under 50 seems to use it as an 
alternative to electric shock which leads to interesting phrases such as 
electrocuted to death and I've been electrocuted three times.


Life would be much simpler if they let the pedants run everything.

Keith

On 17/07/13 06:15, Felmon Davis wrote:

On Tue, 16 Jul 2013, Brian Barker wrote:


At 02:02 16/07/2013 -0400, Felmon Davis wrote:

On Sun, 14 Jul 2013, Doug wrote:
This is not an acronym. It can't be pronounced as a word. (See 
dictionary definition in URL below.)


the definition says:
-
 : a word (as NATO, radar, or laser) formed from the initial letter 
or letters of each of the successive parts or major parts of a 
compound term; [...]

-

I'm missing the part about being pronounced as a word.


May I help?  I think I can.  It's right there in the second word of 
the definition: it says it's a *word*, so it'll be pronounced as, er, 
a word!


ah, now I see where that comes from!

deviates from http://en.wikipedia.org/wiki/Acronym which counts the 
following formations as acronyms:


BBC: British Broadcasting Corporation
OEM: Original Equipment Manufacturer
USA: The United States of America
FGM: Female Genital Mutilation

or maybe it doesn't deviate after all since they can also be 
pronounced as words (any string of initials can).


I'm going to let Anne-ology make the call.

F.





--
God bless you
Keith Bates
4 Mooloobar St
Narrabri NSW
Ph 02 67924890

Jesus is the Way
the Truth and the Life


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Brian Barker

At 16:15 16/07/2013 -0400, Felmon Davis wrote:

On Tue, 16 Jul 2013, Brian Barker wrote:

At 02:02 16/07/2013 -0400, Felmon Davis wrote:

On Sun, 14 Jul 2013, Doug wrote:
This is not an acronym. It can't be pronounced as a word. (See 
dictionary definition in URL below.)

the definition says:
-
 : a word (as NATO, radar, or laser) formed from the initial 
letter or letters of each of the successive parts or major parts 
of a compound term; [...]

-
I'm missing the part about being pronounced as a word.


May I help?  I think I can.  It's right there in the second word of 
the definition: it says it's a *word*, so it'll be pronounced as, er, a word!


ah, now I see where that comes from!

deviates from http://en.wikipedia.org/wiki/Acronym which counts 
the following formations as acronyms:


BBC: British Broadcasting Corporation
OEM: Original Equipment Manufacturer
USA: The United States of America
FGM: Female Genital Mutilation

or maybe it doesn't deviate after all since they can also be 
pronounced as words (any string of initials can).


Oh no: they are indeed examples of initialisms that are not 
pronounced as words, so are not what I call acronyms.  But to be fair 
to Wikipedia, it does explain the distinction further up, but then 
says it will not follow it in the rest of the article:


Although the term _acronym_ is widely used to refer to any 
abbreviation formed from initial letters, some dictionaries define 
_acronym_ to mean a word in its original sense, while some others 
include additional senses attributing to _acronym_ the same meaning 
as that of _initialism_. The distinction, when made, hinges on 
whether the abbreviation is pronounced as a word, or as a string of 
letters. In such cases, examples found in dictionaries include 
_NATO_, _scuba_, and _radar_ for acronyms, and _FBI_ and _HTML_ for 
initialisms. In the rest of this article, this distinction is not made.



I'm going to let Anne-ology make the call.


Oh, we are all entitled to speak and write as we wish, of course.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Brian Barker

At 21:06 16/07/2013 -0400, Mark LaPierre wrote:

As long as we are going to entertain off topic, how about this.

[One] common figure of speech in English is the use of Try and 
where the meaning is Try to.  I.E. I'm going to try and drive my 
car backwards for three miles.  When I see it, or hear it, I wonder, 
Are they going to try the car, or are they going to drive the 
car?  Make up my mind!


I have to say I also prefer try to to try and, but Henry Fowler 
says of the figure of speech given the classy Greek name hendiadys 
(or one-through-two):


... 'nice and warm', 'try and do better', 'grace and favour', 
instead of 'nicely warm', 'try to do better', 'gracious favour' are 
true examples.


See http://en.wikipedia.org/wiki/Hendiadys .  Advertisers use it when 
they claim their product is new and improved (which is a 
contradiction), meaning newly improved.


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread anne-ology
   And just what is HSLQLDB  ;-)

   oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

  see -  http://www.merriam-webster.com/dictionary/acronym

   AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)
before then communication was simply speaking to be
understood  ;-)

   BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:


 On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
  HSLQLDB is a bit picky about the syntax

 Does anyone know where I can find a good reference on HSLQLDB syntax?

 --
 _
°v°
   /(_)\
^ ^  Mark LaPierre
 Registered Linux user No #267004
 https://linuxcounter.net/
 


-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Tom Davies
Hi :)
My guess is that he meant 

H Sql Db 

SQL = the standard language used by most database programs.  Most add a little 
bit (few extra commands and stuff) to the basic language to help ensure that 
people can't easily switch to another program even though they all ostensibly 
use Sql.  

Db = Database

H is the only bit that distinguishes exactly which program is being talked 
about.  

Note that other programs also use Sql or Db in their name.  For example 
MySql/MariaDb, Postgresql.  Only Access doesn't have any of that in it's name.  
Of course MS make many claims that Access does use Sql but it's such a heavily 
tweaked version of Sql that it's almost unrecognisable.  If you learn Access 
then you need to forgetre-learn if you want to switch to anything else.  The 
others tend to just have a few differences so it's not so tough to move between 
them.  At least, so i have heard.  

Regards from 
Tom :)







 From: anne-ology lagin...@gmail.com
To: Mark LaPierre marklap...@aol.com 
Cc: Mail List LibreOffice users@global.libreoffice.org 
Sent: Monday, 15 July 2013, 16:38
Subject: Re: [libreoffice-users] HSLQLDB syntax
 

       And just what is HSLQLDB  ;-)

       oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
                wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

      see -  http://www.merriam-webster.com/dictionary/acronym

       AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)
                before then communication was simply speaking to be
understood  ;-)

       BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:


 On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
  HSLQLDB is a bit picky about the syntax

 Does anyone know where I can find a good reference on HSLQLDB syntax?

 --
     _
    °v°
   /(_)\
    ^ ^  Mark LaPierre
 Registered Linux user No #267004
 https://linuxcounter.net/
 


-- 
To unsubscribe e-mail to: users+unsubscr...@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



-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Felmon Davis

On Mon, 15 Jul 2013, anne-ology wrote:


  And just what is HSLQLDB  ;-)

  oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
   wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

 see -  http://www.merriam-webster.com/dictionary/acronym

  AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)


do you know SPQR? or INRI? or Q.E.D.?


   before then communication was simply speaking to be
understood  ;-)

  BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:



On 07/13/2013 05:36 AM, Alexander Thurgood wrote:

HSLQLDB is a bit picky about the syntax


Does anyone know where I can find a good reference on HSLQLDB syntax?

--
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/







--
Felmon Davis
--
To unsubscribe e-mail to: users+unsubscr...@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



RE: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread V Stuart Foote
STOP!

Anne, glad you're back but seriously?

HSQLDB  is the short title and Web address for HyperSQL, the Java language 
based SQL relational database that StarOffice then Sun chose as the imbedded 
database for the project.

Currently we include the 1.8 release, and efforts will either see that ripped 
out of LibreOffice to be replaced, or the version of HSQLDB will be upgraded to 
a current 2.3 release.

Mark, et al., all the details you could ever want  are on the project webpage 
at hsqldb.org, just mind the version differences.

Stuart


From: Tom Davies [tomdavie...@yahoo.co.uk]
Sent: Monday, July 15, 2013 11:15 AM
To: anne-ology; Mark LaPierre
Cc: Mail List LibreOffice
Subject: Re: [libreoffice-users] HSLQLDB syntax

Hi :)
My guess is that he meant

H Sql Db

SQL = the standard language used by most database programs.  Most add a little 
bit (few extra commands and stuff) to the basic language to help ensure that 
people can't easily switch to another program even though they all ostensibly 
use Sql.

Db = Database

H is the only bit that distinguishes exactly which program is being talked 
about.

Note that other programs also use Sql or Db in their name.  For example 
MySql/MariaDb, Postgresql.  Only Access doesn't have any of that in it's name.  
Of course MS make many claims that Access does use Sql but it's such a heavily 
tweaked version of Sql that it's almost unrecognisable.  If you learn Access 
then you need to forgetre-learn if you want to switch to anything else.  The 
others tend to just have a few differences so it's not so tough to move between 
them.  At least, so i have heard.

Regards from
Tom :)


 From: anne-ology lagin...@gmail.com
To: Mark LaPierre marklap...@aol.com
Cc: Mail List LibreOffice users@global.libreoffice.org
Sent: Monday, 15 July 2013, 16:38
Subject: Re: [libreoffice-users] HSLQLDB syntax


   And just what is HSLQLDB  ;-)

   oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
    wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

  see -  http://www.merriam-webster.com/dictionary/acronym

   AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)
    before then communication was simply speaking to be
understood  ;-)

   BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:


 On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
  HSLQLDB is a bit picky about the syntax

 Does anyone know where I can find a good reference on HSLQLDB syntax?



-- 
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Doug

On 7/15/2013 12:25 PM, Felmon Davis wrote:

On Mon, 15 Jul 2013, anne-ology wrote:


  And just what is HSLQLDB  ;-)

This is not an acronym. It can't be pronounced as a word. (See dictionary
definition in URL below.)


  oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
   wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's 
being

meant by what's being said  ;-)

 see -  http://www.merriam-webster.com/dictionary/acronym

  AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)


do you know SPQR? or INRI? or Q.E.D.?

None of these are acronyms either.

Senatus PupulusQue Romanus: did you know that the Roman street catchbasins
and manhole covers are marked SPQR? Yes, today.

Iesus Nazarenus Rex Iudaeorum

Quod Erat Demonstrandum

--doug


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Girvin R. Herr
To keep the record straight, Stardivision's StarOffice did not use 
HSQLDB.  Unless the name has been changed, Stardivision used the ADABASE 
D database engine in their StarOffice.  As far as I can research, Sun 
dropped the proprietary Adabase D engine in favor of HSQLDB after it 
took over the StarOffice code from Stardivision.  I never was able to 
get Adabase D working for me back then, but I was ignorant of real 
(non-Access) databases then and the StarOffice Adabase D database 
documentation was terrible.

Girvin Herr


V Stuart Foote wrote:

STOP!

Anne, glad you're back but seriously?

HSQLDB  is the short title and Web address for HyperSQL, the Java language 
based SQL relational database that StarOffice then Sun chose as the imbedded 
database for the project.

Currently we include the 1.8 release, and efforts will either see that ripped 
out of LibreOffice to be replaced, or the version of HSQLDB will be upgraded to 
a current 2.3 release.

Mark, et al., all the details you could ever want  are on the project webpage 
at hsqldb.org, just mind the version differences.

Stuart


From: Tom Davies [tomdavie...@yahoo.co.uk]
Sent: Monday, July 15, 2013 11:15 AM
To: anne-ology; Mark LaPierre
Cc: Mail List LibreOffice
Subject: Re: [libreoffice-users] HSLQLDB syntax

Hi :)
My guess is that he meant

H Sql Db

SQL = the standard language used by most database programs.  Most add a little 
bit (few extra commands and stuff) to the basic language to help ensure that 
people can't easily switch to another program even though they all ostensibly 
use Sql.

Db = Database

H is the only bit that distinguishes exactly which program is being talked 
about.

Note that other programs also use Sql or Db in their name.  For example 
MySql/MariaDb, Postgresql.  Only Access doesn't have any of that in it's name.  Of 
course MS make many claims that Access does use Sql but it's such a heavily tweaked 
version of Sql that it's almost unrecognisable.  If you learn Access then you need 
to forgetre-learn if you want to switch to anything else.  The others tend to 
just have a few differences so it's not so tough to move between them.  At least, 
so i have heard.

Regards from
Tom :)

  


From: anne-ology lagin...@gmail.com
To: Mark LaPierre marklap...@aol.com
Cc: Mail List LibreOffice users@global.libreoffice.org
Sent: Monday, 15 July 2013, 16:38
Subject: Re: [libreoffice-users] HSLQLDB syntax


   And just what is HSLQLDB  ;-)

   oh, memorizing acronyms seems to me a mighty complicated way to
organize one's thoughts ...
wouldn't it be simpler - easier - to just state the
object(s) rather than leaving the listener trying to interpret what's being
meant by what's being said  ;-)

  see -  http://www.merriam-webster.com/dictionary/acronym

   AND - did you happen to notice in that URL, this phenomenon only
started in 1943 ;-)
before then communication was simply speaking to be
understood  ;-)

   BTW - many of these acronyms are duplicated - which causes even more
confusion to the listener  ;-)



On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote:




On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
  

HSLQLDB is a bit picky about the syntax


Does anyone know where I can find a good reference on HSLQLDB syntax?

  



  


--
To unsubscribe e-mail to: users+unsubscr...@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



Re: [libreoffice-users] HSLQLDB syntax

2013-07-14 Thread Mark Stanton
Google

When you spell it right, with just those two words you'll get, if 
it's the same as for me, 116k hits.

Mark Stanton
One small step for mankind...



-- 
To unsubscribe e-mail to: users+unsubscr...@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



[libreoffice-users] HSLQLDB syntax

2013-07-13 Thread Mark LaPierre


On 07/13/2013 05:36 AM, Alexander Thurgood wrote:
 HSLQLDB is a bit picky about the syntax

Does anyone know where I can find a good reference on HSLQLDB syntax?

--
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


--
To unsubscribe e-mail to: users+unsubscr...@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