I have one from that will work fine and ten it will start to have C5 errors.
Then the C5 errors stop and they can use the form for a couple of hours or a
day or 2 and then C5 errors again. Every workstation.  I thought it was a
network problem but none of the other forms have ...

VFP7.0 XPSP2
I have a chraracter field contains dates such as "November 7, 2006" or "July
14, 2006"
how i can convert it to short date dd/mm/yyyy format ?

Can somebody tell me if there is something I can do to speed up this query?  VFP9 is telling me that it is fully optimized yet it takes 11 seconds to run.  
The total number of records in the table is 233556 records.
The query is summing 10259 records.
SELECT SUM(ST_Qty) FROM ...

We owned a few copies of Visual Studio back in the day, and that's where
our VFP 6 came from.  We are planning to purchase VFP 9 but have a few
questions.  We're currently running the SP5 version.
1.  Is 9 still current?  Plans for a future version?

Is it possible to connect to MS Sql server through Internet?
If Yes, how to?

how to change date time of the system form VFP
Rajesh

Is there a way to stop the form from maximizing when a user double-click on
the top part of it (by the form name)?
thank you,
HME

I am using Visual FoxPro 6.  I have several text files which all
contain similar data (fields in the same order), but of course have
different filenames.  I know to use the GetFile command to prompt a
user to select 1 file on a disk, but I would like the user to be able

How can I anchor a command button at the bottom-center of a scrolling form
that has a vertical scroll bar.  So as you scroll, the bottom stays at the
bottom center.  I don't care if it is overlapping other controls or not as
you scroll.

I have the problem with the listbox control.
Problem is that I can add item with the nItemID  bigger than 32767, i.e.
Control.AddListItem(cItem , nItemID)
I have the following (pseudo) code:

At SQL server:
create table aaa ( aaa text )
insert into aaa values ( '' )
At Foxpro:

I have 2 tables in SQL Server, quite big, about 200,000 and 300,000 records,
and they are in a parent-child relationship. What I want is to create a form
where I show the data of the parent table for a certain primary_key, and a
grid with the corresponding child records. How ...

Using Visual FoxPro 9 with service pack 1
If a FoxPro exe is installed on a file server on a LAN, is there a way to
find out # of instances of that exe being run from any workstation?

I'm needing help on this code:
**********************************************************
printer=ALLTRIM(thisform .list1.value)
APRINTERS(allprinters)

Long time no read...
Cheers all, it's been a good time while it lasted. I'll still be using FPW
for a few things in the future but for the past x months I've been heavily
involved in migrating our systems to R/3.