Re: iOS & Android App in a Day workshop (and much more)

[Dave Kilroy]

Hi Bill

One of the things we're experimenting with this weekend is setting up
streaming from the venue - and if we get it working we'll attempt to stream
at least part of the workshop - so if you in California get up really really
early you can take part :)

As regards materials, yes I plan to make them available (have to finish
writing them first...)

Kind regards

Dave



-
"The difference between genius and stupidity is; genius has its limits." - 
Albert Einstein
--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/iOS-Android-App-in-a-Day-workshop-and-much-more-tp4692315p4692362.html
Sent from the Revolution - User mailing list archive at Nabble.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: iOS & Android App in a Day workshop (and much more)

[David Bovill]

I hope to be able to get down there... If you want any help teaching
something send us some info off-list?
On Fri, 15 May 2015 at 12:53, Dave Kilroy 
wrote:

> Hi Bill
>
> One of the things we're experimenting with this weekend is setting up
> streaming from the venue - and if we get it working we'll attempt to stream
> at least part of the workshop - so if you in California get up really
> really
> early you can take part :)
>
> As regards materials, yes I plan to make them available (have to finish
> writing them first...)
>
> Kind regards
>
> Dave
>
>
>
> -
> "The difference between genius and stupidity is; genius has its limits." -
> Albert Einstein
> --
> View this message in context:
> http://runtime-revolution.278305.n4.nabble.com/iOS-Android-App-in-a-Day-workshop-and-much-more-tp4692315p4692362.html
> Sent from the Revolution - User mailing list archive at Nabble.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

Re: iOS & Android App in a Day workshop (and much more)

[Dave Kilroy]

Wow! That's excellent news David!

