resizing and rescaling an object: Is this math/logic ok?

[Nicolas Cueto via use-livecode]

Given these values...

original STACK-width is tOSW
original stack-height is tOSH

resized stack-width is tRSW
resized stack-height of stack is tRSH

original  OBJECT rect is tOOR  (i.e., left,top,right,bottom)

... and assuming I'm right that ...

ratio of stack's width change is tRSWC and equals
round(tRSW / tOSW,2)

ratio of stack's height change is tRSHC and equals
round(tRSH / tOSH,2)




... then how (further?) wrong am I in assuming that, if I want the original
object resized and repositioned to scale on the new stack size, the NEW
RECT of that object therefore equals ...

round(item 1 of tOOR * tRSWC,0) , round(item 2 of tOOR * tRSHC,0) ,
round(item 3 of tOOR * tRSWC,0), round(item 4 of tOOR * tRSHC,0)


Sorry if that was painful. For what it's worth, I'm embarassed posting it,
but...

--
Nicolas Cueto
___
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: gradient selectors

[Mark Wieder via use-livecode]

Bug report 20885 submitted.

--
 Mark Wieder
 ahsoftw...@gmail.com

___
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: gradient selectors

[Mark Wieder via use-livecode]

On 01/17/2018 07:43 PM, Paul Hibbert via use-livecode wrote:

Both fill and stroke gradients work fine on Mac High Sierra, no delays that I 
can see and definitely no hang, so it may be a Linux related bug.


Thanks for checking, Paul. Yeah, I just confirmed they're working on OSX 
as well. And not working on linux in LC8 and LC9.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Changes to Google Play submissions

[J. Landman Gay via use-livecode]

From the blog:
"We’re giving Android developers a heads up about changes coming to 
Google Play to increase app security and performance. In the second half 
of 2018, new apps and app updates will be required to target a recent 
API level. In 2019, new apps and app updates with native libraries must 
provide 64-bit versions in addition to their 32-bit versions."


More here:



How will this affect our Android apps? Are we 64-bit? Is there a way to 
"target" a version? I only see a way to select a minimum version in 
standalone settings, though I guess we could provide a custom manifest.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
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: Roadmap: "Automated REST API wrapping"?

[Richard Gaskin via use-livecode]

Thanks, Mike.  Where do I find the LG 2017 videos?

--
 Richard Gaskin
 Fourth World Systems

Mike Kerner wrote:

I think it was part of a two-fer that Mark and Kevin were doing during the
keynote in either July or August or September or October or November

On Thu, Jan 18, 2018 at 12:12 PM, Richard Gaskin via use-livecode <
use-livecode at lists.runrev.com> wrote:


Mark Waddingham wrote:

> On 2018-01-17 04:29, Richard Gaskin via use-livecode wrote:
>> The LC Roadmap at  includes
>> under "Planned":
>>
>>   Automated REST API wrapping
>>
>> Sounds enticing.  What is it?
>
> This is referring to LiveCode Connect - which I did a prototype for in
> an LCG2017 session...

Where can I access the LG2017 sessions?

I couldn't find a link on the public site or on my account page.

--
 Richard Gaskin


--

___
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: Roadmap: "Automated REST API wrapping"?

[Mike Kerner via use-livecode]

I think it was part of a two-fer that Mark and Kevin were doing during the
keynote in either July or August or September or October or November

On Thu, Jan 18, 2018 at 12:12 PM, Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Mark Waddingham wrote:
>
> > On 2018-01-17 04:29, Richard Gaskin via use-livecode wrote:
> >> The LC Roadmap at  includes
> >> under "Planned":
> >>
> >>   Automated REST API wrapping
> >>
> >> Sounds enticing.  What is it?
> >
> > This is referring to LiveCode Connect - which I did a prototype for in
> > an LCG2017 session...
>
> Where can I access the LG2017 sessions?
>
> I couldn't find a link on the public site or on my account page.
>
> --
>  Richard Gaskin
>  Fourth World Systems
>  Software Design and Development for the Desktop, Mobile, and the Web
>  
>  ambassa...@fourthworld.comhttp://www.FourthWorld.com
>
> ___
> 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
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
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: Reading from xls or xlsx - with style

