Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Number Field 3

Status
Not open for further replies.

drosenkranz

Programmer
Sep 13, 2000
360
US
Hello,

Does anyone know if there is an Auto Number Field available in any versions of VFP after VFP 7.0?

Will VFP 6 & 7 apps run on the same pc as a later version(s) of VFP?

Thanks for your time,

Dave

The 2nd mouse gets the cheese.
 
drosenkranz

It was added in VFP8.0. And yes they will run.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
 
Dave,
Just so there is no confusion - VFP 6.0 and 7.0 can't use the autoincrement fields of VFP 8.0.

Like Mike, I've got a number of versions of FoxPro on my system with no conflicts. As long as they all use their own CONFIG.FP(W) and resource files (Foxuser.DBF), all should work just fine. (I've got FP 2.0, FPD&W 2.5.b and 2.6a, VFP 5.0 SP3, 6.0 SP5, VFP 7.0 SP1 and 8.0 all installed and being used!)

Rick
 
HI

As far your question VFP6 / VFP7 /VFP 8 applications running on the same pc.. others answers are very much on the dot.

1. When you develop on VFP8 or recompile a VFP7 one on VFP8, you have to take care of few things. One is SQL behaviou..

How to make my VFP7 or earlier coded SQL to work in VFP8?
faq184-3573

2. Another point is Windows Themes. By default, windows themes are turned .t. and so some of the Pages and such will follow Themes rather than the individual settings of back color etc. If you need that then, at the global level, you can set the themes off with
_screen.Themes = .f. to start with in the main.PRG

3. Beware of appending data using autoincrement field by using an application from earlier versions. The incrementing will not talke place if used with earlier version.

4. Beware that the AFIELDS function now returns 18 columns as against 16 columns of earlier version. SO if you have used that in earlier versions, have acheck to appropriately modify in the upgrade.

and there could me more, but these immediately flashed to me.

:)

ramani :)
(Subramanian.G)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top