Re: [semi OT] mySQL question

[Ken Ray via use-livecode]

I would recommend a table for People, a table for Companies, and a table for 
Employment that acts as a linking table between the first two. Something like 
(at its simplest):

people

id  INT(11)
first_name  VARCHAR(255)
last_name   VARCHAR(255)


companies
===
id  INT(11)
nameVARCHAR(255)


employment

id  INT(11)
person_id   INT(11) 
company_id  INT(11)
job_descrip VARCHAR(255)


To get a list of everyone that worked at a particular company, you'd do:

SELECT * FROM people
INNER JOIN employment ON (people.id = employment.person_id)
INNER JOIN companies ON (employment.company_id = companies.id)
WHERE companies.name="XYZ, Inc."

To get a list of all companies where a person has worked, you'd do:

SELECT * FROM companies
INNER JOIN employment ON (companies.id = employment.company_id)
INNER JOIN people ON (employment.person_id = people.id)
WHERE people.first_name="John" AND people.last_name="Smith"

Make sure to index the 'id' and '_id' columns, and you can use the 
employment.job_descrip to hold info on the particular job an individual had at 
a specific company.

This is all off the top of my head, so it may need a little massaging, but you 
get the idea.


Ken Ray
Sons of Thunder Software, Inc.
Email: k...@sonsothunder.com
Website: https://www.sonsothunder.com


> On May 11, 2023, at 9:55 AM, jbv via use-livecode 
>  wrote:
> 
> Hi list,
> 
> This is a question for mySQL experts, which I am not.
> 
> I have a table of individuals.
> I have another table of companies.
> 
> Many individuals have worked in more than 1 company with
> different jobs descriptions.
> 
> I need to build my DB so that, with single requests, I
> can get a list of either :
> - all individuals who worked in a specific company with
> the job description of each one
> - all companies in which a specific individual has worked,
> along with the job description he had in each company.
> 
> The main problem is that the tables might become huge with
> the time (several Gb), so searching the tables might take
> forever if not carefully built.
> 
> I guess I will need to use a third table for the job descriptions
> and a combination of fulltext indexes and foreign keys
> might do the trick, but my limited skills don't allow me
> to find the best solution...
> 
> Any help will be much appreciated.
> Thank you in advance.
> 
> jbv
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode






___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Am I using the best mail client?

[Richmond Mathewson via use-livecode]

We could transform this thread into a quite a spat as to the advantages of
the Use-List versus the Forums, but as Thee, Thee, Thee and Me are all so
fixed in our views it would only end in verbal bloodshed it best be let
alone: Thee with They words, and Me with My pictures! Let us attempt (at
the very least) some semblance of civilised discourse by leaving the topic
untouched and, with a nod of the head, a wink, and a smile  agreeing to
disagree.

Better be like that (however Thou feelest about the Subjunctive - and the
use of quasi-Germanic capitalisation) and listen, read, and learn from each
other than come to blows over something that will tarnish our shades when,
in time to come, we are mouldering in our sepulchres.

And, as to email clients, as my Granny said (or should have if my memory is
creative), "Taste is all in the mouth."

And, remember, only a Scotsman can produce English like that, or certainly
since the death of Samuel Johnson.

Yours, aye, Richmond Mathewson.

On Thu, 11 May 2023, 21:52 Craig Newman via use-livecode, <
use-livecode@lists.runrev.com> wrote:

