First of all I hope you all had a Wonderful Xmas, and Have
a Happy new Year.
Now the question!
I have the following statement:

How to properly  handle update conflicts when using sql
I am getting Update conflict error  1585 on a update sql, handling a
complete table. I prefer not lock the complete table.
So my guess is to

the subject says it all.
Thanks in advance

I have to learn SQL. The samples in the VFP documentation are not enough to
make me understand enough.
Can anyone point to a good site ( or book ) on this?
Does VFP support nested queries like MS SQL Server does?

I am getting this error when I try to save some config information or do
some Imports of external files.
I get this when I work from a VFP application on a NT machine talking to a
SQL Server 7.0 on SP4 on a Win 2K machine SP4.

What is the proper syntax for appending data from an Excel
spread sheet? Either from a named range or a specific
worksheet?

I'm using ODBC connections for some time now, to connect to multiple
databases.
After some experimenting with the cursoradapter, I got it working with ADO
and MSDE.

I am connecting to the FVP databsae throw ODBC from FVP
application.
Is the SQL queries contains ORDER BY clause optimized
using RUSHMORE technology.

VFP 6.0
Is it possible to query/update a MYSQL DB with VFP?
Please post some sample code of connecting to the MYSQL DB
and doing a simple query/update on a customer table for

OleDbCommand cmd = new OleDbCommand("select * from table1 where id = @id",
new OleDbConnection(ConfigurationSettings.AppSettings["conStr"]));
cmd.Parameters.Add("@id",id);
cmd.Connection.Open();

I am using the OLE DB Driver for Visual FoxPro 8 to execute the following
SQL statement:
UPDATE    Table1
SET              DateField1 = {DateField2}

I have three tables Student Timetable, CourseDemo and Books
Student Timetable (Only pertanent fields)
IDStudent
IDCourse

Can you put nested iif's in Foxpro 5a in a field
expression for a query?
Are there limitations as to how many functions you can
nest in general?

We have created remote views in VFP to connect to SQL Server.We want to
access these views through ODBC driver(by creating dsn to .dbc file) in
Visual Basic.We are unable to do this. However, we are able to access local
views on vfp tables.

I have the follow table
order, id_customer, id_country
I need to find only the customers wich have orders in distinct country and
the numbers of orders