++no

Again, invoking a subquery is going to let the database engine know: "OK, get all that stuff first, and THEN work on the rest of the query."
If he simple function call is giving you a more lazy evaluation evaluation, that might explain what's occurring.

Is there a threat (even a theoretical one) of the server going into an infinite loop based upon what you're doing?
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.

Take a couple pilz and call me in the morning.

But you see you are in the Windows CE embedded niche. Your vision is clouded.

I'm not in a "windows CE embedded" niche and the grandparent poster is right.

It's not an issue with the target. It's an issue with the platform(s) supported by the development tool vendors and the chip manufacturers.

For instance: With Bluetooth 4.0 / Bluetooth Low Energy (BLE), two of the premier system-on-a-chip product families are from Texas Instruments and Nordic Semiconductors.

TI developed their software in IAR's proprietary development environment and only supports that. Their bluetooth stack is only distributed in object form - for IAR's tools - with a "no reverse engineering" and "no linking to open source (which might force disclosure)". IAR, in turn, doesn't support anything but Windows. (You can't even use Wine: The IAR license manager needs real Windows to install, and the CC Debugger dongle, for burning the chip and necessary for hooking the debugger to the hardware debugging module, keeps important parts of its functionality in a closed-source windows driver.) IAR is about $3,000/seat after the one-month free evaluation (though they also allow a perpetual evaluation that is size-crippled, and too small to run the stack.)

The TI system-on-a-chip comes with some very good and very cheap hardware development platforms. (The CC Debugger dongle, the USB/BLE-radio stick, and the Sensor Tag (a battery-powered BLE device with buttons, magnetometer, gyro, barometer, humidity sensor, ambient temp sensor, and IR remote temp sensor), go for $49 for each of the three kits.) Their source code is free-as-in-beer, even when built into a commercial product, and gives you the whole infrastructure on which to build your app. But if you want to program these chips you either do it on Windows with the pricey IAR tools or build your own toolset and program the "bare metal", discarding ALL TI's code and writing a radio stack and OS from scratch.

Nordic is similar: Their license lets you reverse-engineer and modify their code (at your own risk). But their development platforms are built by Segger and the Windows-only development kit comes with TWO licenses. The Segger license (under German law), for the burner dongle and other debug infrastruture, not only has a no-reverse-engineering clause but also an anti-compete: Use their tools (even for comparison while developing your own) and you've signed away your right to EVER develop either anything similar or any product that competes with any of theirs.

So until the chip makers wise up (or are out-competed by ones who have), or some open-source people build something from scratch, with no help from them, to support their products, you're either stuck on Windows or stuck violating contracts and coming afoul of the law.

Good to see you again fustakrakich.

Swing and a miss, Ratzo.
It took a millennium and a half for the reformation to try to straighten out Scripture.
The point I made was that Luther incorrectly removed this.

So which would you use to inform your life and society? If you said, "The Bible", then even God thinks you're a moron. Because, way before there was scripture, there was man's ability to reason.

Read the Gospel; specifically read how Jesus reacted to Thomas' skepticism, and his message about those who haven't seen and still believe.

Man's ability to reason is deeply flawed. Man's "reason" once told the Egyptians it was OK to use the Hebrews as slaves. Man's "reason" today says it's OK for women to butcher their children in the womb.

I'm attacking liberalism as a demonic religion, I'm not attacking religion in general. I, for one, am a proud Catholic and will always remain one.

To this day, males 18+ must register. Those who do not cannot receive Federal financial aid, nor work as a GS or contract employee for the Fed.

Did it do a 4G inverted dive?

google broke into internet search with the page rank algorithm whose essential purpose is to combat "search engine optimization."

Yeah. They destroy legitimate businesses with their wonderful algorithms...

SEO isn't a legitimate business. If your website is getting pushed into the search-result basement, odds are you're doing it wrong.

Typo -- above should read: Martin Luther removed them from his Bible, and also wanted to remove a few other books as well --- James, for example.

Those books were part of the Bible until the Protestant Reformation. Martin Luther removed them from his Bible, and also removed a few other books as well --- James, for example.

But... But... Chicago is a gun-free utopia! No guns are allowed there, so everyone is safe and no one has to worry about getting shot. /sarcasm

I think most doctors believe its beneficial but I also think they somehow see acetaminophen opiate formulations as some kind of bulwark against abuse. Either because they believe it is so much more effective paired with acetaminophen and you'll be inclined to take less overall or that people "know" acetaminophen is bad in quantity and it will serve as a deterrent to excessive dosage, especially people with a history of drug abuse.

Also, the DEA watches doctors who prescribe opiates very carefully. If some government goon believes a doctor's handing them out like candy, the doctor's most likely going to be called in for some very uncomfortable questions. See chapter two of Three Felonies a Day for some examples.

The way scripts for opiates are handled is also quite different. My wife's oncologist was able to submit the vast majority of prescriptions to her preferred pharmacy electronically; they would be ready for pick-up a short time after. The one time she was prescribed straight oxycodone (or whatever opiate), it was printed on security paper to thwart attempts at altering or copying. It was signed, and some sort of DEA ID number issued to the doc was printed in the header. I had to deliver the prescription to a pharmacy. Her usual pharmacy didn't have it in stock, so I had to find another that did. Once it was filled, I had to sign for it in a logbook (similar to when you buy products containing pseudoephedrine).