[Ben Rubinstein via use-livecode]

Thanks all for the suggestions.

In fact I found that although the docs for xlsx (aka OpenXML aka ECMA-376 aka 
ISO/IEC 29500) are a dense nightmare*, simply taking a close look at the 
format shows it's pretty simple to parse by reading the files directly, at 
least for my needs (just text and other literal values, in some cases with 
style, not caring about formulas, charts etc).


(If I wanted a more straightforward life, and was prepared to do some manual 
work on each file before processing it, and I/my client didn't have concerns 
about sharing internal data with Google, I did before getting this far 
establish that the easiest solution would be to import the spreadsheet into 
Google Sheets, which has a nice straightforward API for getting the data.)


So, thanks all - and if a visitor from the future is reading this thread 
because they have a similar requirement, my suggestion is to either run it 
through Google Sheets, or hack the xslx directly.


Ben

*Part 1 of the reference is a 5,036 page document. I didn't bother downloading 
the following parts...


On 16/01/2018 21:55, zryip theSlug via use-livecode wrote:

Matthias, if by tooltip, you meant the comment associated to a cell,
yes this is something potentially possible, too.


On Tue, Jan 16, 2018 at 9:52 PM, Matthias Rebbe via use-livecode
 wrote:

As i wrote “ at least i am not aware of it” ;)

good to know. That this is possible.

Btw.: Do you know if it is also possible to read/get the tooltip of a cell of 
better said of a range of cells?

Regards
Matthias


Matthias Rebbe
Tel +49 5741 31
‌https://matthiasrebbe.eu ‌


Am 16.01.2018 um 21:32 schrieb zryip theSlug via use-livecode 
mailto:use-livecode@lists.runrev.com>>:

In the Excel Lib, the command XCEL_Range_FontStyle_Get is returning
the style of the whole cell or range. We have no function to read the
style of each char, at this moment.
However, both VBA and AppleScript are offering this possibility, so
this is a function we can add. A possible solution would consist to
explore the style of each chars in a cell, then return the result in
html to have it directly usable in LiveCode. I'm not sure of the
performances of this approach, though. It will depend on how many
cells the sheet have and how many text each cells are containing.

On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:

Ben,

i am uising Spreadlib and Excel Libary. Both do not take care for text format.
At least i am not aware of it.

Regards,
Matthias



Matthias Rebbe
Tel +49 5741 31
‌https://matthiasrebbe.eu  >‌


Am 16.01.2018 um 19:10 schrieb Ben Rubinstein via use-livecode mailto:use-livecode@lists.runrev.com> >>:

I'm aware that there are a couple of libraries floating around for reading 
Excel documents - do any of them allow the formatting of runs of text within 
cells to be read? I want to import some data where some of the text in a cell 
may contain some parts which are in italics or bold. Are there existing 
libraries that support this use?

Many thanks,

Ben

___
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 





--
Zryip TheSlug
http://www.aslugontheroad.com 

___
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: Roadmap: "Automated REST API wrapping"?

[Richard Gaskin via use-livecode]

Mark Waddingham wrote:

> On 2018-01-17 04:29, Richard Gaskin via use-livecode wrote:
>> The LC Roadmap at  includes
>> under "Planned":
>>
>>   Automated REST API wrapping
>>
>> Sounds enticing.  What is it?
>
> This is referring to LiveCode Connect - which I did a prototype for in
> an LCG2017 session...

Where can I access the LG2017 sessions?

I couldn't find a link on the public site or on my account page.

--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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: How do I delete cloned images with the same name all at once?

[Tore Nilsen via use-livecode]

Correction of previous script:

on deleteImage
put the number of images of this card into tImages
repeat with x = sImages down to 1
if last char of the short name of image x is an integer then — you will then 
keep the image you use as basis for the clones
delete image x
end if
end repeat
end deleteImage

> 18. jan. 2018 kl. 17:32 skrev Tore Nilsen via use-livecode 
> :
> 
> on deleteImage
> put the number of images of this card into tImages
> repeat with x = sImages down to 1
> if last char of the short name of image x is an integer then — you will then 
> keep the image you use as basis for the clones
> delete image x
> end if
> end repeat
> repeat with x 

