I am trying to Update some fields in a VFP database through an "OLE DB
Provider for VFP" connection (from within a DTS package), specifically I
need to set the value of a field in one table to the value of a field in
another table based on a join. Now this can be done in SQL Server ...

Does anyone know some good sites where I could find examples of using
CursorAdapter (advanced examples too)?
Thx.

We are trying to convert our Visual Foxpro 5.0 application
to Visual Foxpro 8.0. A lot of bugs were solved by using
service pack 1 accept for one little problem.
In the application we are using remote views in buffering

Hi pple.
Pls help me.. have been stuck here for some hrs, trying to figure out what's
wrong.
I'm trying to assign a value that is of 'memo' data type from a foxpro dbf

I am trying to do the following in my SQL statement:
SELECT ALLTRIM(LEFT(Notes, 600)) as Note
FROM Customers
and I get the following error:

I have the following query (hypothetical):
SELECT Name, "123456789123456789123456789123456789123456789" as Numbers
FROM tbl_Test
But when the result set is displayed - I get the following:

Guy,
I have a table with field1,field2 which store db_amt & cr_amt
when i use select sql command, how can i get the Acc. Bal as shown below
into cursor file

Given the following cursor I need to construct a statement that would select
the part numbers where a priority one vendor was not set up. It would only
select from the following cursor parts two & three because a "Pri" 1 vendor
exists. If a "Pri" 1 exists with any other number 2-9 ...

I need to build a query that looks like:
                              -1
replace A with COS     (B) all
(looks like COS to the -1 power)

How can I use the MAX function on a field that has beth
date and time in it?
example:
09/23/2003 10:01:00 AM

How do I select records so that I only get the lastes
record and not all of the records?

VFP 8.0 and Windows 2000
"SELECT         PKey_Item, Itm_descr, Item_Size
+ ' ' + Sz_Measure + ' ' + Itm_Descr As szuom_itm_descr "
+ ;

How can I get the sheet names from an excel file.
How can I modify the "Sheet1$' parameter to be able to
use the sheet name(s) in the example?
Thanks.

I have a ASP page using ADO and want to insert a row into
the table but a YES/No field gives me a Cannot update the
cursor error... here is the insert... it is the recdel
field... I have used 0,1,T,F,Y,N,.T.,.F. and many

How do you print the results of a query, or a browse of a
table for that matter?