Search results for query: *

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...

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...

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...

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...

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.