Actually there is one other experienced LiveCoder who may be coming down to
Plymouth as well (won't say who it it until she/he confirms)

I'll try contacting you off-list now...

PS: this other LiveCoder told me that Heather apparently has knowledge of
schools in the region who use LiveCode, I'm emailed her and am hoping she'll
pass on their details to me so I can see they have any teachers and/or
students wishing to participate...

Kind regards

Dave



-
"The difference between genius and stupidity is; genius has its limits." - 
Albert Einstein
--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/iOS-Android-App-in-a-Day-workshop-and-much-more-tp4692315p4692364.html
Sent from the Revolution - User mailing list archive at Nabble.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: reporting

[Andrew Kluthe]

I've been pretty happy generating html reports for some of the big LC
applications I've done. Use something like bootstrap that has a good print
style sheet. Some JS powered charting that prints nice. I would open in
external browser in my older applications but I wonder if things wouldn't
work nicely in the new CEF browser.

Once things stabilize a bit more, I think we could do tons of standalone
web applications this with it similar to electron or node-webkit. For
example: a customer has an online catalog powered mostly by javascript on
the front end talking to data providers on the server side. We could reuse
most of the javascript in the CEF browser and refactor the bits that serve
the data to serve from the livecode side from a sqlite database. If I had a
little more confidence in some of the newer strains of livecode I'd have
done it like that instead of in electron.

On Thu, May 14, 2015 at 6:33 PM Lynn Fredricks <
lfredri...@proactive-intl.com> wrote:

> > Quartam Reports is pure LiveCode, and as such it has been a
> > great tool for use on all major desktop platforms.
>
> It can be extremely useful to have an add-on that's entirely native. The
> downside to that is that, from the vendor perspective, you can capture only
> a fraction of the users of that development environment. Id imagine if 5%
> of
> all LiveCode users paid the fee for QR, then it would be generating buckets
> of revenue to power new versions.
>
> There are only a few platforms that can really support ONLY native reports
> on a single platform and feed the developer. Even Crystal Reports supports
> multiple development environments.
>
> Best regards,
>
> Lynn Fredricks
> Paradigma Software
> http://www.paradigmasoft.com
>
> Valentina SQL Server: The Ultra-fast, Royalty Free Database Server
>
>
>
> ___
> 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: Trying to be "clever" with a URL in Linux

[Bob Warren]

On 15/05/15 05:55, Bob Warren wrote:


On 14 May 2015, at 19:07, Richmond   wrote:

So, revBrowser is a non-Linux thing . . .

So, I tried this in a button:

on mouseUp
put URL"http://www.distrowatch.org";   into fld "wab"
end mouseUp

and got the raw HTML code in my field.

Wonder if there is a way to get that to display like a web-page in a
field on Linux?

Richmond.

---

If your Linux has Python+WebKit installed (e.g. it is pre-installed in
Linux Mint), you can use the following solution to display the web
page in all types of window (easily tailored with/without scrollbars,
topmost, bottom-most, etc., sized and positioned):

http://www.howsoft.com/runrev/extensions/

I integrated this browser into my WYSIWYG Webpage Editor for Linux
(written in LC of course) in various ways:

http://www.howsoft.com/linux/webed2/

Naturally, the LC embedded browser will be even more convenient when
it comes along, but with the solution outlined above my personal need
of it is no longer urgent at all.


--
On 15/05/15 05:55, Richmond wrote:

That's certainly a way of coping with things, but not in terms of
sending a standalone out to customers: I cannot
see anyone doing that and writing in a "README" file: must have
Python+WebKit installed.

I think that RG's request that the "revBrowser-like thing" for Linux be
backported to 7.x.x is a wonderful idea.

Richmond.

--

Don't get me wrong, I think it's a wonderful idea too.
If RG/Mark can actually get it done, I would be more than pleased
I'm a little tired of having to bust my guts in order to "cope with things" in 
LC/Linux!

Bob


___
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

Release 6.7.5 / 7.0.5

[Sebastien Nouat]

Dear List Members,

We are pleased to announce the release of LiveCode 6.7.5 Stable and 
7.0.5 Stable: all the bug fixes added from LiveCode 6.7.5 RC 1 / 7.0.5 
RC 1 are now considered as stable for both versions.


The only change from the RC 3 releases is in what we believe was the 
cause of the startup slowdown on iOS 8.1+, despite the font mapping fix. 
No bug fix note has been added since it was another aspect of the bug 14116.


**Getting the Release**
To get the release please select "check for updates" from the "help" 
menu in the product or download the installer directly at: 
http://downloads.livecode.com


*6.7.6 RC 1 / 7.0.6 RC 1*
The progress of the bug fix merging can be followed on GitHub:
   - 6.7.6 RC 1: https://github.com/runrev/livecode/milestones/6.7.6-rc-1
   - 7.0.6 RC 1: https://github.com/runrev/livecode/milestones/7.0.6-rc-1

The next maintenance builds are expected to be released within a 2-week 
span.


Warm regards,

The LiveCode Team

___
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: reporting

[Mike Kerner]

I've been doing HTML reporting for years using several tools, but things
definitely are not as tight once you lose control - browsers still do not
all render the same.

On Fri, May 15, 2015 at 8:49 AM, Andrew Kluthe  wrote:

> I've been pretty happy generating html reports for some of the big LC
> applications I've done. Use something like bootstrap that has a good print
> style sheet. Some JS powered charting that prints nice. I would open in
> external browser in my older applications but I wonder if things wouldn't
> work nicely in the new CEF browser.
>
> Once things stabilize a bit more, I think we could do tons of standalone
> web applications this with it similar to electron or node-webkit. For
> example: a customer has an online catalog powered mostly by javascript on
> the front end talking to data providers on the server side. We could reuse
> most of the javascript in the CEF browser and refactor the bits that serve
> the data to serve from the livecode side from a sqlite database. If I had a
> little more confidence in some of the newer strains of livecode I'd have
> done it like that instead of in electron.
>
> On Thu, May 14, 2015 at 6:33 PM Lynn Fredricks <
> lfredri...@proactive-intl.com> wrote:
>
> > > Quartam Reports is pure LiveCode, and as such it has been a
> > > great tool for use on all major desktop platforms.
> >
> > It can be extremely useful to have an add-on that's entirely native. The
> > downside to that is that, from the vendor perspective, you can capture
> only
> > a fraction of the users of that development environment. Id imagine if 5%
> > of
> > all LiveCode users paid the fee for QR, then it would be generating
> buckets
> > of revenue to power new versions.
> >
> > There are only a few platforms that can really support ONLY native
> reports
> > on a single platform and feed the developer. Even Crystal Reports
> supports
> > multiple development environments.
> >
> > Best regards,
> >
> > Lynn Fredricks
> > Paradigma Software
> > http://www.paradigmasoft.com
> >
> > Valentina SQL Server: The Ultra-fast, Royalty Free Database Server
> >
> >
> >
> > ___
> > 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
>



-- 
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: Release 6.7.5 / 7.0.5

[Mike Kerner]

"The only change from the RC 3 releases is in what we believe was the cause
of the startup slowdown on iOS 8.1+, despite the font mapping fix. No bug
fix note has been added since it was another aspect of the bug 14116."
What does THAT mean?  Is manual font mapping still required?

On Fri, May 15, 2015 at 9:16 AM, Sebastien Nouat <
sebastien.no...@livecode.com> wrote:

> Dear List Members,
>
> We are pleased to announce the release of LiveCode 6.7.5 Stable and 7.0.5
> Stable: all the bug fixes added from LiveCode 6.7.5 RC 1 / 7.0.5 RC 1 are
> now considered as stable for both versions.
>
> The only change from the RC 3 releases is in what we believe was the cause
> of the startup slowdown on iOS 8.1+, despite the font mapping fix. No bug
> fix note has been added since it was another aspect of the bug 14116.
>
> **Getting the Release**
> To get the release please select "check for updates" from the "help" menu
> in the product or download the installer directly at:
> http://downloads.livecode.com
>
> *6.7.6 RC 1 / 7.0.6 RC 1*
> The progress of the bug fix merging can be followed on GitHub:
>- 6.7.6 RC 1: https://github.com/runrev/livecode/milestones/6.7.6-rc-1
>- 7.0.6 RC 1: https://github.com/runrev/livecode/milestones/7.0.6-rc-1
>
> The next maintenance builds are expected to be released within a 2-week
> span.
>
> Warm regards,
>
> The LiveCode Team
>
> ___
> 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: iOS & Android App in a Day workshop (and much more)

[Earthednet-wp]

Dave,
That's great! I'll look forward to looking over the materials. I spend so much 
time over the niggling details, so working examples help a lot.
Best regards,
Bill

William Prothero
http://es.earthednet.org

> On May 15, 2015, at 3:36 AM, Dave Kilroy  wrote:
> 
> Hi Bill
> 
> One of the things we're experimenting with this weekend is setting up
> streaming from the venue - and if we get it working we'll attempt to stream
> at least part of the workshop - so if you in California get up really really
> early you can take part :)
> 
> As regards materials, yes I plan to make them available (have to finish
> writing them first...)
> 
> Kind regards
> 
> Dave
> 
> 
> 
> -
> "The difference between genius and stupidity is; genius has its limits." - 
> Albert Einstein
> --
> View this message in context: 
> http://runtime-revolution.278305.n4.nabble.com/iOS-Android-App-in-a-Day-workshop-and-much-more-tp4692315p4692362.html
> Sent from the Revolution - User mailing list archive at Nabble.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