> Thank you all.
>
> I will stick with the Mac client.
>
> The reason I like the forums better is what I see as a far more helpful
> UI. We all know how it works.
>
> Enough said of this.
>
> Craig
>
> > On May 11, 2023, at 2:02 PM, Richmond Mathewson via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > I use Betterbird, an improved split off from Thunderbird.
> >
> > On Thu, 11 May 2023, 20:37 Phil Davis via use-livecode, <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Thunderbird for me as well, for all the reasons Jacque stated.
> >>
> >> Phil Davis
> >>
> >>
> >> On 5/11/23 10:27 AM, J. Landman Gay via use-livecode wrote:
> >>> I use Thunderbird. Like Matthias, I set up a rule to move list mail
> >>> into a subfolder where I can sort by date, author,, subject, or any
> >>> other attribute. It supportsl threading. There are several layouts you
> >>> can use depending on how you like to organize and view mail. You can
> >>> color-code emails automatically on arrival, or manually if you want to
> >>> mark one for special reasons. You can drag-drop mail from one folder
> >>> to another even across accounts.
> >>>
> >>> There are a lot of options so you can customize it however you want.
> >>>
> >>> --
> >>> Jacqueline Landman Gay | jac...@hyperactivesw.com
> >>> HyperActive Software | http://www.hyperactivesw.com
> >>> On May 11, 2023 11:33:31 AM Craig Newman via use-livecode
> >>>  wrote:
> >>>
>  Since I got real help here, and not on the forum(hmph), I am
>  wondering if the eMail client I am using is one reason I do not
>  prefer this venue.
> 
>  I am using the native Mac “Mail’ client. Are there much better ones?
> 
>  Craig
>  ___
>  use-livecode mailing list
>  use-livecode@lists.runrev.com
>  Please visit this url to subscribe, unsubscribe and manage your
>  subscription preferences:
>  http://lists.runrev.com/mailman/listinfo/use-livecode
> >>>
> >>>
> >>>
> >>>
> >>> ___
> >>> use-livecode mailing list
> >>> use-livecode@lists.runrev.com
> >>> Please visit this url to subscribe, unsubscribe and manage your
> >>> subscription preferences:
> >>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> >> --
> >> Phil Davis
> >> (503) 307-4363
> >>
> >>
> >> ___
> >> use-livecode mailing list
> >> use-livecode@lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Am I using the best mail client?

[Craig Newman via use-livecode]

Thank you all.

I will stick with the Mac client.

The reason I like the forums better is what I see as a far more helpful UI. We 
all know how it works.

Enough said of this.

Craig

> On May 11, 2023, at 2:02 PM, Richmond Mathewson via use-livecode 
>  wrote:
> 
> I use Betterbird, an improved split off from Thunderbird.
> 
> On Thu, 11 May 2023, 20:37 Phil Davis via use-livecode, <
> use-livecode@lists.runrev.com> wrote:
> 
>> Thunderbird for me as well, for all the reasons Jacque stated.
>> 
>> Phil Davis
>> 
>> 
>> On 5/11/23 10:27 AM, J. Landman Gay via use-livecode wrote:
>>> I use Thunderbird. Like Matthias, I set up a rule to move list mail
>>> into a subfolder where I can sort by date, author,, subject, or any
>>> other attribute. It supportsl threading. There are several layouts you
>>> can use depending on how you like to organize and view mail. You can
>>> color-code emails automatically on arrival, or manually if you want to
>>> mark one for special reasons. You can drag-drop mail from one folder
>>> to another even across accounts.
>>> 
>>> There are a lot of options so you can customize it however you want.
>>> 
>>> --
>>> Jacqueline Landman Gay | jac...@hyperactivesw.com
>>> HyperActive Software | http://www.hyperactivesw.com
>>> On May 11, 2023 11:33:31 AM Craig Newman via use-livecode
>>>  wrote:
>>> 
 Since I got real help here, and not on the forum(hmph), I am
 wondering if the eMail client I am using is one reason I do not
 prefer this venue.
 
 I am using the native Mac “Mail’ client. Are there much better ones?
 
 Craig
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>>> 
>>> 
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> --
>> Phil Davis
>> (503) 307-4363
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Am I using the best mail client?

[Richmond Mathewson via use-livecode]

I use Betterbird, an improved split off from Thunderbird.

On Thu, 11 May 2023, 20:37 Phil Davis via use-livecode, <
use-livecode@lists.runrev.com> wrote:

> Thunderbird for me as well, for all the reasons Jacque stated.
>
> Phil Davis
>
>
> On 5/11/23 10:27 AM, J. Landman Gay via use-livecode wrote:
> > I use Thunderbird. Like Matthias, I set up a rule to move list mail
> > into a subfolder where I can sort by date, author,, subject, or any
> > other attribute. It supportsl threading. There are several layouts you
> > can use depending on how you like to organize and view mail. You can
> > color-code emails automatically on arrival, or manually if you want to
> > mark one for special reasons. You can drag-drop mail from one folder
> > to another even across accounts.
> >
> > There are a lot of options so you can customize it however you want.
> >
> > --
> > Jacqueline Landman Gay | jac...@hyperactivesw.com
> > HyperActive Software | http://www.hyperactivesw.com
> > On May 11, 2023 11:33:31 AM Craig Newman via use-livecode
> >  wrote:
> >
> >> Since I got real help here, and not on the forum(hmph), I am
> >> wondering if the eMail client I am using is one reason I do not
> >> prefer this venue.
> >>
> >> I am using the native Mac “Mail’ client. Are there much better ones?
> >>
> >> Craig
> >> ___
> >> use-livecode mailing list
> >> use-livecode@lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> >
> >
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> --
> Phil Davis
> (503) 307-4363
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Old license etc.

