I need to count the occurances of a value in two tables. I can do
SELECT COUNT(*), MyField;
    FROM Table1 WHERE MyField = lcValue GROUP BY 2;
    UNION ;

I am running VFP 5.0 in conjunction with another Windows application. As
long as VFP runs by itself, my SQL statements, forms, reports, etc all work
fine. But when I open the other Windows application it complains, saying
that the files are busied by somebody else. If I close VFP, ...

I have a simple problem. I can't see Query/View parameters in my VFP.
What I need to do?
I appreciate for your help.
Thanks , Reda

I am using SQLExec asynchronously.
1. I create a stored procedure (1st SQLExec call
2. I execute the stored procedure with 'EXEC storedproc parm1' as SQL (2nd SQLExec call
3. I delete the stored procedure using 'DROP PROCEDURE storedproc' (3rd SQLExec call

I'm wondering if someone can help me with a problem I'm having. I'm not a
programmer, but I wrote a program in Foxpro 8.0. This programs uses a few
tables. The problem I'm having is that I have one main table, I call it "&mid."
The name of this table changes everyday, I need to ...

I am using a view in my form whcih selects records from an orders table
which is linked to a master customer table by account number.
I began by using table buffering (5) so that I could just commit any changes
at the end of the session which was fine.

I have a table in my database sqlserve2k, i want to insert a new record. the
table field doesnot accept null value, if i write the insert line like that

cSqlStr = "INSERT INTO TABLE1 (field1,field2,field3) values

I want update one column in MS SQL - MSDE database. From FoxPro 7.0 I run program with Update command
UPDATE Remote_View_Name SET Column_Name=1
Remote_View_Name is view from one table Table_Name that have 50000 row. Program ran 1 hour and not all rows was updated
When I use SQL ...

Does anyone know what might be causing this error Exception code=C0000094
when I try to run the following command.
SELECT DISTINCT * FROM INVDTL INTO TABLE XXX
The INVDTL file has 16,693,685 records and a files size of 1,956,292KB.

I run any SELECT statement from the command window and it successfully
produces the screen of data that I want - except that the window displays
with a window-caption of 'QUERY'. Similarly, if I run the SELECT statement
from a push-button in a *.prg file the displayed window comes ...

When I do a SELECT from a table I want to sort by a DATE field as well as
some character fields. If I do the SELECT with just the DATE field only, the
command works fine. For example, SELECT LOG_LIST.DATE, LOG_LIST.OPERATOR
FROM LOGS!LOG_LIST ORDER BY DATE.

How do I display a text file in FoxPr
Thanks
Culam

LK
I'm using VFP 8.0 and every time I type a command this big yellow box comes up
show all the ways you can use that command. The problem is that it almost
covers the area where you're typing and it makes it very hard to view what

How I could know the Domain name of a specific pc (locally not remotely) in
VFP?
Thnaks for your help in advance.

I use a SQL statement to select data from two tables with a LEFT OUTER JOIN
and an ORDER BY. This works great, as it gets displayed in a grid on screen
in the correct order with the correct data.
However,  I want to print the sorted data as well. So, using the same SELECT