___
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: How do I delete cloned images with the same name all at once?

[Tore Nilsen via use-livecode]

You do need to count down to 1, otherwise the counter x will become greater 
than the number of images you have on the card, halfway through the repeat 
loop. There is also no need to get the ID (neither the long or short ID) as you 
can simply refer to the image by its number (the counter x). The best solution 
is the suggestion from Mark Wieder, to place the cloned images in a group and 
just delte the whole group in one go. Then there is no need for looping or 
checking names or IDs.

If for any reason you cannot place the images in a group, you should take the 
advice from Bob Sneidar and rename each clone as you create them. The easiest 
way is to add a number to the name, storing the latest number in a variabel if 
the clones are not made within a repeat lopp with a counter. This script will 
then work:


local sImageNum

on cloneImage
clone image “ticket”
add 1 to sImageNum
set name of last image to “ticket” & sImageNum
end cloneImage


on deleteImage
put the number of images of this card into tImages
repeat with x = sImages down to 1
if last char of the short name of image x is an integer then — you will then 
keep the image you use as basis for the clones
delete image x
end if
end repeat
repeat with x 


Best regards
Tore Nilsen





> 18. jan. 2018 kl. 12:08 skrev Lagi Pittas via use-livecode 
> :
> 
> Hi William
> 
> First off - the send is outside the repeat but I assume that's an error in
> transcribing to the email.
> 
> but this works
> 
> on mouseUp
>   local gone, x
>   repeat with x= 1 to the number of images of this card
>  if the short name of image x is "ticket" then
> put the id of image x into gone
>delete image ID gone
>  end if
>   end repeat
> end mouseUp
> 
> the  name gives "image ticket" so it will never succeed.
> 
> Lagi
> 
> 
> On 17 January 2018 at 22:25, William de Smet via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> 
>> Hi there,
>> 
>> I have several cloned images and all have the same name: ticket.
>> Of course there ID is different.
>> On close card I want to delete them.
>> How do I delete them all at once?
>> Wat is wrong with this code?
>> 
>> on mouseup
>> repeat with x= 1 to the number of images of this card
>> if the name of image x is "ticket" then put the ID of image x into GONE
>> end repeat
>> send ("delete GONE") to me in 0 ticks
>> end mouseup
>> 
>> 
>> 
>> 
>> greetings,
>> 
>> William
>> ___
>> 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: How do I delete cloned images with the same name all at once?

[Bob Sneidar via use-livecode]

Rather use the long id. Just the id means your statement resolves to "delete 
456" or some such thing. 

The other thing you can do is rename the clones as soon as you create them so 
you can reference them later. 

Bob S

> On Jan 17, 2018, at 14:42 , Tore Nilsen via use-livecode 
>  wrote:
> 
> The property “name” refers to more than “ticket”, it also includes the 
> description of the control, in your case the name will be “image ticket”.
> You also will need to count down from the number of images in order to delete 
> all of them, otherwise you will run into a situation where x is higher than 
> the number of images still on your card
> Use short name instead of name, this will script  will work:
> 
> on mouseUp
> put the number of images of this card into tImages
> repeat with x = tImages down to 1
>  if the short name of image x = “ticket” then  
> delete image x 
>  end if
> end repeat
> end mouseUp
> 
>> 17. jan. 2018 kl. 23:25 skrev William de Smet via use-livecode 
>> :
>> 
>> Hi there,
>> 
>> I have several cloned images and all have the same name: ticket.
>> Of course there ID is different.
>> On close card I want to delete them.
>> How do I delete them all at once?
>> Wat is wrong with this code?
>> 
>> on mouseup
>> repeat with x= 1 to the number of images of this card
>> if the name of image x is "ticket" then put the ID of image x into GONE
>> end repeat
>> send ("delete GONE") to me in 0 ticks
>> end mouseup
>> 
>> 
>> 
>> 
>> greetings,
>> 
>> William
>> ___
>> 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: accessing 2 databases in 1 sql query

