Is there a way to enter a text description of each field
in a table so that a record description can be printed
with a description of what each field if for?
Currently, I maintain such a record description in Excel,

Can anybody tell me the correct sytax to change the next value in an AutoInc
field?
Ive tried something like the following but can't get it to work.
   "Alter Table MYTABLE Alter Column MYFIELD FieldType AutoInc NextValue

Has anyone experienced problems updating 2.6 dbf's from vfp6. Problems I
have experienced are that the cdx does not get updated correctly, in fact it
appears to completely screw the index  and reindexing from vpf6 does not
actually reindex correctly so that searches from 2.6 ...

How do I set Global variable in a form only ??
It mean the variable is visible within the form only no matter in any
procedure but it will be clear when the form is exit.

I have virtually no experiance with foxpro.  I am trying
to upload data sent by a client via excell spreedsheet
into my collection database.  I have successfully imported
the spreadsheet into foxpro and reconfigured the field

If I use Reccount() , this forces the entire remote table to be loaded in
the local cursor. But ...  in the status bar i see the records retrieved (
100 default ).
Thanks for some clues

I have a problem with use of the tables. I have a simple FoxPro Application
which contains a menu. First item in the menu is wizard one to many table
and second one is generating the report with SQL Select to Cursor and then
to report print...

I'm learning how to compile a free-standing executable
VFP6 application.  I've written a very simple program (six
lines), brought it into a project, then attempted to build
the executable.  Everything worked fine, but the

My application, amomng other things, at startup do this:
- create an instance of Word.Application using createobject
- copy a dot file in Wort startup folder
On some Win2000 systems, not all, with antivirus software installed

I want add multiple column with the following code
This code is in a For ... Next Loop
 lcCompteur = PADL(ALLTRIM(STR(lnCompteur,2)), 2, "0")
 lcAnn_FiscPP = "Ann_FiscPP" + lcCompteur + " n(4) "

Help would be much appreciated on the following
client/server issue
For the same form with four tables in the data
environment...

I'm pretty new to VFP (6).  Mostly just ever used what I knew from fox 2.6
for DOS and mixed it in with my VB experiences.  LOL.  Anyway, I decided to
delve into the dbc for this small conversion I'm doing.   I've got a routine
for reindexing and recreating the p-keys, foreign keys ...

I have a select statement with DISTINCT
select distinct somast.partnbr, somast.discription
soitem.fenumber
from somast

hello,
I have a .dbf file that I need to move every hour to my
local computer.  Keep in mind that I cannot use SQL!
Please give any advice that may help??????

How can I protect VFP database *.dbf being access or modify using
other utility tool ?? So the user only can using application to go in
to update the data.