Is there a search tool out there that can search for criteria such as the
following:
The Column.Sparse is set to False. That same Column has a TextBox baseclass
in it.
I have already slowly parsed most instances of the Sparse property in my
search.
I know I can write something that can search
My answer would be to roll your own as you have using the SCX/VCX as a
table and looking at the baseclass and properties fields.
On 5/11/2021 10:12 PM, Tracy Pearson wrote:
Is there a search tool out there that can search for criteria such as the
following:
The Column.Sparse is set to False.
In case you weren't aware that NOT EMPTY appears to be unable to use
Rushmore optimization...
There is a regular index on the order.srep field. I added the SETs to
emulate the environment per legacy code.
The results are why I changed the original author's NOT EMPTY(field1)
SQL to field1
This was the prologue to the SET ANSI OFF thread. When I changed for
optimization's sake (because the customer had complained that the
original code was very slow), I got 0 results due to the legacy code
having SET ANSI OFF.
On 5/11/2021 8:47 PM, MB Software Solutions, LLC wrote:
In case
FWIW, for Windows 10 application development and testing purposes you can
download free virtual machines for VMWare, Hyper-V, Virtualbox and Parallels
from:
https://developer.microsoft.com/en-us/windows/downloads/virtual-machines/?WT.mc_id=-blog-scottha
These VM images come with these items
I was investigating why a simple query (SELECT DISTINCT srep FROM order
WHERE srep <> "") worked on my machine and yet when deployed, it did NOT
work. Instead of returning several dozen names, it was returning zero.
Now..."why did it work before?" Well, I had changed the query from using
6 matches
Mail list logo