How do you use the cross tab tool to select more than one data item to
be summarized for the columns?
What I would like to do is select two fields for data, based on the
same column.

I was hoping someone might be able to help. I want to know how to update a
field in a table but using the tables field name in a variable.
Example:
projfield1="PUTMKT."+alltrim(fname1)+"_PRO"+alltrim(str(fperiod1))

I'm curious to if there's a way I can get VFP9 to upload a file via ftp to a
secure area that requires a login.
Thanks!
Buster

my invoice table got a payment date, in vfp tables, it will become empty (if
there is no payment for that invoice)
Now, I want to import them into SQL database, i got an error that about this
field ?

I need help putting together a function where I pass four coordinates X1,
Y1, X2, Y2 and have it return direction in degree of angle from 0 to 360.
Didn't do too well in geometry!!  Assume a flat X/Y plane.  I need to know
what direction zero is (left, right, up, down).

While this works
this.SetAll("fontsize",7, "Header")
this doesn't
this.SetAll("fontbold",.t),"Header")

I have two forms A and B.  They're both have the same memory vairable
city and county.  I did declare these variable to be private for each
form.
When i'm in form A there is a button to call form form B.  When form B

To print a data field derived .jpg file, the following code has worked well
in the past but now produces an OLE error code 0x800401f9: Error in the DLL.
    create cursor PHOTO ( entry G )
    append blank

I have commandbutton. I need to know which form object had focus just before
commandbutton gets focus. Commandbutton gets focus by Click Event.
I tried to use thisform.activecontrol but in some sitiuations this property
is empty and command vartype(thisform.activecontrol) = 'O' ...

Hey, I thought I wasn't supposed to get such errors with VFP9.
It doesn't look all that complex... Am I doing something wrong?
UPDATE counts SET ;
acnt = (SELECT COUNT(*) FROM mytable WHERE myfield = "A"), ;

i have an app that reads an editbox and runs a program to determine the price
of a product.  the editbox contains rules of my trade.  the process runs fine
until the number of characters in the editbox exceeds 7475 characters.  is
this  a known limit of foxpro, or do i have to ...

I need to debug an application on a client PC, where VFP is not present. I
have tried using messageboxes on strategic places in the code, but it's
quite tedious. Any good ideas on this?

Currently I use the following code to create a connection to SQL
create connection conName;
 datasource alltrim(odbcName);
 userid alltrim(SqlUser);

Friends,
Recently I posted a question with the SUBJECT heading of "Sending KeyStrokes
to another Windows Application". The replies have been very helpful and did
what I wanted. I further need to know the FULL title bar caption of the

I thought I had this problem all fixed up, but I discovered earlier
today that I still have a problem with multiple bands starting on a new
page. I recieved the patch from Microsoft that fixes the glitch. And at
the time I only tried running the report through foxpro. However when I