Re: [NF] INT vs MEDIUMINT vs SMALLINT vs TINYINT

2017-10-29 Thread mbsoftwaresolutions
On 2017-10-28 11:54, Stephen Russell wrote: Disk space is cheap. Database schema changes are not. Updates require testing as well as validation in all of the UI and UX environments. Indexes of int are easy and great. Indexes of Char, VarChar, or NVarChar are necessary. How the rdbms does su

Re: FoxPro DevCon in Frankfurt

2017-10-29 Thread Koen Piller
Sorry not very clear do you mean that for running a built exe with VFP10 No VFP9 runtimes need to be delpoyed only a VFP10. dll ? Op zo 29 okt. 2017 om 10:45 schreef Thierry Nivelet > They live side by side. > VFPA*.dll are enough. > You can safely test. > > Thierry Nivelet > http://foxincloud.

AW: recno() function in tsql

2017-10-29 Thread Jürgen Wondzinski
Yea, you need to get used again to my strange "black" humor... wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Richard Kaye Gesendet: Freitag, 27. Oktober 2017 16:31 An: profox@leafe.com Betreff: RE: recno() function in tsql Now we're all rea

RE: recno() function in tsql

2017-10-29 Thread Jürgen Wondzinski
Rafael, as soon as you got your SQL-Query from the Server it will be in a cursor at your VFP client. Therefor that cursor indeed has a recno(), and that's what Andy is talking about. Thus Andy's solution is totally useful, as long as you need that result only at the VFP side. wOOdy -Ursp

Re: FoxPro DevCon in Frankfurt

2017-10-29 Thread Thierry Nivelet
They live side by side. VFPA*.dll are enough. You can safely test. Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud > Le 29 oct. 2017 à 04:55, Koen Piller a écrit : > > Thierry, > What about the runtimes if one installs VFP10 aside VFP9SP2 when deploying > an