[matthias rebbe via use-livecode]

Although Heather asked you to send your query to support I would like to chime 
in, as I think some of your questions are more general. ;)

I also have Livecode (aka On-Rev) lifetime hosting. This is just Webhosting but 
also with the possibility to use Livecode Server on that hosting account, even 
if you do not own a Livecode Server license or subscription.
According to the date when you've had  purchased the lifetime hosting package 
it includes either 100 or 50GB. That is definitely enough for hosting several 
web sites.;)

HTML5 is still in development and the progress which can be seen in LC 10DP4 or 
5, is very promising.

Kevin stated that Xavvi is a separate product which has to be licensed 
separately because it's nature that it is more than a cloud service.
I think that is reasonable.
There was a Q yesterday about Xavvi which maybe of interest for you.
Since it is publicly available, i think it's okay if i post the Youtube link 
here
https://www.youtube.com/watch?v=vAHGn8PSdAA

Regards,
Matthias

> Am 11.05.2023 um 19:02 schrieb Linda Miller via use-livecode 
> :
> 
> I have been away from coding for years. I have a LiveCode Hosting Lifetime 
> License that, I think, I bought during one of LC’s campaigns for HTML5 to be 
> built. 
> 
> Whatever happened with HTML5 and LC?
> How can I find the “terms” that were listed for my Lifetime Hosting License? 
> I believe that the terms are different than what you can purchase today. So, 
> a link to today’s terms is not what I am looking for. I tried the Internet 
> Archive but couldn’t find anything.
> 
> I know that lifetime commercial or business licenses for LC were available in 
> the past. What are their terms? Would that license also cover XAVVI? Or, are 
> they going to be separate products?
> 
> Linda
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Am I using the best mail client?

[Phil Davis via use-livecode]

Thunderbird for me as well, for all the reasons Jacque stated.

Phil Davis


On 5/11/23 10:27 AM, J. Landman Gay via use-livecode wrote:
I use Thunderbird. Like Matthias, I set up a rule to move list mail 
into a subfolder where I can sort by date, author,, subject, or any 
other attribute. It supportsl threading. There are several layouts you 
can use depending on how you like to organize and view mail. You can 
color-code emails automatically on arrival, or manually if you want to 
mark one for special reasons. You can drag-drop mail from one folder 
to another even across accounts.


There are a lot of options so you can customize it however you want.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
On May 11, 2023 11:33:31 AM Craig Newman via use-livecode 
 wrote:


Since I got real help here, and not on the forum(hmph), I am 
wondering if the eMail client I am using is one reason I do not 
prefer this venue.


I am using the native Mac “Mail’ client. Are there much better ones?

Craig
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


--
Phil Davis
(503) 307-4363


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Old license etc.

[Heather Laine via use-livecode]

Linda, please post your query to supp...@livecode.com and I'll be happy to help.

Best Regards,

Heather
Heather Laine
Customer Services Manager
LiveCode Ltd
www.livecode.com



> On 11 May 2023, at 18:02, Linda Miller via use-livecode 
>  wrote:
> 
> I have been away from coding for years. I have a LiveCode Hosting Lifetime 
> License that, I think, I bought during one of LC’s campaigns for HTML5 to be 
> built. 
> 
> Whatever happened with HTML5 and LC?
> How can I find the “terms” that were listed for my Lifetime Hosting License? 
> I believe that the terms are different than what you can purchase today. So, 
> a link to today’s terms is not what I am looking for. I tried the Internet 
> Archive but couldn’t find anything.
> 
> I know that lifetime commercial or business licenses for LC were available in 
> the past. What are their terms? Would that license also cover XAVVI? Or, are 
> they going to be separate products?
> 
> Linda
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Am I using the best mail client?

[J. Landman Gay via use-livecode]

I use Thunderbird. Like Matthias, I set up a rule to move list mail into a 
subfolder where I can sort by date, author,, subject, or any other 
attribute. It supportsl threading. There are several layouts you can use 
depending on how you like to organize and view mail. You can color-code 
emails automatically on arrival, or manually if you want to mark one for 
special reasons. You can drag-drop mail from one folder to another even 
across accounts.