Re: Release 6.7.5 / 7.0.5

[Sebastien Nouat]

On 15/05/2015 14:34, Mike Kerner wrote:

"The only change from the RC 3 releases is in what we believe was the cause
of the startup slowdown on iOS 8.1+, despite the font mapping fix. No bug
fix note has been added since it was another aspect of the bug 14116."
What does THAT mean?  Is manual font mapping still required?

On Fri, May 15, 2015 at 9:16 AM, Sebastien Nouat <
sebastien.no...@livecode.com> wrote:


Dear List Members,

We are pleased to announce the release of LiveCode 6.7.5 Stable and 7.0.5
Stable: all the bug fixes added from LiveCode 6.7.5 RC 1 / 7.0.5 RC 1 are
now considered as stable for both versions.

The only change from the RC 3 releases is in what we believe was the cause
of the startup slowdown on iOS 8.1+, despite the font mapping fix. No bug
fix note has been added since it was another aspect of the bug 14116.

**Getting the Release**
To get the release please select "check for updates" from the "help" menu
in the product or download the installer directly at:
http://downloads.livecode.com

*6.7.6 RC 1 / 7.0.6 RC 1*
The progress of the bug fix merging can be followed on GitHub:
- 6.7.6 RC 1: https://github.com/runrev/livecode/milestones/6.7.6-rc-1
- 7.0.6 RC 1: https://github.com/runrev/livecode/milestones/7.0.6-rc-1

