Does anyone know of a utility that will examine every filed in every record
and report which records and fields that have data in them that does not
conform to the field specifications?
This is to prevent other non FoxPro applications from having problems

Dear friends
I am using view to know the stock of products and a products file contained
2000 records.
I am passing UDF in view and its gives results but the problem is, its takes

our company is thinking of recompiling our existing Visual Foxpro 8
application to Visual Foxpro 9.
we would like to take advantage of the MS SQL database integration.
however, we've been told that while the .dbf databases can be easily

Algun manual recomendable para bajar ?
Difiere mucho el uso de sql server y vfp , entre las versiones 6.0 y 9 de
vfp ?
Gracias y saludos

I have a need to return both active and deleted records in one query,
allowing me to identify those records which were marked for deletion in the
child table. Sounds simple but it is proving a problem.
Thanks in advance

Hi people, this is Guillermo, from Perú.
I would like you to give some suggestions about my problem
I'm Using DB Postgre + VFP. Initially i thought using a DBC database +
remote views, but mi app will not work that way, because i am using

Hello, i am using self made remote views (updateable cursors) i begin
my function this way:
sqlexec(lc_conexion,"SELECT * FROM mytable","micursor")
the question is:   Does it bring ALL the records to my pc?

I need to Insert some data to MS SQL 2005  from VisualFoxPro. Is it
possible?
br,
bala nemate

Hye
I m working on daily attendance in payroll system, I have to define the
weekly rest of employees. I use DOW() function but I m not understanding
that how can I get the rest dates in one month. Would somebody help me.

Dear Friends
I have two files e.g. order and receipt and both have a common field IND_ID
Now when i order suppose order no1,2,3,4,5 etc.
And I received order no.2,4

I have to compare two fields to determine if they meet certain
conditions, but I don't know how to do it.
The criteria is if Field 2 is blank or if one of the items match one of
the items in Field 1 then they meet the condition, if not they don't

Lets say I want to select ALL my target customers (customer.Target =
.T.) and I want to see how many times I called on them call.consultant =
"Rob", call.type = "A Call".
I want to see all my target customers whether or not I have seen them or

I don't know how to explain - this so here goes
A one to many relation with 2 tables
Table1 customer
custkey Name

I am running a SQL select statement to query a third party SQL 2005
database.  I am attempting to query a table which has a date column
formatted in datetime, yet I want the results of the query returned
only with the short date (ie, mm/dd/yyyy), not the time information.