There are a lot of options so you can customize it however you want.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
On May 11, 2023 11:33:31 AM Craig Newman via use-livecode 
 wrote:


Since I got real help here, and not on the forum(hmph), I am wondering if 
the eMail client I am using is one reason I do not prefer this venue.


I am using the native Mac “Mail’ client. Are there much better ones?

Craig
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Old license etc.

[Linda Miller via use-livecode]

I have been away from coding for years. I have a LiveCode Hosting Lifetime 
License that, I think, I bought during one of LC’s campaigns for HTML5 to be 
built. 

Whatever happened with HTML5 and LC?
How can I find the “terms” that were listed for my Lifetime Hosting License? I 
believe that the terms are different than what you can purchase today. So, a 
link to today’s terms is not what I am looking for. I tried the Internet 
Archive but couldn’t find anything.

I know that lifetime commercial or business licenses for LC were available in 
the past. What are their terms? Would that license also cover XAVVI? Or, are 
they going to be separate products?

Linda
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Am I using the best mail client?

[matthias rebbe via use-livecode]

I am using also the "normal" Mac Client w/o any problem with the use list.

I am accessing my email account using Imap protocoll and i created an email 
alias for the uselist and a subfolder to which the emails automatically are 
copied. 
So no mess in my main inbox and also a nice  and proper email folder just with 
Livecode use list emails.

Regards,
Matthias

> Am 11.05.2023 um 18:30 schrieb Craig Newman via use-livecode 
> :
> 
> Since I got real help here, and not on the forum(hmph), I am wondering if the 
> eMail client I am using is one reason I do not prefer this venue.
> 
> I am using the native Mac “Mail’ client. Are there much better ones?
> 
> Craig
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Am I using the best mail client?

[Craig Newman via use-livecode]

Since I got real help here, and not on the forum(hmph), I am wondering if the 
eMail client I am using is one reason I do not prefer this venue.

I am using the native Mac “Mail’ client. Are there much better ones?

Craig
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: generate an Array using value for naming the keys?

[matthias rebbe via use-livecode]

Thanks for this also. I will keep that in mind, but for now i will use the & 
syntax.

Format() is also a function i often struggle with. ;)

> Am 11.05.2023 um 16:51 schrieb Mark Waddingham via use-livecode 
> :
> 
> On 2023-05-11 15:47, matthias rebbe via use-livecode wrote:
>> Mark, thank you very much!
>> i didn't know or remember that the key name of an array can be created 
>> directly using strings and variables
>> Maybe i even did that in the past, but could not remember anymore. I really 
>> thought i have solved it that time with value()  :)
> 
> No problem - of course, I used & in my example - but when I'm doing stuff 
> like that I tend to use format:
> 
> put tFoo[format("wp_%s_%s", tMiddlePart, tSuffix)] into tMiddlePartSuffixValue
> 
> It does the same job, but I find it more readable (as the structure of the 
> string can be seen immediately without having to wade through quotes and 
> ampersands :)
> 
> Warmest Regards,
> 
> Mark.
> 
> -- 
> Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
> LiveCode: Build Amazing Things
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: generate an Array using value for naming the keys?

[Ralph DiMola via use-livecode]

Mark,
I will start doing this. I have a headache just thinking of the last time I
had some complex keys and trying to read the code with the afore mentioned
quotes and ampersands. Learn something new every day. 

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Mark Waddingham via use-livecode
Sent: Thursday, May 11, 2023 10:51 AM
To: How to use LiveCode
Cc: Mark Waddingham
Subject: Re: generate an Array using value for naming the keys?

On 2023-05-11 15:47, matthias rebbe via use-livecode wrote:
> Mark, thank you very much!
> 
> i didn't know or remember that the key name of an array can be created 
> directly using strings and variables
> 
> Maybe i even did that in the past, but could not remember anymore. I 
> really thought i have solved it that time with value()  :)

No problem - of course, I used & in my example - but when I'm doing stuff
like that I tend to use format:

put tFoo[format("wp_%s_%s", tMiddlePart, tSuffix)] into
tMiddlePartSuffixValue

It does the same job, but I find it more readable (as the structure of the
string can be seen immediately without having to wade through quotes and
ampersands :)

Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

[semi OT] mySQL question

[jbv via use-livecode]

Hi list,

This is a question for mySQL experts, which I am not.

