Search results

"The result after running the above query shows zero records." Is that desirable or undesirable? What is the significance of returning no records?

True. And the reason we put teachers in charge of classes in school is that SOMEONE has to be the adult in the teaching/learning process. In parallel to that, parents are the adults in a family relationship.

I think what Pete is suggesting is that you use the search term "collection", not the specific name of any given collection. But I may be reading his suggestion wrong.

At some point, one of you has to assume the role of "adult in the room". If you defer to AI to fill that role, yeah, you lose.

I seriously doubt that AI will fade, no more than the internet faded after the dot com bubble burst in the late 1990s. In fact, the cycle is familiar. The "cloud" went through its period of over-hype and settled into a more rational role. Of course, I could be wrong about that. Maybe no one...

Isn't it to be expected that increased usage would lead to better understanding of the strengths and weaknesses of AI. Unrealistic hype was behind the initial exuberance for AI and also behind claims that it was going to end all human employment as we knew it. It's always been thus with new...

In this case, though, I would have spent even more time figuring out the code in the first place. Also, the quality of the resulting code has to be taken into consideration as well.

I just surfaced from a frustrating vibe session with Claude. I asked for a set of Stored Procedures to manage extended properties on tables. Long story short, the internals of reading, listing, appending and deleting extended properties are, as you might surmise, cryptic. So the first request...

PowerApps now has User Defined Functions (UDF) that accept parameters, perform calculations, and return results. Not quite VBA, but moving in the right direction.

Old? Ha.

I suggest that the likelihood a consumer would have food recall information prior to a chain supermarket having that information is probably not all that great. However, that might depend on how far out in the hinterlands the store is located and whether the store manager is concerned about...

Post #114 right before I posted it in Post #115

Hypothetical question: USDA announces a recall of eggs due to salmonella contamination. I don't see the announcement myself. The next day I go shopping at the local chain supermarket where I buy eggs. How likely am I to buy salmonella contaminated eggs? I.e. what are the odds that the chain...

Yes, language settings matter.

Given the snippet shown, it should work, but that is why we need to see the actual SQL, not parts of it. The error about syntax or missing operator suggests the problem is elsewhere in that SQL, so that's what we need to evaluate. Also, please confirm that DateCost is a datetime datatype...

Please show us the SQL from the query. Not a screenshot of the query designer. The copy and paste the SQL, please.

This display format would be for display only, though, correct?

The blades come out whenever a site owner even suggests advertising.

Proceed at your own risk, because you've now been advised of the increased potential for fraud. If you deliberately open this system up to allow deletion or modification of already invoiced orders, mostly bad things can happen after that. I suggest, though, that rather than taking our word...

I doubt that an independent auditor would sign off on the idea that an order could be deleted after an invoice for that order was produced. That is an open invitation to fraud. I once worked on such a system as a matter of fact. One of the main reasons the company I worked for at that time was...