When I run following query, error occured.
Update Temp Set opbal=(Select sum(Amount) from Invoice)
Error: Function name is missing ).
Is VFP 6.0 Sql supports sub queries in Update Sql or I am missing something

Let's say I run a dating service (I don't but this analogy demonstrates my
real problem).
Girls A, B, and C are matched up with boys X, Y, and Z and their
compatibilities are scored and the table looks like this:

I have a dbf that has 260 thousand or so records in it of people. Each
person may have only one record or they may have multiple records but all of
them are grouped together. I want to, in a "counter" column, put a running
counter for each person in the file. In other words, if Joe ...

Thanks in advance for your help. I have some questions about the code I am
trying to write below.
1. Can you get  the SQLEXEC  below to go directly to a vfp table like the
VFP Select?

I'm building five views from a database.  Four of the five work fine, but the fifth one generates a recursive macro error
1206.  If I shorten the code (bring in fewer fields), the error seems to go away.  Strangely, this code was previously part
of a larger segment of code and the ...

SELECT  *  from  table  WHERE  ID  $  m.cString
This works fine in VFP.
Can I use $ when selecting data from MS SQL Server 2000?
Rolf

When I issue this Delete SQL command to remove matching records from one table to another, it only deletes the first matching record. I don't use the Delete SQL command too often and it seems a little limited - but seemed straightforward (keep in mind this table contains over 3 ...

I need a way to loop through a database field and create new files based on
a field name.  In the copy to statement, I want to be able to have the new
tables name equal to the fieldname.
USE tablename

I have an application that I developed in VFP7 and now needs to be updated.
I am considering porting it over to VFP8.  As a test I copied all of the
source code and data files to a separate folder and after adding the lines
to the MAIN.PRG:

Very basic question for a beginner
When applying the following I  " group by clause missing or invalid"
Sekect  *
from temp1

Please help me with this:
Table1 Contain:
ID                   Group
----------------------

I am new to FoxPro and have only one task that I need to complete.  I need
to create a query that will insert records from one table into another.  I
am using VFP8 and have tried the following:
INSERT INTO RIGHTSDATA!etti (etti.ticode);

I'm writing a new VFP application that uses ADO to access the
database. But I have a problem updating datetime fields. Only the date
portion is updated, time is reset to 0:00:00.
Hope you can help me out.

This frame of code get sintax error.
Which is the correct sintax ?
SELECT  Tipo__CF,;
   CodiceCF,;

given this table booksread:
reader title
------ -----
001     A