Method Community

[quote user="jnoneiliv1"]Do you think it's just a coincidence that you are using terms like "Where clause", "Select", "Distinct", etc.?[/quote] No coincidence and all those terms are all applicable - Distinct is the only one I always try to refer to as unique outside SQL statements.  [quote ...

Thank you for the replies. I have an Employment table that I originally created with the field 'Age 16'. I have since changed that to 'US Legal'. it is a simple check box for yes or no (actually a radio button on the website that provides the value into Method). My web-to-applicant form does not show that field anymore in the form ...

your the man! somehow some crap EVER so small like 5 tables got inserted in the top left hand corner so once you posted your solutions i started shifting stuff inward making sure everything was WELL within margins and i noticed this jumble up there moved stuff around to get to it and then deleted all of them and BAM back to normal.

Thanks Chad, that clears things up. I think we are writing an SQL statement though, you've just hidden the ugly bits from the user, made a nice gui to allow the user to build a statement by selecting a few key properties, fields, etc. and then written some code to parse that into whatever SQL language, object oriented, ASP whatever. Do you ...

Hi Andrea, [quote user="andrea"] Scenario 1 -my test payment. company email receives the 15 messages. My personal email (a Gmail account) receives "the email send failure alert" [/quote] This sounds like the scenario I described above. I'm going to explore this one further. [quote user="andrea"] Scenario 2- a ...

James, [quote user="jnoneiliv1"]I think answering this question in terms of typical SQL statement logic might help clear things up.[/quote] While it's helpful to answer in terms of SQL statement logic, we're not writing a SQL statement so I wanted to try and explain what distinct means outside a SQL statement. [quote ...

Rolf, Just wanted to let you know this issue was resolved.  You'll have to log out/in again, make sure you're on the April version of Method and make sure you republish the screen. ~Chad

Hi Bill, Do you mind telling me the steps you're taking in Method to get to that report? It sounds like its a custom report? The only other time I've seen this (I think) is if there is some report object that goes beyond the report margins. In the meantime, I'm going to try this in a couple of my accounts as well.

Hey Mark, Nice tip!

OK, I have a question about using 2 cells as the parameters for a SQL Statement. This code is not working because it is not recognizing STARTDATE and ENDDATE as parameters:       Dim STARTDATE As Date     Dim ENDDATE As Date     STARTDATE = Range("B1").Value     ENDDATE ...