I need to run a .prg every day at 4:00 am. What is the easiest way to do it
other than getting out of bed and hitting enter?
And/or
Is there a way to start a ,prg and have it periodically check a directory

We need to connect, if possible, a Foxpro program to a SQL Database.   Is
this do-able??
We are using Foxpro 7.0 at the moment.
Philip

I used in mysql "select * from mytable order by FieldNumberNN limit
21,20 "  to bring next 20 records starting at row 21
I already noticed the clause limit is not supported, anyone can point
me how to get the same result in foxpro without getting all the table

I have been given a program to run, but the two tables that this program uses
have about 3 million records each. I calculated at the speed it takes to
complete this program, it would take about 1782 hours to do. I would
appreciate it if someone can find a much much faster way to ...

       I am working on a VB6 application and I need to retreive data from
VFP table into a recordset. The table consists of the following columns:
strm1, datdok, vrebl, rabat and many others. I open the recordset with the
following SQL command:

Ever since I began using VFP 8 from VFP7, I've started getting this a lot.
   "Table "name" has become corrupted. The table will need to be repaired
before using again. "
Help tells me "Either the table record count does not match the actual

When I'm trying to query the value of @@Trancount associated with the active
connection via
SPT function SQLEXEC( ) I'm getting the following error.
"Invalid call issued while executing a SQLMORERESULTS() sequence."

The following statement doesn't work. Apparently it is the "except"
statement that is not understood. However if I run the 2 select statements
separatly it works, allas it only gives the intermediat results.
Does anyone have an idea ?

If I want to search a substring of a field with VB6 for Access I use Like *
or with SQL I use Like % how do I do that with FoxPro.
   Thanks for any help!!!

I have a query, when I test it in the command window, I get the error
message: Queries of this type are not supported. My query is:
SELECT Endorsement.*, Repercentage.*;
FROM endorsement, repercentage;

I occassionally (and randomly) get the open dialog on a certain SELECT-SQL
statment.   I've added a check to confirm the file exists and even open the
DBF before the select statement.
I still keep getting the dialog occassionally.  Has anyone else encountered

I need to create a corss Tab query that has multi- row datafields. Is this
possible  and how?

What is the equivalent function to use in FoxPro for the CAST function in
this T-SQL statement:
SELECT * from tablex ORDER BY cast(pc_nos as integer) desc

OK I need this query designed....
Students
1234   Joe Blow
Courses

I have a database (FoxPro 2.6) I have no control over I can only read from
it. I am
trying to do a query there is a field that is text but had dates in it.
(date format is 00/00/0000) I would like to use a where statement or sort by