Re: use-livecode Digest, Vol 230, Issue 17
I can imagine a lock/unlock wrapper that registers every lock screen request and will only unlock the screen if called from the same handler or uses the same passed ID as the lock handler. You could have a property for each registered lock to allow or disallow override from another unlock. That may be too comlicated though. Is it possible to check if the screen is locked first? Bob S > On Nov 23, 2022, at 09:42 , J. Landman Gay via use-livecode > wrote: > > I like to surprise people. :) Basically I was hoping to avoid brute force, > but it looks like import/export may be the best way. If I do the stacks only > a few at a time I'll only need a dozen passes or so. > > Part of the problem was determining which locks need changing and which were > not visual effects, or which were locked in one handler and unlocked in a > handler that might be elsewhere, sometimes even in a different stack. Some > manual examination seems required. Fortunately the latter is rare. > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.com > On November 23, 2022 5:58:41 AM info--- via use-livecode > wrote: > >> Hallo Jacqueline, >> Well I wouldn’t expect you asking such a question..! > > > > ___ > 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
App not printing
I have an app built with LC 9.6.7 (I believe) and this morning my tech support is flooded with people who are unable to print and some reporting error 1002 on Mac but the there are some Windows users reporting they cannot print either. Anybody else seeing this? --- Marty Knapp ___ 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: use-livecode Digest, Vol 230, Issue 17
Bob, Yes you can "put the lockscreen" 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 Bob Sneidar via use-livecode Sent: Monday, November 28, 2022 11:25 AM To: How to use LiveCode Cc: Bob Sneidar Subject: Re: use-livecode Digest, Vol 230, Issue 17 I can imagine a lock/unlock wrapper that registers every lock screen request and will only unlock the screen if called from the same handler or uses the same passed ID as the lock handler. You could have a property for each registered lock to allow or disallow override from another unlock. That may be too comlicated though. Is it possible to check if the screen is locked first? Bob S > On Nov 23, 2022, at 09:42 , J. Landman Gay via use-livecode > wrote: > > I like to surprise people. :) Basically I was hoping to avoid brute force, > but it looks like import/export may be the best way. If I do the stacks only > a few at a time I'll only need a dozen passes or so. > > Part of the problem was determining which locks need changing and which were > not visual effects, or which were locked in one handler and unlocked in a > handler that might be elsewhere, sometimes even in a different stack. Some > manual examination seems required. Fortunately the latter is rare. > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software > | http://www.hyperactivesw.com On November 23, 2022 5:58:41 AM info--- > via use-livecode wrote: > >> Hallo Jacqueline, >> Well I wouldn’t expect you asking such a question..! > > > > ___ > 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: App not printing
Marty, I had a similar issue. The only way to resolve the issue was to add the printing entitlements. Apps uploaded to the Mac App Store must have the sandbox environment enabled, and for every functionality that needs to communicate with the "outside world" it needs the appropriate entitlement. See section 16 of lesson: https://lessons.livecode.com/m/4071/l/876834-signing-and-uploading-apps-to-the-mac-app-store In the entitlements list, you need to add the printing entitlement (com.apple.security.print). Hope that helps! -Dan On 11/28/22, 8:28 AM, "use-livecode on behalf of Marty Knapp via use-livecode" wrote: I have an app built with LC 9.6.7 (I believe) and this morning my tech support is flooded with people who are unable to print and some reporting error 1002 on Mac but the there are some Windows users reporting they cannot print either. Anybody else seeing this? --- Marty Knapp ___ 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
[OT] Upgrade to Monterey from Big Sur
Is it possible for me to upgrade my M1 Mac mini Big Sur to Monterey? I did some searches but I can't find anything. Software update only lists Ventura as an upgrade option. Thanks! Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net ___ 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] Upgrade to Monterey from Big Sur
You will have your own reasons for wanting to move to Big Sur and not up to MacOS 13. But, from my own experience after Catalina my experience with MacOS was distinctly off-colour unti I hit MacOS 13, which, once you overlook the way they mucked up the System Settings thing, does feel a whole lot more robust that the beta-quality stuff Apple lobbed ourway after Catalina. On Mon, 28 Nov 2022, 21:09 Ralph DiMola via use-livecode, < use-livecode@lists.runrev.com> wrote: > Is it possible for me to upgrade my M1 Mac mini Big Sur to Monterey? I did > some searches but I can't find anything. Software update only lists Ventura > as an upgrade option. > > Thanks! > > Ralph DiMola > IT Director > Evergreen Information Services > rdim...@evergreeninfo.net > > > ___ > 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] Upgrade to Monterey from Big Sur
Richmond, Thanks. I had heard of some Ventura issues so I wanted an established OS to update to in order to run Xcode 14. I guess a time machine final backup and then let Ventura rip as an update? Any issues you've seen? 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 Richmond Mathewson via use-livecode Sent: Monday, November 28, 2022 2:16 PM To: How to use LiveCode Cc: Richmond Mathewson Subject: Re: [OT] Upgrade to Monterey from Big Sur You will have your own reasons for wanting to move to Big Sur and not up to MacOS 13. But, from my own experience after Catalina my experience with MacOS was distinctly off-colour unti I hit MacOS 13, which, once you overlook the way they mucked up the System Settings thing, does feel a whole lot more robust that the beta-quality stuff Apple lobbed ourway after Catalina. On Mon, 28 Nov 2022, 21:09 Ralph DiMola via use-livecode, < use-livecode@lists.runrev.com> wrote: > Is it possible for me to upgrade my M1 Mac mini Big Sur to Monterey? I > did some searches but I can't find anything. Software update only > lists Ventura as an upgrade option. > > Thanks! > > Ralph DiMola > IT Director > Evergreen Information Services > rdim...@evergreeninfo.net > > > ___ > 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: [OT] Upgrade to Monterey from Big Sur
I think under software updates only the newest os version is listed. The older versions need to be downloaded from the App Store Does this link work for you to download Monterey. https://apps.apple.com/us/app/macos-monterey/id1576738294?mt=12 > Am 28.11.2022 um 20:09 schrieb Ralph DiMola via use-livecode > : > > Is it possible for me to upgrade my M1 Mac mini Big Sur to Monterey? I did > some searches but I can't find anything. Software update only lists Ventura > as an upgrade option. > > Thanks! > > Ralph DiMola > IT Director > Evergreen Information Services > rdim...@evergreeninfo.net > > > ___ > 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] Upgrade to Monterey from Big Sur
Matthias, Thanks. I will give the link a look. I need to run Xcode 14 for the iPhone 14 simulator to do some testing. 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 matthias rebbe via use-livecode Sent: Monday, November 28, 2022 2:27 PM To: How to use LiveCode Cc: matthias_livecode_150...@m-r-d.de Subject: Re: [OT] Upgrade to Monterey from Big Sur I think under software updates only the newest os version is listed. The older versions need to be downloaded from the App Store Does this link work for you to download Monterey. https://apps.apple.com/us/app/macos-monterey/id1576738294?mt=12 > Am 28.11.2022 um 20:09 schrieb Ralph DiMola via use-livecode : > > Is it possible for me to upgrade my M1 Mac mini Big Sur to Monterey? I did some searches but I can't find anything. Software update only lists Ventura as an upgrade option. > > Thanks! > > Ralph DiMola > IT Director > Evergreen Information Services > rdim...@evergreeninfo.net > > > ___ > 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: [OT] Upgrade to Monterey from Big Sur
Btw. Do you know Virtual Machine Hub? https://sascha-simon.com/en/vm.html And if you need an older recovery image than the one the Virtual Machine Hub offers, you can find download links (from Apple website) here https://ipsw.me/ Maybe this is also a possible solution for you without updating your current system... > Am 28.11.2022 um 22:43 schrieb Ralph DiMola via use-livecode > : > > Matthias, > Thanks. > > I will give the link a look. I need to run Xcode 14 for the iPhone 14 > simulator to do some testing. > > 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 matthias rebbe via use-livecode > Sent: Monday, November 28, 2022 2:27 PM > To: How to use LiveCode > Cc: matthias_livecode_150...@m-r-d.de > Subject: Re: [OT] Upgrade to Monterey from Big Sur > > I think under software updates only the newest os version is listed. The > older versions need to be downloaded from the App Store Does this link work > for you to download Monterey. > https://apps.apple.com/us/app/macos-monterey/id1576738294?mt=12 > >> Am 28.11.2022 um 20:09 schrieb Ralph DiMola via use-livecode > : >> >> Is it possible for me to upgrade my M1 Mac mini Big Sur to Monterey? I did > some searches but I can't find anything. Software update only lists Ventura > as an upgrade option. >> >> Thanks! >> >> Ralph DiMola >> IT Director >> Evergreen Information Services >> rdim...@evergreeninfo.net >> >> >> ___ >> 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
sqlYoga wierdness
Hi all.
If anyone has any experience in using sqlYoga for joins, I have a curious
issue. The following code produces a variable tFoundOrphans containing a list
of service record IDs with no corresponding siteid in the Sites table, so I
know the query object works. However, when I use sqlquery_delete with the same
object, I get an error!
sqlyoga_executesql_err,0,0,Unknown column 'sites.siteid' in 'where clause'
(DELETE FROM service WHERE sites.siteid IS NULL)
Here's the code:
put sqlquery_createObject("service") into qServiceObjectA
sqlquery_set qServiceObjectA, "select clause", "service.siteid, sites.siteid"
sqlquery_set qServiceObjectA, "distinct", true
sqlquery_set qServiceObjectA, "joins", \
"LEFT OUTER JOIN sites ON service.siteid=sites.siteid"
sqlquery_set qServiceObjectA, "conditions", "sites.siteid IS NULL"
put dbQuery(qServiceObjectA, "data") into tFoundOrphans
setStatusMsg "Deleting service orphans from the service table...",
tParentCard
if tFoundOrphans is empty then
answer info "No orphaned service records found!" as sheet
else
sqlquery_delete qServiceObjectA
Answer info "Orphaned service records have been purged!" as sheet
end if
The SQL I am shooting for is:
SELECT DISTINCT
service.siteid
FROM
service
LEFT OUTER JOIN
sites
ON
service.siteid=sites.siteid
WHERE
sites.siteid IS NULL;
This works also in a SQL editor.
Bob S
___
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: sqlYoga wierdness
NVM. Of course, the query is going to rename the second siteid column
for sites to siteid2.
Bob S
> On Nov 28, 2022, at 16:11 , Bob Sneidar via use-livecode
> wrote:
>
> Hi all.
>
> If anyone has any experience in using sqlYoga for joins, I have a curious
> issue. The following code produces a variable tFoundOrphans containing a list
> of service record IDs with no corresponding siteid in the Sites table, so I
> know the query object works. However, when I use sqlquery_delete with the
> same object, I get an error!
>
>
> sqlyoga_executesql_err,0,0,Unknown column 'sites.siteid' in 'where clause'
> (DELETE FROM service WHERE sites.siteid IS NULL)
>
> Here's the code:
>
> put sqlquery_createObject("service") into qServiceObjectA
> sqlquery_set qServiceObjectA, "select clause", "service.siteid,
> sites.siteid"
> sqlquery_set qServiceObjectA, "distinct", true
> sqlquery_set qServiceObjectA, "joins", \
> "LEFT OUTER JOIN sites ON service.siteid=sites.siteid"
> sqlquery_set qServiceObjectA, "conditions", "sites.siteid IS NULL"
> put dbQuery(qServiceObjectA, "data") into tFoundOrphans
> setStatusMsg "Deleting service orphans from the service table...",
> tParentCard
>
> if tFoundOrphans is empty then
> answer info "No orphaned service records found!" as sheet
> else
> sqlquery_delete qServiceObjectA
> Answer info "Orphaned service records have been purged!" as sheet
> end if
>
> The SQL I am shooting for is:
>
> SELECT DISTINCT
> service.siteid
> FROM
> service
> LEFT OUTER JOIN
> sites
> ON
> service.siteid=sites.siteid
> WHERE
> sites.siteid IS NULL;
>
> This works also in a SQL editor.
>
> Bob S
>
> ___
> 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: sqlYoga wierdness
I don't think there is a way to do this with sqlYoga. I tried "...
service.siteid AS siteid1..." and then referring to the columns with their
aliases, but that still does not work.
Bob S
> On Nov 28, 2022, at 16:17 , Bob Sneidar via use-livecode
> wrote:
>
> NVM. Of course, the query is going to rename the second siteid column
> for sites to siteid2.
>
> Bob S
>
>
>> On Nov 28, 2022, at 16:11 , Bob Sneidar via use-livecode
>> wrote:
>>
>> Hi all.
>>
>> If anyone has any experience in using sqlYoga for joins, I have a curious
>> issue. The following code produces a variable tFoundOrphans containing a
>> list of service record IDs with no corresponding siteid in the Sites table,
>> so I know the query object works. However, when I use sqlquery_delete with
>> the same object, I get an error!
>>
>>
>> sqlyoga_executesql_err,0,0,Unknown column 'sites.siteid' in 'where clause'
>> (DELETE FROM service WHERE sites.siteid IS NULL)
>>
>> Here's the code:
>>
>> put sqlquery_createObject("service") into qServiceObjectA
>> sqlquery_set qServiceObjectA, "select clause", "service.siteid,
>> sites.siteid"
>> sqlquery_set qServiceObjectA, "distinct", true
>> sqlquery_set qServiceObjectA, "joins", \
>>"LEFT OUTER JOIN sites ON service.siteid=sites.siteid"
>> sqlquery_set qServiceObjectA, "conditions", "sites.siteid IS NULL"
>> put dbQuery(qServiceObjectA, "data") into tFoundOrphans
>> setStatusMsg "Deleting service orphans from the service table...",
>> tParentCard
>>
>> if tFoundOrphans is empty then
>> answer info "No orphaned service records found!" as sheet
>> else
>> sqlquery_delete qServiceObjectA
>> Answer info "Orphaned service records have been purged!" as sheet
>> end if
>>
>> The SQL I am shooting for is:
>>
>> SELECT DISTINCT
>> service.siteid
>> FROM
>> service
>> LEFT OUTER JOIN
>> sites
>> ON
>> service.siteid=sites.siteid
>> WHERE
>> sites.siteid IS NULL;
>>
>> This works also in a SQL editor.
>>
>> Bob S
>>
>> ___
>> 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: sqlYoga wierdness
I see why. sqlquery_delete does not take anything into account except for the
where clause. The join and distinct properties are ignored. I will have to
recode using some other method.
Bob S
> On Nov 28, 2022, at 16:30 , Bob Sneidar via use-livecode
> wrote:
>
> I don't think there is a way to do this with sqlYoga. I tried
> "... service.siteid AS siteid1..." and then referring to the columns with
> their aliases, but that still does not work.
>
> Bob S
>
>
>> On Nov 28, 2022, at 16:17 , Bob Sneidar via use-livecode
>> wrote:
>>
>> NVM. Of course, the query is going to rename the second siteid column
>> for sites to siteid2.
>>
>> Bob S
>>
>>
>>> On Nov 28, 2022, at 16:11 , Bob Sneidar via use-livecode
>>> wrote:
>>>
>>> Hi all.
>>>
>>> If anyone has any experience in using sqlYoga for joins, I have a curious
>>> issue. The following code produces a variable tFoundOrphans containing a
>>> list of service record IDs with no corresponding siteid in the Sites table,
>>> so I know the query object works. However, when I use sqlquery_delete with
>>> the same object, I get an error!
>>>
>>>
>>> sqlyoga_executesql_err,0,0,Unknown column 'sites.siteid' in 'where clause'
>>> (DELETE FROM service WHERE sites.siteid IS NULL)
>>>
>>> Here's the code:
>>>
>>> put sqlquery_createObject("service") into qServiceObjectA
>>> sqlquery_set qServiceObjectA, "select clause", "service.siteid,
>>> sites.siteid"
>>> sqlquery_set qServiceObjectA, "distinct", true
>>> sqlquery_set qServiceObjectA, "joins", \
>>> "LEFT OUTER JOIN sites ON service.siteid=sites.siteid"
>>> sqlquery_set qServiceObjectA, "conditions", "sites.siteid IS NULL"
>>> put dbQuery(qServiceObjectA, "data") into tFoundOrphans
>>> setStatusMsg "Deleting service orphans from the service table...",
>>> tParentCard
>>>
>>> if tFoundOrphans is empty then
>>>answer info "No orphaned service records found!" as sheet
>>> else
>>>sqlquery_delete qServiceObjectA
>>>Answer info "Orphaned service records have been purged!" as sheet
>>> end if
>>>
>>> The SQL I am shooting for is:
>>>
>>> SELECT DISTINCT
>>> service.siteid
>>> FROM
>>> service
>>> LEFT OUTER JOIN
>>> sites
>>> ON
>>> service.siteid=sites.siteid
>>> WHERE
>>> sites.siteid IS NULL;
>>>
>>> This works also in a SQL editor.
>>>
>>> Bob S
>>>
>>> ___
>>> 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