[Lagi Pittas via use-livecode]

Hi Thanks MIke

Your a saviour - I read about attach over a year or so  ago when I was
looking at how pragma works and other stuff like that but had no need till
now so totally forgot .

Thanks again

Lagi



On 18 January 2018 at 14:14, Mike Bonner via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Does this help?  http://www.sqlitetutorial.net/sqlite-attach-database/
>
> Short version.. attach database lets you attach another db file to the
> current connection.  So if you have db "contacts" open, and you attach a
> file AS contacts2 (which is an alias defined during the attach) then you
> can address a specific table from the first db with "contacts.tablename"
> and the second with "contacts2.tablename"
>
> At which point you can most likely do something like..
>
> INSERT INTO CONTACTS2.TABLENAME(fieldname1, fieldname2) SELECT
> fieldname1, fieldname2 FROM CONTACTS.TABLENAME;
>
> Alternatively, you might just create a copy of the table from the first db,
> to create a table in the second db and then alter the table to add the
> missing columns.  Not sure which would be better/more efficient.
>
>
> On Thu, Jan 18, 2018 at 4:40 AM, Lagi Pittas via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > Hi
> >
> > Sorry if this counts as a double post but I thought I'd cast my net
> Wieder
> > after no bytes in the forums (both puns intended).
> >
> > https://forums.livecode.com/viewtopic.php?f=12&t=30481
> >
> > Basically I want to copy (migrate) a table in 1 database to another with
> > exactly the same number of records and same primary key but the new table
> > has a few extra fields which will be empty.
> >
> > I can do it with a cut and paste in sqlitestudio - but I've written a
> > migration script for all the other tables which are not only smaller  but
> > it's a straight insert using a cursor.
> >
> > I've thought of at least 4 ways of doing this - all will probably be
> slower
> > than this more direct route, but I'm thinking in the future using
> > mysql/postgres where I might(will?) need inner or outer joins from
> external
> > databases to do syncing - and yes  know I can do those as well with some
> > sql magic but I like SQL 1 liners ever since it was introduced in Foxpro
> > (for DOS)  over 25 years ago.
> >
> > I can do this in Foxpro, VB, PHP  and any myriad of other languages but
> for
> > the life off me I can't think how this can be done using the calling
> > methods used within LC, since we pass the database "handle" outside the
> > query string how can we qualify a column as to the database it comes
> from.
> >
> > If the answer is it can't be done then I'll have to do it in a  slower
> less
> > succinct way.
> >
> > Thanks Lagi
> > ___
> > 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: accessing 2 databases in 1 sql query

[Mike Bonner via use-livecode]

Does this help?  http://www.sqlitetutorial.net/sqlite-attach-database/

Short version.. attach database lets you attach another db file to the
current connection.  So if you have db "contacts" open, and you attach a
file AS contacts2 (which is an alias defined during the attach) then you
can address a specific table from the first db with "contacts.tablename"
and the second with "contacts2.tablename"

At which point you can most likely do something like..

INSERT INTO CONTACTS2.TABLENAME(fieldname1, fieldname2) SELECT
fieldname1, fieldname2 FROM CONTACTS.TABLENAME;

Alternatively, you might just create a copy of the table from the first db,
to create a table in the second db and then alter the table to add the
missing columns.  Not sure which would be better/more efficient.


On Thu, Jan 18, 2018 at 4:40 AM, Lagi Pittas via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi
>
> Sorry if this counts as a double post but I thought I'd cast my net Wieder
> after no bytes in the forums (both puns intended).
>
> https://forums.livecode.com/viewtopic.php?f=12&t=30481
>
> Basically I want to copy (migrate) a table in 1 database to another with
> exactly the same number of records and same primary key but the new table
> has a few extra fields which will be empty.
>
> I can do it with a cut and paste in sqlitestudio - but I've written a
> migration script for all the other tables which are not only smaller  but
> it's a straight insert using a cursor.
>
> I've thought of at least 4 ways of doing this - all will probably be slower
> than this more direct route, but I'm thinking in the future using
> mysql/postgres where I might(will?) need inner or outer joins from external
> databases to do syncing - and yes  know I can do those as well with some
> sql magic but I like SQL 1 liners ever since it was introduced in Foxpro
> (for DOS)  over 25 years ago.
>
> I can do this in Foxpro, VB, PHP  and any myriad of other languages but for
> the life off me I can't think how this can be done using the calling
> methods used within LC, since we pass the database "handle" outside the
> query string how can we qualify a column as to the database it comes from.
>
> If the answer is it can't be done then I'll have to do it in a  slower less
> succinct way.
>
> Thanks Lagi
> ___
> 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: post to httpS?

