Search results

Many a pedophile has blamed their victims. History is written by the victors who often claim that the vanquished were evil. The truth is the Hebrews were violently invaders and participated in multiple brutal genocides, looting the towns of those they murdered for precious metals and jewels...

Then there is the story of the incestuous pedophile, Job whose daughters bore him children. It blames the daughters and tells us Job is a good man. He also claimed his wife had turned into a pillar of salt when she mysteriously disappeared while in his company.

There are millions of happy people who don't accept the god myths. There are even more miserable believers.

God enjoys watching suffering. Otherwise He would stop it happening. He also loves the smell of burning flesh. Exod. 29. [18]. I guess that is why He created Hell.

Are you referring to the V-tools Deep Search? It would have found it in the forms. Best tool ever for this task and completely free.

Your irrational delusions are not a valid basis for a rational argument.

That is not a good query because it isn't SARGable. The criteria should involve operations on the current date that are calculated once, rather than being applied to FieldDate which requires every record to be processed and cannot use the index on FieldDate. The difference in performance won't...

Of course it is valid and efficient in its operation. What I am wondering is why you bother making all this extra work and what you imagine you are gaining over using ODBC linked tables and bound forms. Many developers with a fetish for using SQL commands don't seem to realise that they are...

Yes it is because an atheist business owner cannot consider the applicant's distasteful religious belief as reason not to employ them.

What do you perceive you are actually gaining over simply using linked tables? ODBC passes queries through where it can so it isn't likely to make significant performance differences under most circumstances. You are certainly making a whole lot of extra work. Part of the whole reason for using...

The frenzied postings by Aziz Rasul are doing a great job of turning people away from his brand of faith by portraying Muslims as mindless extremists.

In Australia it is illegal to discriminate on the basis of religion. Except of course for religious enterprises such as faith based schools who are allowed to discriminate against those who don't subscribe to their beliefs. It is hypocrisy of course but that is a fundamental tenet of religion.

The name TempVars is ironic as they are more persistent than any VBA variable, holding their value after a VBA reset. Some people think this is an advantage. I've never used them and never will.

The important matter of whether a query is SARGable or not has absolutely nothing to do with whether a field is going to be updated or not. Your comment ended in a question mark. I was asking what your question was. Did you actually have a question or was it meant as pointless rhetoric?

So?

NO! That suggestion is absolutely wrong. This expression requires a function to be run on every record before matches can be returned. Hence it cannot use the index on the date field.The difference in performance won't be noticed on small numbers of records but will become evident as the number...

Import the whole csv into a table as a single value. Then apply STRING_SPLIT with the ordinal argument set. (You will need SQL Server 2022 or Azure.) Then split the multiple records on the commas.

I think that is a fairly common situation. Many database administrators subscribe to hating Access. Some because they have seen troubled caused by Access dabblers who haven't got a clue what they are doing but many just to be part of that culture,

I am fortunate to have always been part of that IT team in my workplace with full access to the network configuration and database administration. Eventually I settled into the role of the designated database administrator as we took on more IT staff. The size of the business I'm in is now very...

I have long argued that putting temp tables in the front end is the equivalent of writing a shopping list in margins of an encyclopedia. Temp tables belong in a separate database which I call a "Side End". There are multiple ways to implement a side end. The easiest is to keep a pristine file...