Searching classes and forms for something specific

2021-05-11 Thread Tracy Pearson
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

Re: Searching classes and forms for something specific

2021-05-11 Thread MB Software Solutions, LLC
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.

<> "" vs. NOT EMPTY(field1) in SQL and the former is better than the latter

2021-05-11 Thread MB Software Solutions, LLC
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

Re: <> "" vs. NOT EMPTY(field1) in SQL and the former is better than the latter

2021-05-11 Thread MB Software Solutions, LLC
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

Free Windows 10 development VMs

2021-05-11 Thread Alan Bourke
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

SET ANSI OFF

2021-05-11 Thread MB Software Solutions, LLC
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