[Klaus major-k via use-livecode]

Hi Paul,

> Am 18.01.2018 um 14:18 schrieb Paul Richards via use-livecode 
> :
> 
> I think you might be looking for:   libURLSetSSLVerification false

YES, that was it, thank you! :-)

> regards, 
> Paul 
> 
> -Original Message-
> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf 
> Of Klaus major-k via use-livecode
> Sent: 18 January 2018 13:13
> To: How to use LiveCode 
> Cc: Klaus major-k 
> Subject: Re: post to httpS?
> 
> Hi Matthias,
> 
>> Am 18.01.2018 um 14:06 schrieb Matthias Rebbe via use-livecode 
>> :
>> 
>> Klaus,
>> 
>> just tried it here with LC9 DP11 (tsNet) with success. 
> 
> ah, yes tsNet, thank you!
> 
> Anyone remembers what to set (to false) BEFORE we post something to an HTTPS 
> in version 5.02?
> 
>> Regards,
>> Matthias
>> 
>>> Am 18.01.2018 um 13:28 schrieb Klaus major-k via use-livecode 
>>> mailto:use-livecode@lists.runrev.com>>:
>>> 
>>> Hi friends,
>>> 
>>> I did not POST something to an URL for a long time, so what is the 
>>> current state, can we POST to HTTPS urls with LC 8/9?

Best

Klaus

--
Klaus Major
http://www.major-k.de
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: post to httpS?

[Paul Richards via use-livecode]

I think you might be looking for:   libURLSetSSLVerification false

regards, 
Paul 

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of 
Klaus major-k via use-livecode
Sent: 18 January 2018 13:13
To: How to use LiveCode 
Cc: Klaus major-k 
Subject: Re: post to httpS?

Hi Matthias,

> Am 18.01.2018 um 14:06 schrieb Matthias Rebbe via use-livecode 
> :
> 
> Klaus,
> 
> just tried it here with LC9 DP11 (tsNet) with success. 

ah, yes tsNet, thank you!

Anyone remembers what to set (to false) BEFORE we post something to an HTTPS in 
version 5.02?

> Regards,
> Matthias
> 
> 
> Matthias Rebbe
> Tel +49 5741 31
> ‌https://matthiasrebbe.eu ‌
> 
>> Am 18.01.2018 um 13:28 schrieb Klaus major-k via use-livecode 
>> mailto:use-livecode@lists.runrev.com>>:
>> 
>> Hi friends,
>> 
>> I did not POST something to an URL for a long time, so what is the 
>> current state, can we POST to HTTPS urls with LC 8/9?
>> 
>> Thanks for any hint!

Best

Klaus

--
Klaus Major
http://www.major-k.de
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
___
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: post to httpS?

[Klaus major-k via use-livecode]

Hi Matthias,

> Am 18.01.2018 um 14:06 schrieb Matthias Rebbe via use-livecode 
> :
> 
> Klaus,
> 
> just tried it here with LC9 DP11 (tsNet) with success. 

ah, yes tsNet, thank you!

Anyone remembers what to set (to false) BEFORE we post something to an HTTPS in 
version 5.02?

> Regards,
> Matthias
> 
> 
> Matthias Rebbe
> Tel +49 5741 31
> ‌https://matthiasrebbe.eu ‌
> 
>> Am 18.01.2018 um 13:28 schrieb Klaus major-k via use-livecode 
>> mailto:use-livecode@lists.runrev.com>>:
>> 
>> Hi friends,
>> 
>> I did not POST something to an URL for a long time, so what is the current 
>> state, 
>> can we POST to HTTPS urls with LC 8/9?
>> 
>> Thanks for any hint!

