Is it possible to find out when a view has returned ALL the records after
issuing a USE statement?

Is this possible.  To explain myself, here is my situation.  I created an
Excel Spreadsheet that uses an ODBC link to a SQL database.  In order for
anyone to use this file on their PC, that same ODBC link must be setup.  Is
their some code I can use within a Select Statement that ...

Is is possible to use a parameter to change the sort sequence of a View at
runtime? I know I can use an index but that seems a bit long winded.

i'm using vfp9 and mysql as my database.
I use the sqlexec command to insert, update and delete records. After i
execute, i want to know if everything works fine, so i thought i use:
PROCEDURE errhand

I don't use VFP very often but am quite versed with VB6 and VB.NET using ADO
and ADO.NET. Can anyone post me a simple example of a VFP program that opens
a connection to a SQL Server and reads a RecordSet (or some such object)
into VFP, then writes data to a SQL Table?

i work with foxpro 9 and mysql 5.0. As i work in a bookstore i have to add
thousands of titles everyday to my database. I use the sqlexec command to do
this wich works very fasts. To be sure that a quote ( ' ) is handled
correctly, i put a \ before it. This works fine, except when ...

I have a form on which I use a grid to maintain a table located on a remote
SQL server.
I use a view to access the data.
My problem is that because the application runs across a LAN and thus can be

What is the SQL equivalent to a REPLACE ALL command in VFP?
I found this in the help section:
SELECT REPLACE('abcdefghicde','cde','xxx')
GO

Hello friends,
I have the following table:   mytable (itemID, field1, field2) where there
could be several records for the same itemID but only one per itemID-field1
combination.

I have a little routine that creates an email. I can put what ever I want in
the message body with something like:
lcBody="This is the message body part 1."+"And this is part 2."
but I can't figure out how to get a carriage return between the first string

I am using a VIEW to return all the records from a remote SQL table and then
populating a simple grid.
I then allow the user to select one of the rows from the grid and update the
information in another form which uses its own private datasession.

I am able to pull data from a SQL server using a simple select statement with
the SQLEXEC in VFP.
I am trying to select only a few records from the SQL server database into
new fox table.

I am having difiuclty in setting up a linked server on SQL 2000 to work with
a foxpro database.
I am using foxpro 8 and the relevant oledb driver downloaded from MS
website.  However when I try to use the linked server