Search results for query: *

Mike, I have seen Group By used in the field list before (at least in MS SQL), however not in this way specifically. I am trying to get a count for each row (that is, for each county). I was hoping to avoid having to do these counts in seperate selects, but that may be my only choice, seeing...

I have a rather complex query that is grouping counts. There is one specific field where I need to count distinct values only (but for specific criteria). I am using VFP 9 Beta and trying to use a sub-query in the field list like this (there are a lot more SUM's but I removed them for...

Duh! It's been forever since I've done these kinds of counts. Thanks guys! Sebastian Stella740pl (Programmer) Nov 22, 2004 Try this: SELECT County, State, ; SUM(IIF(!RSPFlag AND MailFlag,1,0)) as AddrCount, ; SUM(IIF(RSPFlag AND MailFlag,1,0)) as AddrResp ; FROM...

I need to write a select that counts fields for multiple conditions. I tried putting my conditions in the count function like this: SELECT County, State, COUNT(!RSPFlag AND MailFlag) as AddrCount, COUNT(RSPFlag AND MailFlag) as AddrResp FROM csrProspects GROUP BY County, State ORDER BY State...

Rick, I tried using BINDEVENTS() to the _screen.Closable property and it works while the program is initializing (the 'X' button stays enabled, when before it did not). However, once I switch to another app and then back, the screen 'X' becomes disabled. It seems like maybe VFP overrides any...

I have an exe running a form in the screen window. It has a timer event that is waiting for activity. I want the closable 'X' button to stay enabled, so I put code in the Timer event, _screen.Closable = .t. This works as long as the focus is on the screen, but when I switch to another app and...

Actually not, you'll note that even for the company name, the combobox is bound to the 3rd field which is the company code. I prefer to always seek by an id, rather than a description.

This seems to be the case. Although I am not sure what you mean by a 'link'. If you mean a relation, than I would say this is a problem, because I did not relate these cursors in any way. Why would VFP create a link between my two cursors when I did not set any relationship between them...

The incremental search does work on the first column. But in this case, as I said above, the incremental search only works on the first column of the second combobox once you have entered both comboboxes. No matter which combobox you are in, it will only search on the values of the second...

Ok, has nobody ever had this problem? Am I not providing enough information? Please, anyone let me know if they can reproduce this...I may report this to MS as a bug? Thanks in advance. Sebastian

I have to comboboxes that are on a toolbar and are related. One shows the company id number and the other shows the company name. This allows the user to select a company using either method. The problem is, once you have selected a company using both combo boxes, they both remain selected...

Thanks to both of you... Yes Mike, I want to do this because there are certain forms in which the user cannot have access to the menu. Also, F10 is a key that the users really, really use (back from the DOS days) - I argued against it, but they are so used to using it that it would interfere...

Does anyone know how to disable the F10 key in Windows? It activates the menu when pressed (even when I hide it) and I can't assign anything else to it even in the keypress of a form. Thanks.