Best

Klaus

--
Klaus Major
http://www.major-k.de
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: post to httpS?

[Matthias Rebbe via use-livecode]

Klaus,

just tried it here with LC9 DP11 (tsNet) with success. 

Regards,
Matthias


Matthias Rebbe
Tel +49 5741 31
‌https://matthiasrebbe.eu ‌

> Am 18.01.2018 um 13:28 schrieb Klaus major-k via use-livecode 
> mailto:use-livecode@lists.runrev.com>>:
> 
> Hi friends,
> 
> I did not POST something to an URL for a long time, so what is the current 
> state, 
> can we POST to HTTPS urls with LC 8/9?
> 
> Thanks for any hint!
> 
> 
> Best
> 
> Klaus
> --
> Klaus Major
> http://www.major-k.de 
> 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

___
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

post to httpS?

[Klaus major-k via use-livecode]

Hi friends,

I did not POST something to an URL for a long time, so what is the current 
state, 
can we POST to HTTPS urls with LC 8/9?

Thanks for any hint!


Best

Klaus
--
Klaus Major
http://www.major-k.de
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

accessing 2 databases in 1 sql query

[Lagi Pittas via use-livecode]

Hi

Sorry if this counts as a double post but I thought I'd cast my net Wieder
after no bytes in the forums (both puns intended).

https://forums.livecode.com/viewtopic.php?f=12&t=30481

Basically I want to copy (migrate) a table in 1 database to another with
exactly the same number of records and same primary key but the new table
has a few extra fields which will be empty.

I can do it with a cut and paste in sqlitestudio - but I've written a
migration script for all the other tables which are not only smaller  but
it's a straight insert using a cursor.

I've thought of at least 4 ways of doing this - all will probably be slower
than this more direct route, but I'm thinking in the future using
mysql/postgres where I might(will?) need inner or outer joins from external
databases to do syncing - and yes  know I can do those as well with some
sql magic but I like SQL 1 liners ever since it was introduced in Foxpro
(for DOS)  over 25 years ago.

I can do this in Foxpro, VB, PHP  and any myriad of other languages but for
the life off me I can't think how this can be done using the calling
methods used within LC, since we pass the database "handle" outside the
query string how can we qualify a column as to the database it comes from.

If the answer is it can't be done then I'll have to do it in a  slower less
succinct way.

Thanks Lagi
___
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: How do I delete cloned images with the same name all at once?

[Lagi Pittas via use-livecode]

Hi William

First off - the send is outside the repeat but I assume that's an error in
transcribing to the email.

but this works

on mouseUp
   local gone, x
   repeat with x= 1 to the number of images of this card
  if the short name of image x is "ticket" then
 put the id of image x into gone
delete image ID gone
  end if
   end repeat
end mouseUp

the  name gives "image ticket" so it will never succeed.

Lagi


On 17 January 2018 at 22:25, William de Smet via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi there,
>
> I have several cloned images and all have the same name: ticket.
> Of course there ID is different.
> On close card I want to delete them.
> How do I delete them all at once?
> Wat is wrong with this code?
>
> on mouseup
> repeat with x= 1 to the number of images of this card
> if the name of image x is "ticket" then put the ID of image x into GONE
> end repeat
> send ("delete GONE") to me in 0 ticks
> end mouseup
>
>
>
>
> greetings,
>
> William
> ___
> 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: How do I delete cloned images with the same name all at once?

[William de Smet via use-livecode]

@Tore and @Mark

Thanks!
Works fine now.


greetings,

William



2018-01-18 0:13 GMT+01:00 Mark Wieder via use-livecode <
use-livecode@lists.runrev.com>:

> On 01/17/2018 02:42 PM, Tore Nilsen via use-livecode wrote:
>
> Use short name instead of name, this will script  will work:
>>
>
> Additionally, the way I deal with this is to create a group, then create
> the control *in the group*. That way all I have to do is delete the group
> and all the child controls are gone.
>
> --
>  Mark Wieder
>  ahsoftw...@gmail.com
>
>
> ___
> 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