When this happens to me it generally has meant that one of the fields in SQL is shorter than one of the fields in the DBF -- but that is...

Agree with laker 42 -- that's what I also do...

I use the 2.5 or 2.6 ODBC driver with VFP 6 and above without problems -- the process I use is to scan/endscan the DBF file one record at a...

Removal IDE hard drive would be fast and reliable.

Use MySQL for this purpose -- you will not be disappointed...

Regarding Access file size -- it can "blote" real big in a short period of time depending on activity against it.

Try loading the Access Database and them via the Access...

Whoops -- hit enter before I was done -- contact me offline at weissa@libinc.com so I can email you VFP code I use to do-the-do.

Piece of cake with VFP6 and later. Set up ODBC access to SQL Server and do a SELECT statement against the SQL Server Table of Interest -- this returns a...

Thanks so much "moeld" -- that should get me on target when this app gets converted to SQL Server bvackend.

It now has an Access backend and I will have...

Answer to Question "What is the second query?" -- There is no 2nd query -- the query with the left joins includes the parent table REQS and the three child...

Meant to say "If the data in the child tables were numeric data I could use the SUM function.....

Okay, so what's conclusion(s)?

1. There is no way to do this using a single select statement. (Note: If the data in the child tables I could use the SUM function...

The left join query is as follows -- syntax is actually for ODBC MS Access, but logic holds for SQL Server.

For an actual query I get about 400 records...

If the Server software was bought on a "per CPU" basis, CALs don't enter the picture.

Isn't that right ??

How do you set the view in EM to Taskpad ??