I have a table of individuals.
I have another table of companies.

Many individuals have worked in more than 1 company with
different jobs descriptions.

I need to build my DB so that, with single requests, I
can get a list of either :
- all individuals who worked in a specific company with
the job description of each one
- all companies in which a specific individual has worked,
along with the job description he had in each company.

The main problem is that the tables might become huge with
the time (several Gb), so searching the tables might take
forever if not carefully built.

I guess I will need to use a third table for the job descriptions
and a combination of fulltext indexes and foreign keys
might do the trick, but my limited skills don't allow me
to find the best solution...

Any help will be much appreciated.
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Different default bg color of stacks Mac/Win

[Klaus major-k via use-livecode]

Hi Mark,

> Am 11.05.2023 um 16:54 schrieb Mark Waddingham via use-livecode 
> :
> On 2023-05-11 15:51, Klaus major-k via use-livecode wrote:
>> Hi Mark,
>>> Am 11.05.2023 um 16:49 schrieb Mark Waddingham via use-livecode 
>>> :
>>> On 2023-05-11 15:45, Klaus major-k via use-livecode wrote:
 See screenshot of a stack with two OPAQUE (and white) text fields created
 on Mac and opened on Windows. Surprise, surprise...
 
 Is this a bug or feature?
 If a bug, should I create a report for that?
>>> Not a bug - the default is to use 'native' themes on desktop platforms, and 
>>> that also
>>> influences the background color of a stack.
>> aha, thanks for the quick answer. Is this documented somewhere?
> 
> Yes - in the dictionary entry for the backgroundColor property of objects:
> ```
> Cross-platform note: On Mac OS, OS X, and Windows systems, if the 
> backgroundColor of all objects in the object hierarchy is empty, the 
> background color set by the system is used.
> ```

Aha, thank you!

> Warmest Regards,
> 
> Mark.

Best

Klaus

--
Klaus Major
https://www.major-k.de
https://www.major-k.de/bass
kl...@major-k.de


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Different default bg color of stacks Mac/Win

[Mark Waddingham via use-livecode]

On 2023-05-11 15:51, Klaus major-k via use-livecode wrote:

Hi Mark,

Am 11.05.2023 um 16:49 schrieb Mark Waddingham via use-livecode 
:


On 2023-05-11 15:45, Klaus major-k via use-livecode wrote:
See screenshot of a stack with two OPAQUE (and white) text fields 
created

on Mac and opened on Windows. Surprise, surprise...

Is this a bug or feature?
If a bug, should I create a report for that?


Not a bug - the default is to use 'native' themes on desktop 
platforms, and that also

influences the background color of a stack.


aha, thanks for the quick answer. Is this documented somewhere?


Yes - in the dictionary entry for the backgroundColor property of 
objects:


```
Cross-platform note: On Mac OS, OS X, and Windows systems, if the 
backgroundColor of all objects in the object hierarchy is empty, the 
background color set by the system is used.

```

Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Different default bg color of stacks Mac/Win

[Klaus major-k via use-livecode]

Hi Mark,

> Am 11.05.2023 um 16:49 schrieb Mark Waddingham via use-livecode 
> :
> 
> On 2023-05-11 15:45, Klaus major-k via use-livecode wrote:
>> See screenshot of a stack with two OPAQUE (and white) text fields created
>> on Mac and opened on Windows. Surprise, surprise...
>> 
>> Is this a bug or feature?
>> If a bug, should I create a report for that?
> 
> Not a bug - the default is to use 'native' themes on desktop platforms, and 
> that also
> influences the background color of a stack.

aha, thanks for the quick answer. Is this documented somewhere?

> If you don't want that - then you need to explicitly set the background color.

NOW I know and will never forget! :-)

> Warmest Regards,
> 
> Mark.

Best

Klaus

--
Klaus Major
https://www.major-k.de
https://www.major-k.de/bass
kl...@major-k.de


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: generate an Array using value for naming the keys?

[Mark Waddingham via use-livecode]

On 2023-05-11 15:47, matthias rebbe via use-livecode wrote:

Mark, thank you very much!

i didn't know or remember that the key name of an array can be created 
directly using strings and variables


Maybe i even did that in the past, but could not remember anymore. I 
really thought i have solved it that time with value()  :)


No problem - of course, I used & in my example - but when I'm doing 
stuff like that I tend to use format:


