I have about 50 part numbers and description in a list box.
What I want to do is to display quantity on hand in a separate text  box in
the bottom of the screen and as I move my mouse to next part number, it
should change the quantity on hand in the text box.  Quantity on hand is in

I am a new FoxPro programmer. I just modified a table, I added a field to it. and used that field in a view. I checked the view, it gave me the right answer, but when I run the application, opened the form that used the view, it gave me error message: "SQL: column 'colName' is ...

Is there a way to script a database? I have a dbc with nearly 200
tables, some of these tables have nearly 30 indexes. Every now and then
a table will get corrupted and what I end up having to do is rebuild the
cdx file.

Help,
How do I get a field to auto increment? VFP8
ThankX
JP

Been fussing with this a while and am stuck  Could really use code sample.
I have a Unix time value of 1081954800 which actually translates to Wed, 14
Apr 2004 15:00:00 UTC.
Using Excel I can get it to convert by this formula: =Value/86400+"1/1/70"

A customer has both an Access application and a VFP application.  He's
trying to link to one of the VFP tables for a query from within the Access
app, much as he would link to a SQL Server or DB2 or Oracle database table.
We've tried building both a "free-standing table"-DSN and a

Is there a posibility to access a smartcard in VFP? using winscard.dll?
If so, how does it have to be declared?
Can somebody send me a sample code.
Thanks,

I am trying to run the query, "set exclusive on;use table1;reindex" through
VFPOLEDB. In a machine with VFP6 installed, it works fine without any error.
But, when I try to run in a machine where just the dbc / dbf/idx files are
copied  (no VFP installed) and vfpoledb is installed, ...

Friends,
I am working with VFP6 on Access 2000 database. In Access I have created a
table with a 'date/time' field and format set as "short date". In access it
displays as date only, not date/time (E.g., 01/01/2004). That's fine.

Friends,
I am working with VFP6 and Access 2000
I have created a query "EmpGroup" in Access using the following statement
   PARAMETERS [p_group_key] Text ( 10 );

I ran across an article a while back on how to successfully convert dbase
DBF's (with NTX indexes) to VPF tables/import them programmatically.
Now, after having it printer for a month, I can't find it, and -surprise,
surprise- it would come in REALLY handy right now.

      VFP 7 dbc question ..... Is there a way to create a trigger
that gathers information from another table and places that
information in the table with the trigger. Ive got a  summary table
that needs to include information from the latest (a date field )

hi...
i have a some tabells that is corrupted. now... i need to add indexes to
some of the tables cuz they are missing, only i have to do this while the
tables are closed, becuase i cant open them... (dbf files).

I am trying to read a FoxPro table with a memo field.
The memo field displays FOXSQZ COMPRESSED FILE
I Googled and found this web page:
   http://ourworld.compuserve.com/homepages/masterw/

I am trying the run the below query through VFPOLEDB.
SET EXCLUSIVE ON; USE MyTable; reinde
The query doesnt return any error, but it looks like it has not done reindexing of MyTable as the size remains same (there were so many deletions / updations in MyTable. When I reindex from ...