The next maintenance builds are expected to be released within a 2-week
span.

Warm regards,

The LiveCode Team

___
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





Hi Mike,

The issue tackled in the Stable releases was internal, and not something 
the font mapping could fix.


So yes, adding a custom font mapping file is still needed for any custom 
font that you add in your app.


--
Sébastien Nouat
LiveCode Development Team


___
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: Release 6.7.5 / 7.0.5

[Sebastien Nouat]

On 15/05/2015 14:34, Mike Kerner wrote:

"The only change from the RC 3 releases is in what we believe was the cause
of the startup slowdown on iOS 8.1+, despite the font mapping fix. No bug
fix note has been added since it was another aspect of the bug 14116."
What does THAT mean?  Is manual font mapping still required?

On Fri, May 15, 2015 at 9:16 AM, Sebastien Nouat <
sebastien.no...@livecode.com> wrote:


Dear List Members,

We are pleased to announce the release of LiveCode 6.7.5 Stable and 7.0.5
Stable: all the bug fixes added from LiveCode 6.7.5 RC 1 / 7.0.5 RC 1 are
now considered as stable for both versions.

The only change from the RC 3 releases is in what we believe was the cause
of the startup slowdown on iOS 8.1+, despite the font mapping fix. No bug
fix note has been added since it was another aspect of the bug 14116.

**Getting the Release**
To get the release please select "check for updates" from the "help" menu
in the product or download the installer directly at:
http://downloads.livecode.com

*6.7.6 RC 1 / 7.0.6 RC 1*
The progress of the bug fix merging can be followed on GitHub:
- 6.7.6 RC 1: https://github.com/runrev/livecode/milestones/6.7.6-rc-1
- 7.0.6 RC 1: https://github.com/runrev/livecode/milestones/7.0.6-rc-1

The next maintenance builds are expected to be released within a 2-week
span.

Warm regards,

The LiveCode Team

___
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






Hi Mike,

The issue tackled in the Stable releases was internal, and not something 
the font mapping could fix.


So yes, adding a custom font mapping file is still needed for any custom 
font that you add in your app.


--
Sébastien Nouat
LiveCode Development Team


___
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: OT: Contixo android device

[Roger Eller]

Is the tablet older than 1 year?  From their website:

Warranty Information
1-Year Worry-Free Guarantee: Customer Service & Tech Support

http://www.contixo.net/pages/Contact-Us.html#mobile-phones-home



On Thu, May 14, 2015 at 8:14 PM, Mike Bonner  wrote:

