Re: FoxPro DevCon in Frankfurt

2017-10-28 Thread Koen Piller
Thierry, What about the runtimes if one installs VFP10 aside VFP9SP2 when deploying an exe built with VFP10, do you need both the VFP9 and the VFP10 runtimes ? And what happens with other applications running on that pc which where built with VFP9SP2 only? Regards, Koen 2017-10-28 18:11 GMT+02:00

Re: [NF] Varchar(4000) or varchar(max) (was INT vs MEDIUMINT vs SMALLINT vs TINYINT)

2017-10-28 Thread Ed Leafe
On Oct 28, 2017, at 9:41 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > Would you ever use fixed CHARs with a non-VFP backend for that fixed offset > advantage, again with the idea that storage is cheap/available? Sure, but of course it would depend on the details of the data. -- Ed L

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

2017-10-28 Thread AndyHC
Wouldn't you just use whatever the default autoincrementing field is? On 28-Oct-2017 6:25 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2017-10-28 02:05, Wollenhaupt, Christof wrote: That is largely dependent on the engine you use in MariaDB. Have you settled on one? Was just goi

Re: AW: FoxPro DevCon in Frankfurt

2017-10-28 Thread AndyHC
I think was referring to this: www.baiyujia.com/vfpcompiler/ and this: www.baiyujia.com/vfpadvanced/f_vfpa_about.asp On 28-Oct-2017 6:28 PM, Ted Roche wrote: On Sat, Oct 28, 2017 at 6:14 AM, Thierry Nivelet wrote: Frank W Moore has released the latest version of LienWriter (several hundreds u

Re: FoxPro DevCon in Frankfurt

2017-10-28 Thread Thierry Nivelet
> Would it be this? http://www.fwmsoftware.com/ yes ‘fwm’ standing for ‘Frank W Moore' > > Is this discussion of "VFP10" on Foxite? lots of discussion on Foxite about VFP10 alias VFP advanced; however Frank’s announcement was mainly on wwt and maybe LevelExtreme

Re: FoxPro DevCon in Frankfurt

2017-10-28 Thread Thierry Nivelet
VFP 10 installs aside VFP9 — easy to test, and risk free http://www.baiyujia.com/f_download.asp Thierry Nivelet FoxinCloud Give your VFP app a new life in the cloud http://foxincloud.com/ > Le 28 oct. 2017 à 13:19, Charlie-gm a écrit : > > On 10/28/2017

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

2017-10-28 Thread Stephen Russell
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 such, and how the dba defines the index to accept

Re: [NF] Varchar(4000) or varchar(max) (was INT vs MEDIUMINT vs SMALLINT vs TINYINT)

2017-10-28 Thread mbsoftwaresolutions
On 2017-10-28 09:58, Charlie-gm wrote: It's not really allocating the space like a CHAR(n) field would...right? The main problem is the database engine, and anything that has to allocate memory from data from the database engine, has to constantly assume the field size could jump up to 4000 (or

Re: [NF] Varchar(4000) or varchar(max) (was INT vs MEDIUMINT vs SMALLINT vs TINYINT)

2017-10-28 Thread mbsoftwaresolutions
On 2017-10-28 09:53, Ed Leafe wrote: On Oct 28, 2017, at 7:58 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I don't do that but I thought using varchar(n) fields were supposed to be space-efficient in a sense that it just used a extra 1 or 2 bytes up front at the head of the record t

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

2017-10-28 Thread mbsoftwaresolutions
On 2017-10-28 09:45, Ed Leafe wrote: On Oct 27, 2017, at 11:48 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: The OCD part of me wants to define the smallest type possible, whereas the "let's set it and never worry about it" part of me says "just make everything INT." It's not just

Re: [NF] Varchar(4000) or varchar(max) (was INT vs MEDIUMINT vs SMALLINT vs TINYINT)

2017-10-28 Thread Charlie-gm
On 10/28/2017 8:58 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2017-10-28 07:17, Charlie-gm wrote: Whatever the case, please don't do something idiotic like declare "VARCHAR(4000)" for fields that will never have more than 20 ... I don't do that but I thought using varchar(n) fiel

Re: [NF] Varchar(4000) or varchar(max) (was INT vs MEDIUMINT vs SMALLINT vs TINYINT)

2017-10-28 Thread Ed Leafe
On Oct 28, 2017, at 7:58 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > > I don't do that but I thought using varchar(n) fields were supposed to be > space-efficient in a sense that it just used a extra 1 or 2 bytes up front at > the head of the record to identify the true length? It'

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

2017-10-28 Thread Ed Leafe
On Oct 27, 2017, at 11:48 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > The OCD part of me wants to define the smallest type possible, whereas the > "let's set it and never worry about it" part of me says "just make everything > INT." It's not just the size of the column in the row s

Re: AW: FoxPro DevCon in Frankfurt

2017-10-28 Thread Ted Roche
On Sat, Oct 28, 2017 at 6:14 AM, Thierry Nivelet wrote: > Frank W Moore has released the latest version of LienWriter (several hundreds > users) with VFPA alias VFP10. > > Thierry Nivelet > http://foxincloud.com/ > Give your VFP app a second life in the cloud > Would it be this? http://www.fwmso

[NF] Varchar(4000) or varchar(max) (was INT vs MEDIUMINT vs SMALLINT vs TINYINT)

2017-10-28 Thread mbsoftwaresolutions
On 2017-10-28 07:17, Charlie-gm wrote: Whatever the case, please don't do something idiotic like declare "VARCHAR(4000)" for fields that will never have more than 20 characters. That's the most common, stupid, wasteful, inefficient mistake I've seen in so-called "enterprise" apps. Hi Charlie,

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

2017-10-28 Thread mbsoftwaresolutions
On 2017-10-28 02:05, Wollenhaupt, Christof wrote: That is largely dependent on the engine you use in MariaDB. Have you settled on one? Was just going to use MyISAM for non-transactional tables and InnoDB for those where I need transactions (end-data tables). Sometimes I'll use a COMPRESSED

Re: AW: FoxPro DevCon in Frankfurt

2017-10-28 Thread Charlie-gm
On 10/28/2017 6:14 AM, Thierry Nivelet wrote: Frank W Moore has released the latest version of LienWriter (several hundreds users) with VFPA alias VFP10. How does the VFP10 thing work? Are you still using the usual VFP IDE - and then when you deploy you use their .exe in place of the usual V

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

2017-10-28 Thread Charlie-gm
On 10/28/2017 12:48 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: The OCD part of me wants to define the smallest type possible, whereas the "let's set it and never worry about it" part of me says "just make everything INT." I like to leave wiggle room generally. But really, using 2

Re: AW: FoxPro DevCon in Frankfurt

2017-10-28 Thread Thierry Nivelet
Frank W Moore has released the latest version of LienWriter (several hundreds users) with VFPA alias VFP10. Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud > Le 28 oct. 2017 à 08:51, AndyHC a écrit : > > I have been vaguely aware of VFP10 / VFP Compiler sin