why i can't include GROUP BY clause in my  SQL-string ?
thank

at the beginning of a program I have:
SELECT service, count(*) as totpcs FROM scan_in GROUP BY service
I don't want to see the query result, I tried with NOCONSOLE and NOWAIT, but
it still displays.

I have a click button created several times over and I need to run following command based on what I have in variable "thisform.addfoldername".  
         w=thisform.addfoldername
         thisform.my_ctnlistbar1.listbar1.+(&w)+.folderheader.click()
the above command doesn't ...

I use VFP 8.0
I would like to simulate the print-screen (stamp) button
Any ideas ???? thanks
KEYBOARD '{ xxx   }'

VFP80 SP1 on XP
I have a basegrid in MyClass.
I have added it to a form.  When I run the form, I programmatically want to add a column and a Click() event to that column.  I do not understand the Help screens on this issue.  Anyone have a simple example.
TIA

From the VFP IDE I run a program that got stuck into an infinite loop.
How can I exit from that? Ctrl+Z, +C, +Break didnt' work and I had to kill
the application from Windows.
thanks

Maybe I haven't yet understood anything in VFP...
SELECT field1, field2, field3 from tableA INTO CURSOR answer
SELECT field1, field2, field3 from tableB INTO CURSOR answer2
select answer

A listbox shows values selected from a query.
I entered the query directly into RowSource property.
How can I capture the returned value(s)? Should I add a command button?
Is there any class with a pre-made sample of such a simple form?

I need to know if our program is running on NTFS.  I figure I could do this
with OS(11).  I am just checking if this is right.  We only have NTFS
stations so I can't see what a Win 98 will return with that function.  I am
guessing it will return a 0.  Is this right?

VFP8
How do I set the focus to a form after I instantiate it and display using
Visible = .T. ?
Eg.

I have been tasked to determine the feasability of importing
data from a Filemaker Pro database to a VFP database.  I will
just require raw data as opposed to rules, etc.  Is there anyone
out there who has gone down that path?

I made a change to a header file, then recompiled the project, with
"Recompile all files" checked. The header file change didn't take, so I
tried it again. Still no good. I discovered that none of the fxp's had
changed. I had to delete the fxp's to force them to be rebuilt.

I have a simple (I think) question.
From a field I want to change only the first word from upper to ower case.
Except for the first letter, this one should stay Upper
Thanx

How can I check the existence of o variable ?

I'd like to set my project paths automatically so I don't have to key in
'set default' every time I load a project. I've tried to do this by putting
'set default' in my project hook and the config file but it still loads with
the default VFP path.