Why am I getting "COMMAND CONTAINS URECOGNIZED PHRAZE/KEYWORD" from the
following line.
=CURSORSETPROP("UpdateNameList", "custid Acincust.CUSTID, name
Acincust.NAME, fname Acincust.FNAME, company Acincust.COMPANY, ;

I am working on query to do the following:
Find the First day a customer purchased something and then sum the
invoices for the next 12 months after the first purchase date.
Select CustNumber, MIN(Salesdate) as First_sale, SUM(invoices) AS Total

I have the following scenario
SQL Server with 2 DB,  DB_one  and DB_two
DB_one as Table1, table2, table3
DB_two as NEWtable1, newTable2

I created a DSN for the VFP free table.
When I 1st queries the table, using SQL Pass thru it work correctly.
Then I use use under VFP environment  and change the table content and
queries the tables use the SQL Pass Thru.

I'm using VFP 9 and keep getting a Group By clause is missing or invalid
error on the below SQL;
SELECT Payroll.paydate, Payroll.job_no, Jobs.job_desc,;
 SUM(Payroll.gross+Payroll.bonus) AS gross,;

The following sql statement works fine in foxpro 2.0 for DOS and VFP 6 but
when executed in vfp 8 we get an error that group by clause is missing or
invalid.
Sele artrans.customer As acct,customer.Name,customer.city, artrans.Product,

I have a character value coming in (1,2,4,5) and I want to parse it by comma
deliminter and then put into a SQL statement WHERE clause.  For example, I
want the SQL WHERE Clause to look like this:
WHERE table1.finum = '1' AND table1.finum = '2' AND table1.finum = '4' AND

The query below displays a total of contributions in the GIVEN table for
each record in the GIVER table, but I want to find records where there is no
record in the GIVEN table that matches up with a record in the GIVER Table.
I want records where the total is ZERO, or more simply ...

I am tryng VFP 9.0 with a remote MS SQL DB.
How can I to write a correct string in order to connect my Cursor Adapter
with a remote MSSQL DB?
I have tryed this:

i have a set of tables - 'people', 'addresses' and an intersection table
'peopleaddress' with 3 columns peopleid, addressid and a PK. personid is a
foreign key into people and addressid is a FK into addresses The primary
keys on each table are int(4) autoinc