I use VFP8. I have a table with one Character field and
one numeric field. I issued the command "Sele cField1, Sum
(nField1) from Table" and I get a Error "SQL: Group By
clause is missing or invalid" I issued command "Sele *

When using the cursoradapter builder and you choose the Build option
to select a table and fields (and finally the Schema), at more than
one point in the process the OBC driver for MySQL receives a Select
statement that pulls all records down, even though only the structure

how can i do this
declare @var1 nvarchar(30)
set @var1 = 'MyColName'
Alter Table MyTable Add @var1 Money Null

In DOS Fox 3.0, I could "label form c:\forms\label.lbx to
c:\data\labels.prt" and it would lay out a full page of labels in a print
file. I could upload this file to my mainframe, insert form feed labels and
print from a line printer.

I'm trying to make a subselect, but I get a syntax error.
The statement is:
select naam, omschrijving from plek where naam in (select plek from
activiteit_plek where activiteit equals 'activiteit tennis');