I transferred my .dbc and SQL2000 database (*.mdf and .ldf files) from
a computer with W2000 Server & SQLServer2000 (dual 2.8 GHz, 4GB mem) to
a faster machine with W2005 Server Ent. and SQL2005 (dual 3.4 GHz, 8 GB
mem).  The foxpro program creates remote views (using Create SQL ...

I am trying to use a candidate index to prevent duplicate entries in a table
in a vfp8 database but am having trouble because when I issue an 'insert
into' the table, the filter clause of the index, ".not. deleted()",  is not
'seen'.  I have tried several variations of the filter ...

I use foxpro 9.0 for develop a application.
i want to know that is there any tools for generate the SQL statement of all
tables in a database ?
Richard

I have a form that's giving me problems when I add a new record. This form
was working fine but I made a change a while back that is causing problems
but don't know what I might have done.
The way the form was working is that when the "Add" button is clicked, it

I have an application in local system. it is working fine. no problem in
saving data, but i transfer data to our server
\\server\d\app\data\mydata.dbc. for view & single data table entry no problem
, but when i use one-to-may form for entering data its

How to stop SQL server in VFP9?
Nick

i have create a client server application in vfp 9.0 using Access 2000
as back end. I have made the connectivity by sql pass through commands
by using a connection string.If an error occurs on one node and the
save button is clicked on another node an error occurs saying