Re: sqlYoga wierdness

2022-11-28 Thread Bob Sneidar via use-livecode
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 w

Re: sqlYoga wierdness

2022-11-28 Thread Bob Sneidar via use-livecode
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

Re: sqlYoga wierdness

2022-11-28 Thread Bob Sneidar via use-livecode
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 prod

sqlYoga wierdness

2022-11-28 Thread Bob Sneidar via use-livecode
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_d

Re: [OT] Upgrade to Monterey from Big Sur

2022-11-28 Thread matthias rebbe via use-livecode
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

RE: [OT] Upgrade to Monterey from Big Sur

2022-11-28 Thread 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

Re: [OT] Upgrade to Monterey from Big Sur

2022-11-28 Thread matthias rebbe via use-livecode
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-

RE: [OT] Upgrade to Monterey from Big Sur

2022-11-28 Thread Ralph DiMola via use-livecode
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

Re: [OT] Upgrade to Monterey from Big Sur

2022-11-28 Thread Richmond Mathewson via use-livecode
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

[OT] Upgrade to Monterey from Big Sur

2022-11-28 Thread 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 __

Re: App not printing

2022-11-28 Thread Dan Friedman via use-livecode
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 entitle

RE: use-livecode Digest, Vol 230, Issue 17

2022-11-28 Thread Ralph DiMola via use-livecode
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

App not printing

2022-11-28 Thread Marty Knapp via use-livecode
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 __

Re: use-livecode Digest, Vol 230, Issue 17

2022-11-28 Thread Bob Sneidar via use-livecode
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. Tha