put tFoo[format("wp_%s_%s", tMiddlePart, tSuffix)] into 
tMiddlePartSuffixValue


It does the same job, but I find it more readable (as the structure of 
the string can be seen immediately without having to wade through quotes 
and ampersands :)


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Different default bg color of stacks Mac/Win

[Mark Waddingham via use-livecode]

On 2023-05-11 15:45, Klaus major-k via use-livecode wrote:
See screenshot of a stack with two OPAQUE (and white) text fields 
created

on Mac and opened on Windows. Surprise, surprise...



Is this a bug or feature?
If a bug, should I create a report for that?


Not a bug - the default is to use 'native' themes on desktop platforms, 
and that also

influences the background color of a stack.

If you don't want that - then you need to explicitly set the background 
color.


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: generate an Array using value for naming the keys?

[matthias rebbe via use-livecode]

Mark, thank you very much!

i didn't know or remember that the key name of an array can be created directly 
using strings and variables

Maybe i even did that in the past, but could not remember anymore. I really 
thought i have solved it that time with value()  :) 

Regards,
Matthias

> Am 11.05.2023 um 16:36 schrieb Mark Waddingham via use-livecode 
> :
> 
> On 2023-05-11 14:36, matthias rebbe via use-livecode wrote:
>> The middle part of the key names changes and there can be about 50 different 
>> "middle parts" and there are 10 main keys (after the middle part)
>> _content, _text _html and so on.
>> So without an idea i would have to create the code to fill all values for 
>> the array keys with the middle part aa and then the code  for the middle 
>> part cd and so on.
>> Is there a way to use value for this. So i could just add the middle part of 
>> the key name to a variable and use that then with value() to create and file 
>> the array?
> 
> Perhaps I'm misunderstanding what you are trying to do as you mention using 
> value() for something which doesn't sound like it needs it...
> 
> Array keys can be arbitrary (string-valued) expressions - i.e. they don't 
> have to be literal strings:
> 
> e.g. put tFoo["wp_" & tMiddlePart & "_" & tSuffix] into tMiddlePartSuffixValue
> 
> Warmest Regards,
> 
> Mark.
> 
> -- 
> Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
> LiveCode: Build Amazing Things
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Different default bg color of stacks Mac/Win

[Klaus major-k via use-livecode]

Hi friends,

this week I have been bitten again by the fact that the default bg color 
of a stack is different on a Mac an Windows!

If you don't set the bg color of a new stack on a Mac it will be WHITE.
If you then open that stack on Windows, the bg color is a light grey. :-/

See screenshot of a stack with two OPAQUE (and white) text fields created 
on Mac and opened on Windows. Surprise, surprise...



Is this a bug or feature? 
If a bug, should I create a report for that?


Best

Klaus
--
Klaus Major
https://www.major-k.de
https://www.major-k.de/bass
kl...@major-k.de


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: generate an Array using value for naming the keys?

[Mark Waddingham via use-livecode]

On 2023-05-11 14:36, matthias rebbe via use-livecode wrote:
The middle part of the key names changes and there can be about 50 
different "middle parts" and there are 10 main keys (after the middle 
part)

_content, _text _html and so on.

So without an idea i would have to create the code to fill all values 
for the array keys with the middle part aa and then the code  for the 
middle part cd and so on.


Is there a way to use value for this. So i could just add the middle 
part of the key name to a variable and use that then with value() to 
create and file the array?


Perhaps I'm misunderstanding what you are trying to do as you mention 
using value() for something which doesn't sound like it needs it...


Array keys can be arbitrary (string-valued) expressions - i.e. they 
don't have to be literal strings:


e.g. put tFoo["wp_" & tMiddlePart & "_" & tSuffix] into 
tMiddlePartSuffixValue


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Build Amazing Things

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

generate an Array using value for naming the keys?

[matthias rebbe via use-livecode]

Hi,

once in a while i am struggling with value(). ;) 

I have the following problem.
I need to create an array which keys are something like this

wp_aa_old
wp_cd_old
wp_ek_old
wp_aa_new
wp_cd_new

and so on.

The middle part of the key names changes and there can be about 50 different 
"middle parts" and there are 10 main keys (after the middle part)
_content, _text _html and so on.

So without an idea i would have to create the code to fill all values for the 
array keys with the middle part aa and then the code  for the middle part cd 
and so on.

Is there a way to use value for this. So i could just add the middle part of 
the key name to a variable and use that then with value() to create and file 
the array?

