I am having trouble getting the average of a group
returned.  In SQL I have:
SELECT AVG(table1.column1) AS 'tempName', table2.column1
FROM table1 INNER JOIN table2 ON table1.column2 =

hi a beginner question. I would like to do a join here but i don't
know the syntax. Id is a key value.
select * from table1, table2,table3 where table1.id=table2.id=table3.id
how do i get the data then?

Wondering if y'all can see what I'm doing wrong here.
I have a table of campaign contributions, almost all have zips, but
some don't have states.(Presq123)
I have a lookup table with Zips and states. (Ziplkup.dbf)

I am needing to pull down about 150,000 entries from a remote MySQL
table (using SQLExec()). I am able to watch the network traffic buzz
as soon as the data server starts returning the results, and then the
network activity stops. The first 3,000 or so records are added to the

I am new to FoxPro and require a simple DLL.  All it
needs to do is take in a connection string and SQL
statement and return a XML string.
Here is the code that we are using at the moment:

The result of my query is a money datatype, but it shows to 4 decimal places

Thx

Does anyone know how to use the MODIFY CONNECTION command at runtime.
Whenever I try the command my machine hangs. I need to give my end user the
opportunity to change the connection parameters to suit their SQL Server
settings but MODIFY CONNECTION only seems to work in ...

I can group my query results by month or year when taking
month() or year() of a date field but keep getting an
error when trying to do this using quarter() - I can see
the column just find in the result set, but I can't group

the code below i hacked up to do what i think would be a left outer join for
test1 and billdests
the idea is that only some of the records in billdest will match those in
test1, but i want a result set that is

How do I catch feedback from SET TALK, that's displayed briefly on the
status bar, and put it into a table?

How do I print the strucutre of a database (all tables)
using a remote view?
Create SQL VIEW 'vViewName' REMOTE CONNECTION 'cODBCtoSQL7'
What goes here?

Is it possible to write a SQL script that would run in MS Query analyser and
send it to / execute it on the SQL server with:
a) SQLEXEC (SPT/ODBC)
b) DataEnvironement.DataSource.ActiveConnection.Execute (ADO)

im developing a software using VFP and SQL Server as my
back end. is there a way on how to terminate the
connection of other users in a database? let say, i was
able to login on workstation x, and then i also login to

Using VFP 6 in WinXP
IBM NetVista P-IV/2.0Ghz/1.5 Gb
I recently increased my workstation memory from 1 Gb to 1
1/2 Gb, and I now find that sql queries against FoxPro

I just upsized a database with its tables into MSDE and as the fields in the
tables include some icelandic letters they all come garbled out. Is there a
way to either change the codepage of the data in MSDE or translate the data
on the way out of MSDE? Which should not be a problem ...