> Hey all, I was given an android device. A Contixo kids tablet.  The owner
> things there is a hardware issue (white screen, touch works, sounds work,
> but can't see anything.)  I suspect a horked update has caused issues.
>
> Since I can't get to any settings (on purpose)  does anyone know of a way
> to use ADB to force a factory reset? Assuming of course that I can't go in
> and turn on the developer options..
>
> Any and all suggestions welcome.  I'd really like to get it working again
> so i can give it back.
> ___
> 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: Trying to be "clever" with a URL in Linux

[Bob Sneidar]

Did you try 

put URL "http://www.distrowatch.org"; into foo
set the htmlText of field “wab” to foo

Bob S


> On May 14, 2015, at 11:07 , Richmond  wrote:
> 
> So, revBrowser is a non-Linux thing . . .
> 
> So, I tried this in a button:
> 
> on mouseUp
>   put URL "http://www.distrowatch.org"; into fld "wab"
> end mouseUp
> 
> and got the raw HTML code in my field.
> 
> Wonder if there is a way to get that to display like a web-page in a field on 
> Linux?
> 
> Richmond.
> 
> ___
> 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: reporting

[Lynn Fredricks]

> I've been doing HTML reporting for years using several tools, 
> but things definitely are not as tight once you lose control 
> - browsers still do not all render the same.

We support different types of reports - generating pages, PDFs, etc. A
number of our users utilize this ability on Valentina Server to generate
rich PDF reports (they can incorporate the XML bits you can include in PDFs)
and then automatically send them by email, or deposit them into a directory
someplace.

Best regards,

Lynn Fredricks
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 



___
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: Helppppp-iOS Provisioning desperation

[William Prothero]

Colin and Scott:
Thanks for all the suggestions! I must be making progress because now I get a 
different error message: “App Installation failed. A valid provisioning profile 
for this executable was not found.”

In LiveCode,
I’ve set the internal App ID: org.earthednet.waterdetective
Display Name: Water Detective   (with a space)

At the Apple Developer’s site:
In the provisioning profile: 
Name: Water Detective
App ID shows as: waterdetective (org.earthednet.waterdetective}

In the Identifiers part of Apple Dev:
Name: Water Detective
ID: org.earthednet.waterdetective

The name that shows in the downloaded provisioning profile is:’
Water_Detective.mobileprovision

And, I still get the error:

Could it be a livecode problem? I’m using version 7.0.5 (RC 3) and Xcode 6.3.1. 
There are also several certificates that Xcode manages. I haven’t figured a way 
to delete them yet. I’m wondering if there is some kind of conflicting names or 
whatever, that I created in my wanderings.

It would sure be nice if LiveCode had some way of providing some error messages 
about provisioning. Is there any software that might help with diagnosing the 
actual problem?

Best,
Bill



> On May 14, 2015, at 3:22 PM, Colin Holgate  wrote:
> 
> The name would be the nice short title that sits under the icon. It can have 
> spaces in it.
> ___
> 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: reporting

[Peter M. Brigham]

On May 14, 2015, at 2:06 PM, Richard Gaskin wrote:

> we have one word, "free", for two very different things, "gratis" and "libre"

A propos of that, one of my favorite bumperstickers (re recent US Supreme Court 
decisions) is:

"If money = speech, then speech is not free."

-- Peter

Peter M. Brigham
pmb...@gmail.com
http://home.comcast.net/~pmbrig


___
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

SQL join question

[Bob Sneidar]

Hi all. 

I am just now learning SQL joins, and I have run across an interesting caveat. 
It may be how sqlYoga is working or it may be how joins work. I have two 
tables, devices and accessories. This is a one to many relationship. I set up 
the join as a left join on devices.deviceid = accessories.deviceid. Not all 
devices have associated accessory records. 

The problem is, instead of getting a record with every device in inventory, 
whether or not it has accessories, I am *ONLY* getting devices with associated 
accessories. Is this the normal behavior of joins? If not, how would I 
structure the join so that I got blank accessory columns for devices without 
accessories? 
___
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: SQL join question

[Peter Haworth]

Hi Bob,
Something not right there.  A LEFT JOIN should return all entries from the
left table, presumably devices in your example, whether or not there are
any matching entries in the other side of the join (accessories).

One possibility is that your SELECT statement should name the devices table
in the FROM clause and the JOIN should name the accessories table.  if the
SELECT names the accessories table and the JOIN goes to the devices table,
that would give the result you're seeing.

Hard to diagnose further without seeing your SELECT statement.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Fri, May 15, 2015 at 10:57 AM, Bob Sneidar 
wrote:

> Hi all.
>
> I am just now learning SQL joins, and I have run across an interesting
> caveat. It may be how sqlYoga is working or it may be how joins work. I
> have two tables, devices and accessories. This is a one to many
> relationship. I set up the join as a left join on devices.deviceid =
> accessories.deviceid. Not all devices have associated accessory records.
>
> The problem is, instead of getting a record with every device in
> inventory, whether or not it has accessories, I am *ONLY* getting devices
> with associated accessories. Is this the normal behavior of joins? If not,
> how would I structure the join so that I got blank accessory columns for
> devices without accessories?
> ___
> 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: SQL join question

[Bob Sneidar]

Hi Pete. 

I can post the code that sqlYoga needs for this. I suspect if I wrote out the 
actual SQL and ran it in a utility, it would work as expected. 

  tableobj_createObject "devices"
  tableobj_createObject "accessories"
  tblrelation_createObject "devices|accessories"
  tblrelation_set "devices|accessories", "type", "one-to-many"
  tblrelation_set "devices|accessories", "left table", "devices"
  tblrelation_set "devices|accessories", "left table key", "deviceid"
  tblrelation_set "devices|accessories", "right table", "accessories"
  tblrelation_set "devices|accessories", "right table key", "deviceid"
  put sqlquery_createObject("devices") into theDeviceObject
  sqlquery_set theDeviceObject, "related table joins", “LEFT JOIN 
accessories"
  sqlquery_retrieveAsArray theDeviceObject, aDeviceData

While this is not SQL, you can see that the left table is devices and the right 
table is accessories. I will shoot off an email to BlueMangoGroup and see what 
they say. 

Bob S


> On May 15, 2015, at 11:07 , Peter Haworth  wrote:
> 
> Hi Bob,
> Something not right there.  A LEFT JOIN should return all entries from the
> left table, presumably devices in your example, whether or not there are
> any matching entries in the other side of the join (accessories).
> 
> One possibility is that your SELECT statement should name the devices table
> in the FROM clause and the JOIN should name the accessories table.  if the
> SELECT names the accessories table and the JOIN goes to the devices table,
> that would give the result you're seeing.
> 
> Hard to diagnose further without seeing your SELECT statement.
> 
> Pete

___
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

SQL join question

[Mark Stuart]

Hi Bob,
LEFT OUTER JOIN will given you every record on the left (devices) even if a
device has no accessory.

Mark
___
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: SQL join question

[Bob Sneidar]

OK problem solved. Apparently SQL assumes inner join if not specified. If I 
define it as an OUTER join, I get all the device records as expected. Thanks 
for the help.

Bob S


On May 15, 2015, at 11:07 , Peter Haworth 
mailto:p...@lcsql.com>> wrote:

Hi Bob,
Something not right there.  A LEFT JOIN should return all entries from the
left table, presumably devices in your example, whether or not there are
any matching entries in the other side of the join (accessories).

___
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: SQL join question

[Bob Sneidar]

Thanks Mark just came to that conclusion and then saw your email. 

Bob S


> On May 15, 2015, at 11:14 , Mark Stuart  wrote:
> 
> Hi Bob,
> LEFT OUTER JOIN will given you every record on the left (devices) even if a
> device has no accessory.
> 
> Mark
> ___
> 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: SQL join question

[Peter Haworth]

That's strange since the SQLYoga stuff you posted specifies LEFT JOIN.
What flavor of SQL are you using?  Anyway, you got it working so all good.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Fri, May 15, 2015 at 11:20 AM, Bob Sneidar 
wrote:

> OK problem solved. Apparently SQL assumes inner join if not specified. If
> I define it as an OUTER join, I get all the device records as expected.
> Thanks for the help.
>
> Bob S
>
>
> On May 15, 2015, at 11:07 , Peter Haworth  p...@lcsql.com>> wrote:
>
> Hi Bob,
> Something not right there.  A LEFT JOIN should return all entries from the
> left table, presumably devices in your example, whether or not there are
> any matching entries in the other side of the join (accessories).
>
> ___
> 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: OT: Contixo android device

[J. Landman Gay]

On 5/14/2015 7:14 PM, Mike Bonner wrote:

Hey all, I was given an android device. A Contixo kids tablet.  The owner
things there is a hardware issue (white screen, touch works, sounds work,
but can't see anything.)  I suspect a horked update has caused issues.

Since I can't get to any settings (on purpose)  does anyone know of a way
to use ADB to force a factory reset? Assuming of course that I can't go in
and turn on the developer options..


Here is a way to fix it for an HTC device, but the technique is pretty 
standard for all Android phones and tablets. Try Step 2:




--
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: Can a script preempt substack name conflicts?

[J. Landman Gay]

On 5/14/2015 8:16 PM, David Epstein wrote:

With stack A already open, I open stack B and get a alert like this:

"A stack "" in file  is already in
memory.  The Revolution UI does not distinguish stacks which have
identical names, so editing these stack files while both are in
memory could result in data loss.”

Is it possible by script to intercept the message that generates this
alert, and rename either the substack that is already in memory or
the substack of the stack I am trying to open, so as to avoid both
the alert and the risk of data loss?  My impression is that if I try
to learn the substack names of a file I will already be loading that
file into memory, and it will be too late to head off the alert.


I don't think it's worth it to try and hack the IDE to get around the 
warning. You won't lose any data unless you make changes to one of the 
duplicate stacks and then try to save it. So what I usually do is note 
the name of the problem stack and quit LC. Then I restart, open the 
stack I want to change, and temporarily alter its name in the property 
inspector. I don't save it.


Then open the second stack, do whatever work is necessary, and then 
close and remove it from memory. After that you can change the name of 
the original stack back to what it was again.


When I know in advance I'm going to open duplicate-named stacks, I just 
change the first stack temporarily before opening the second one. It 
saves time.


--
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: Helppppp-iOS Provisioning desperation

[William Prothero]

Whoopee! Got it working. What I had to do was syncronize Xcode to the 
provisioning profiles using the Preferences->Accounts screen. Then I used one 
of the downloaded provisioning profiles and it worked!

Whew! Still somewhat of a mystery, but boy am I getting good at fiddling with 
the Apple Dev site.
Best,
Bill

> On May 14, 2015, at 1:40 PM, William Prothero  wrote:
> 
> Folks:
> I post this only after hours struggling with trying to get Xcode to accept my 
> provisioning profile for an app. I’ve deleted all signing certificates, 
> deleted everything on the Apple Dev site and redone it, scrupulously followed 
> the tutorial on the livecode site and checked docs. I simply cannot load my 
> app.
> 
> I get the “The executable was signed with invalid entitlements” message. It 
> says “The signing Entitlements file do not match those specified in your 
> provisioning profile.”
> 
> I’m really stuck. I’m in LC 7.0.5 (RC2 or 3) and Xcode 6.3.1. I did get it 
> working for another app, but now, after I’ve deleted everything and started 
> from scratch, I can’t ge the damned thing to accept my provisioning profile 
> for anything.
> 
> So:  After all this, is there anything I might try? I don’t know how to debug 
> this except to just delete everything and retry it. How can I debug this?
> 
> Best,
> Bill
> 
> 
> William A. Prothero
> http://es.earthednet.org/
> 
> ___
> 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: Helppppp-iOS Provisioning desperation

[William Prothero]

Scott and Colin:
Thanks so much for your help on this. I was really desperate and you helped me 
focus on the critical issues. 
Best wishes.
Bill

> On May 15, 2015, at 12:41 PM, William Prothero  
> wrote:
> 
> Whoopee! Got it working. What I had to do was syncronize Xcode to the 
> provisioning profiles using the Preferences->Accounts screen. Then I used one 
> of the downloaded provisioning profiles and it worked!
> 
> Whew! Still somewhat of a mystery, but boy am I getting good at fiddling with 
> the Apple Dev site.
> Best,
> Bill
> 
>> On May 14, 2015, at 1:40 PM, William Prothero  
>> wrote:
>> 
>> Folks:
>> I post this only after hours struggling with trying to get Xcode to accept 
>> my provisioning profile for an app. I’ve deleted all signing certificates, 
>> deleted everything on the Apple Dev site and redone it, scrupulously 
>> followed the tutorial on the livecode site and checked docs. I simply cannot 
>> load my app.
>> 
>> I get the “The executable was signed with invalid entitlements” message. It 
>> says “The signing Entitlements file do not match those specified in your 
>> provisioning profile.”
>> 
>> I’m really stuck. I’m in LC 7.0.5 (RC2 or 3) and Xcode 6.3.1. I did get it 
>> working for another app, but now, after I’ve deleted everything and started 
>> from scratch, I can’t ge the damned thing to accept my provisioning profile 
>> for anything.
>> 
>> So:  After all this, is there anything I might try? I don’t know how to 
>> debug this except to just delete everything and retry it. How can I debug 
>> this?
>> 
>> Best,
>> Bill
>> 
>> 
>> William A. Prothero
>> http://es.earthednet.org/
>> 
>> ___
>> 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

Can a script preempt substack name conflicts?

[dfepstein]

Thanks for this prudent advice.  The case I am contemplating would involve a 
user creating new substacks to hold content.  While I can make sure each 
substack created by my program gets a unique name, if a file created on one 
machine is moved to another machine there is some chance of a conflict (reduced 
but not absolutely eliminated if I went to great lengths, like embedding in 
each substack's name "the ticks" at creation time). 
I think I can work around this IF the "substack name conflict problem" is only 
a problem for the LiveCode UI.  In other words if in my own scripts I am 
careful always to refer to a substack by its long name, am I safe even if two 
substacks have the same short name? 
  
David Epstein 
  
-- 



On 5/14/2015 8:16 PM, David Epstein wrote: 
> With stack A already open, I open stack B and get a alert like this: 
> 
> "A stack "" in file  is already in > 
> memory.  The Revolution UI does not distinguish stacks which have 
> identical names, so editing these stack files while both are in 
> memory could result in data loss.” 
> 
> Is it possible by script to intercept the message that generates this 
> alert, and rename either the substack that is already in memory or 
> the substack of the stack I am trying to open, so as to avoid both 
> the alert and the risk of data loss?  My impression is that if I try 
> to learn the substack names of a file I will already be loading that 
> file into memory, and it will be too late to head off the alert. 

I don't think it's worth it to try and hack the IDE to get around the 
warning. You won't lose any data unless you make changes to one of the 
duplicate stacks and then try to save it. So what I usually do is note 
the name of the problem stack and quit LC. Then I restart, open the 
stack I want to change, and temporarily alter its name in the property 
inspector. I don't save it. 

Then open the second stack, do whatever work is necessary, and then 
close and remove it from memory. After that you can change the name of 
the original stack back to what it was again. 

When I know in advance I'm going to open duplicate-named stacks, I just 
change the first stack temporarily before opening the second one. It 
saves time. 

-- 
Jacqueline Landman Gay | jacque at 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

Geometry Manager For Mobile

[Mike Kerner]

Interesting - I just started messing with Xojo, again, since I see
they're (finally) getting into the ios game (I didn't see anything about
Android).  Their version of the Geometry Manager is implemented on ios.  I
wonder if we're going to see it again in LC 8...

-- 
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: Can a script preempt substack name conflicts?

[J. Landman Gay]

On 5/15/2015 4:21 PM, dfepst...@comcast.net wrote:

I think I can work around this IF the "substack name conflict
problem" is only a problem for the LiveCode UI.  In other words if in
my own scripts I am careful always to refer to a substack by its long
name, am I safe even if two substacks have the same short name?


Probably. The data loss will occur in a standalone as well as the IDE, 
the only difference is that the IDE puts up a warning. But if you're 
careful to always reference the long name of the stack it should be safe 
I'd think.


--
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: Can a script preempt substack name conflicts?

[Richard Gaskin]

David Epstein wrote:

> The case I am contemplating would involve a user creating new
> substacks to hold content.  While I can make sure each substack
> created by my program gets a unique name, if a file created on
> one machine is moved to another machine there is some chance of
> a conflict (reduced but not absolutely eliminated if I went to
> great lengths, like embedding in each substack's name "the
> ticks" at creation time).

See the UUID function in the Dictionary.

--
 Richard Gaskin
 Fourth World Systems

___
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