I think i have done this before, but i might be wrong.

Regards,
Matthias


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Cannot make a standalone after upgrading to Mac Mini and Ventura

[Craig Newman via use-livecode]

What a GREAT community this is here on the use-list.

Craig

> On May 10, 2023, at 4:58 PM, Ralph DiMola via use-livecode 
>  wrote:
> 
> I had this happen when I had more than one license. One old and a new with
> "pro". I picked the one(default) without the "pro" features and had only a
> couple of platforms. I relicensed selected "pro" and had all platforms.
> 
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdim...@evergreeninfo.net
> 
> 
> -Original Message-
> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
> Of Craig Newman via use-livecode
> Sent: Wednesday, May 10, 2023 4:51 PM
> To: How to use LiveCode
> Cc: Craig Newman
> Subject: Cannot make a standalone after upgrading to Mac Mini and Ventura
> 
> All.
> Help
> I got a new Mac Mini a month ago. Lovely. Working with LC on it. Lovely.
> 
> I tried to make a windows standalone from the same project I have for years.
> In the Applications Settings I cannot select the Windows pane. It is
> essentially disabled, and looks like it.
> 
> In fact, I cannot select any pane except the Mac one. The Mac standalone
> proceeds as usual, but there is nothing done on the Windows side.
> 
> I made a brand new stack. Same issue; only the Mac pane is accessible.
> 
> Before I put the splash stack and the mainStack on a thumb drive and reload
> them back on my old iMac to make an updated standalone, is it me or Ventura?
> 
> Craig
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Cannot make a standalone after upgrading to Mac Mini and Ventura

[Craig Newman via use-livecode]

Heather.

THANK YOU. That worked.

Not that I care much, but was it Ventura or the new machine itself that 
required re-licensing? 

Ralph.

Thanks to you as well.

Craig

> On May 11, 2023, at 4:09 AM, Heather Laine via use-livecode 
>  wrote:
> 
> You probably need to switch licenses. This lesson may be helpful:
> 
> https://lessons.livecode.com/m/4072/l/1542014-i-have-a-valid-license-but-lc-says-it-is-expiring
>  
> 
> 
> If that doesn't solve it please email support :)
> 
> Best Regards,
> 
> Heather
> 
> Heather Laine
> Customer Services Manager
> LiveCode Ltd
> www.livecode.com
> 
> 
> 
>> On 10 May 2023, at 21:51, Craig Newman via use-livecode 
>>  wrote:
>> 
>> All.
>> Help
>> I got a new Mac Mini a month ago. Lovely. Working with LC on it. Lovely.
>> 
>> I tried to make a windows standalone from the same project I have for years. 
>> In the Applications Settings I cannot select the Windows pane. It is 
>> essentially disabled, and looks like it.
>> 
>> In fact, I cannot select any pane except the Mac one. The Mac standalone 
>> proceeds as usual, but there is nothing done on the Windows side.
>> 
>> I made a brand new stack. Same issue; only the Mac pane is accessible.
>> 
>> Before I put the splash stack and the mainStack on a thumb drive and reload 
>> them back on my old iMac to make an updated standalone, is it me or Ventura?
>> 
>> Craig
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Cannot make a standalone after upgrading to Mac Mini and Ventura

[Heather Laine via use-livecode]

You probably need to switch licenses. This lesson may be helpful:

https://lessons.livecode.com/m/4072/l/1542014-i-have-a-valid-license-but-lc-says-it-is-expiring
 


If that doesn't solve it please email support :)

Best Regards,

Heather

Heather Laine
Customer Services Manager
LiveCode Ltd
www.livecode.com



> On 10 May 2023, at 21:51, Craig Newman via use-livecode 
>  wrote:
> 
> All.
> Help
> I got a new Mac Mini a month ago. Lovely. Working with LC on it. Lovely.
> 
> I tried to make a windows standalone from the same project I have for years. 
> In the Applications Settings I cannot select the Windows pane. It is 
> essentially disabled, and looks like it.
> 
> In fact, I cannot select any pane except the Mac one. The Mac standalone 
> proceeds as usual, but there is nothing done on the Windows side.
> 
> I made a brand new stack. Same issue; only the Mac pane is accessible.
> 
> Before I put the splash stack and the mainStack on a thumb drive and reload 
> them back on my old iMac to make an updated standalone, is it me or Ventura?
> 
> Craig
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode