Pls tell me
How to Connect VFP to MS access database
Bhuvan

Does anyone have a routine that i can use that would merge a sub table back
into the main table?
I need to be able add new records, delete records that are no longer there
and update existing records.

I have a query that creates a temporary table #TempTable in the
SQLServer.  #TempTable is then read by other queries using the same
connection.  They work OK until I change the 1st query to a
parameterised query.  The query still run successfully but the

I have two tables A and B the primary key for both tables
is the same - an expression consisting of two table
fields FirstName and LastName. In addition to these two
fields, each table has a third field Age.  I want to

I successfully upsized my database to SQL Server 2k. My programs are all in
VFP coding. How do I apply the SQL server database. Is that I need to change
all my coding in SQL language before I can use SQL server database. if yes,
how can I change the following coding:

I have a cursor with custnum, netamt and yearmonth.
AB-1003   123.99   2003-10
AC-2092   142.99   2003-10
AC-2092   564.74   2003-11

Moved from a Win2k machine to XP and my sql pass through data link appears to be broken - tableupdate, sql insert - neither works although I have no problem on the Win2k machine.
VFP ODBC driver on the Win2k machine is 6.01.8630.01 (6/19/2003)
VFP ODBC Driver on the XP machine is 5 ...

i don't know how to use select for create my cursor for report.
I have a table like this:
Id    Parent_id    level    Cod    description
1     0                     0         IN         internal

OK, I've cleared out my data environment on all my forms and replaced all data interfaces with sqlExecs with a few TableUpdates and such.  Things are stable for the most part.  Close to moving data into SQL Server and changing the connection string to point to the new data source ...

I need to export a file pipe delimited. How do I do that?

I have a data table containing service records going back to 1997.  The
structure of the table is similar to:
CustID N(6)
Svc_Date D

I can't get my group to work for some reason. What am I
doing wrong?  Here's the query:
SELECT blotter.portfolio,            ;
      blotter.type1 sectype,               ;

Anytime I try to create a view, appers am assistant to
generate query. How can I do to Edit my own query on Free
Edition?
Beforehand, thank you very much

Group, I (newbie) need help
How to construct SQL-Select from table Employee below into Temp cursor,
table employee :
emp_id        name        mgr_id

First off, I am not a FoxPro type but I shouldn't really have to be in this
case :=)
We have a ASP application in PERL that independently accesses and updates
data from an existing third party FoxPro database. We have been using ADODB