Coverage profiler

VFP9SP2 on Win7Pro PC I want to see how long it's taking some code to run. Beyond self-created start/stop variables, I thought "why not use the coverage profiler?" MANY years ago, I recall there was some sort of alternative cool tool to the native Coverage Profiler but I can't recall the

Re: [NF] Two Versions of Word

On 2018-07-04 16:25, Charles Hart Enzer, M.D. wrote: Does the current Office better protect from hackers than does WORD 2003? I would think every newer version from M$ (or any vendor for that matter) would protect the consumer better than the older versions?

Re: Nothing like a cryptic error to start the work week!

On 2018-06-25 11:41, Fernando D. Bozzo wrote: You may convert frmEditJob.scx to text with FoxBin2Prg and search there. Because the error says "ALIAS IS NO FOUND" you should look closely at all data statements, like "SELECT " or "." and macros/vars too, in the case you don't use real Alias

Re: AW: Nothing like a cryptic error to start the work week! (SOLVED!!)

Turned out to be an old alias on a few edit boxes in the form. Once changed to the correct alias, it worked fine. What's odd is that the errant alias was no longer in use, so I wonder why it didn't throw an intelligent error. The error message appeared to be referencing something else in

Re: Nothing like a cryptic error to start the work week!

On 2018-06-25 10:58, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2, Win7Pro, MySQL backend Screenshot: https://www.screencast.com/t/QKA2etzLnW I've searched frmEditJob.scx in the Code References for any text of IMG and it found nothing. Ugh. Now how to track down this new

Nothing like a cryptic error to start the work week!

VFP9SP2, Win7Pro, MySQL backend Screenshot: https://www.screencast.com/t/QKA2etzLnW I've searched frmEditJob.scx in the Code References for any text of IMG and it found nothing. Ugh. Now how to track down this new mystery? ___ Post Messages to:

Re: [NF] Cloud discovery meetings held this week

On 2018-06-21 11:21, Ted Roche wrote: -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 21, 2018 9:20 AM To: profoxt...@leafe.com Subject: [NF] Cloud discovery meetings held this week Will the executives be

Re: Database design

On 2018-06-19 09:41, Stephen Russell wrote: Oh I get it. The performance was personal performance. Now you don't have to test all over the place anymore. Just test to make sure it didn't break anywhere!! This post was more a question of theory, not of an existing issue with this app.

Re: Database design

On 2018-06-18 12:01, Stephen Russell wrote: What performance changes are you seeing? Data speed increased to the app, faster save(s) or edits are now all accepted and correct? Was all data on your remote mySQL data correct? Were you experiencing a longer time to populate FKeys in secondary

Re: Database design

On 2018-06-17 23:43, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-06-16 13:31, Charlie-gm wrote: On 6/15/2018 12:30 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Some years ago I had created a solution where I had split the main data table into 5 separate tables, each

Re: Database design

On 2018-06-16 13:31, Charlie-gm wrote: On 6/15/2018 12:30 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Some years ago I had created a solution where I had split the main data table into 5 separate tables, each with a 1:1 relationship.  I kept the commonly held fields in the table,

Re: [NF] Best Practices for collaborative sharing of information

On 2018-06-15 13:00, Malcolm Greene wrote: Mike, Are you just focused on collaboration or are you looking to build a sustainable knowledgebase? We looked at Chatter - its a cool tool - but went the route of a wiki because our goal was not only to collaborate, but to build, as an internal

Re: [NF] Best Practices for collaborative sharing of information

On 2018-05-29 12:23, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: The Corporate gig has tasked me with looking into a way for several similar organizations to communicate and share with each other things are the related to the success of all of them; a collaborative sharing of ideas, best

Database design

(VFP9SP2 app with MySQL backend) Some years ago I had created a solution where I had split the main data table into 5 separate tables, each with a 1:1 relationship. I kept the commonly held fields in the table, and moved others off like so: - Main Job table - Job Address table (job site

Re: [NF] you know it comming

On 2018-06-05 17:44, Ted Roche wrote: Or maybe Embrace, Enhance, Extend, Extinguish expired with Ballmer and it's a new day. Thank goodness the Ballmer days are gone. Did not like M$ under him as much. Today's leader seems more open minded, willing to play with others, and not a predatory

Re: [NF] you know it comming

On 2018-06-05 09:48, Stephen Russell wrote: M$ buys GitHub. https://www.youtube.com/watch?v=Vhh_GeBPOhs Dance Monkeyboy, Dance! "Give it up for me!" What an ass. https://news.softpedia.com/news/microsoft-planning-to-buy-github-521377.shtml ___

Re: [NF] Best Practices for collaborative sharing of information

On 2018-05-29 12:39, Ed Leafe wrote: On May 29, 2018, at 11:23 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: The Corporate gig has tasked me with looking into a way for several similar organizations to communicate and share with each other things are the related to the success of

Re: [NF] JiveSoftware.com

On 2018-06-04 11:45, Stephen Russell wrote: That looked pretty good. On Mon, Jun 4, 2018 at 10:37 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: I heard an ad for JiveSoftware.com over the weekend. Anyone have experience with that? Well it better be awesome for that pricea

Re: Sad news

On 2018-06-04 13:05, Ed Leafe wrote: is over, but in other ways, it must be a relief. Yep...peace at last. No more fighting. RIP, John. Thanks for all your help with the Fox! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

[NF] JiveSoftware.com

I heard an ad for JiveSoftware.com over the weekend. Anyone have experience with that? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Sad news

On 2018-06-04 05:09, Dave Crozier wrote: Ladies and Gentlemen, Over the weekend I sadly heard about the sad passing of John Koziol with cancer last Thursday after a four year battle with Cancer. Although I never met him I had lots of dealings with him in the initial VFP7 days whilst he was

Re: [NF] Best Practices for collaborative sharing of information

Not a good option for this nationally shared information vehicle. On 2018-06-02 05:38, Man-wai Chang wrote: A simple IMAP server should do, one that supports shared mailboxes. Basically, you can run a BBS or web-forum with it. On Tue, May 29, 2018 at 9:23 AM, wrote: The Corporate gig has

Re: [NF] Best Practices for collaborative sharing of information

My goodness, there IS a product called SugarCRM!! So which is it, Dave? :-) On 2018-06-01 10:46, Eric Selje wrote: Or maybe SugarCRM? Sugar is sweet. On Thu, May 31, 2018 at 6:12 PM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: On 2018-05-30 11:05, Dave Crozier wrote: Mike,

Re: [NF] Best Practices for collaborative sharing of information

On 2018-05-30 11:05, Dave Crozier wrote: Mike, SweetCRM is a particularly good open source CRM that is constantly evolving with loads of free "addins". Paid version is cloud hosted but the open source version you can host on either your own or an external ISP's server Dave Dave Crozier

Re: [NF] Best Practices for collaborative sharing of information

On 2018-05-30 01:20, Fernando D. Bozzo wrote: I think that a CMS could be an option Any you would recommend in particular? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Re: [NF] Best Practices for collaborative sharing of information

And nothing in our current solution stack in Microsoft. Java shop running JSP pages on Linux servers and Oracle database. On 2018-05-29 17:47, Eric Selje wrote: Justified. On Tue, May 29, 2018 at 3:28 PM, Ted Roche wrote: On Tue, May 29, 2018 at 3:40 PM, Eric Selje wrote: > As many of

Re: [NF] Best Practices for collaborative sharing of information

On 2018-05-29 13:18, Ed Leafe wrote: On May 29, 2018, at 12:15 PM, Fred Taylor wrote: Another +1 for Slack. Slack works well for synchronous communication, not as well for async, and is worthless as a document store. This need is for information sharing on a permanent level, with thread

Terminal server option (was Re: [NF] Let the meetings BEGIN)

On 2018-05-25 11:46, Man-wai Chang wrote: When you go Cloud, You have to handle the worst-case scenario when a network partition happens. And what should you do when the network resumes operation after a network partition? How do you sync data between local apps and the cloud apps? It's way too

Re: [NF] Best Practices for collaborative sharing of information

On 2018-05-29 12:39, Ed Leafe wrote: On May 29, 2018, at 11:23 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: The Corporate gig has tasked me with looking into a way for several similar organizations to communicate and share with each other things are the related to the success of

Re: Fun with date calculations in VFP

On 2018-05-21 15:37, Vince Teachout wrote: On 05/20/18 3:31 PM, Ted Roche wrote: On Sun, May 20, 2018 at 1:39 PM, Gene Wirchenko wrote: thedate=date(,12,31) && Handle this extreme case. And that, kids, is why we call it "The Y10K crisis..." I looking forward to all the

[NF] Best Practices for collaborative sharing of information

The Corporate gig has tasked me with looking into a way for several similar organizations to communicate and share with each other things are the related to the success of all of them; a collaborative sharing of ideas, best practices, information, etc. to help the (healthcare) product as a

Re: [ADMIN] Testing post to ProFox

On 2018-05-18 13:14, Ed Leafe wrote: On May 18, 2018, at 7:37 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've sent 2 emails in the past week that never showed up (and aren't in the archives). Testing to see if this gets through. Nothing in the spam filter, so I'm not sure why

Re: Fun with date calculations in VFP

On 2018-05-16 18:02, Ted Roche wrote: LastDayOfMonth() or LDOM back in my 8.3 days, was always a popular request: http://fox.wikis.com/wc.dll?Wiki~FindingTheLastDayOfTheMonth~VB Ed Leafe had shared a ton of date functions for VFP years ago. Here's what I have in my framework from Ed:

Re: String help (was Re: [ADMIN] Testing post to ProFox)

On 2018-05-18 09:00, Frank Cazabon wrote: m.x="123-456-7890" CHRTRAN(m.x, "0123456789-", "") will leave any invalid characters behind Frank. Thanks, Frank! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

String help (was Re: [ADMIN] Testing post to ProFox)

On 2018-05-18 08:37, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Well, other post still not making it, so I'll add the simple request here since this went through: FieldValue1 = '123-456-7890' I want to scan for records where the field contains something OTHER than digits 0-9 and a

Re: [ADMIN] Testing post to ProFox

On 2018-05-18 08:37, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've sent 2 emails in the past week that never showed up (and aren't in the archives). Testing to see if this gets through. Winner ___ Post Messages to: ProFox@leafe.com

[ADMIN] Testing post to ProFox

I've sent 2 emails in the past week that never showed up (and aren't in the archives). Testing to see if this gets through. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version

VFP runtimes link

https://github.com/VFPX/VFPRuntimeInstallers Just FYI for the ProFox archives. Thanks to wOOdy for emailing this to my corporate account. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

Re: "Cannot load 32-bit DDL wwipstuff.dll"

On 2018-04-18 14:32, Ted Roche wrote: We moved the DLL to the same folder as the EXE and it's working now. Another example where putting it in the same folder was better advice than the official M$ way. lol ___ Post Messages to: ProFox@leafe.com

Re: Numeric(x,0) vs Integer field type in VFP tables

On 2018-04-06 13:28, Gene Wirchenko wrote: 3) Some other software might be expecting only values of the particular size and if you do not make sure that the values are that way, interesting things might happen. For example, N(4) is just right for four-digit numbers and that other program

Re: Numeric(x,0) vs Integer field type in VFP tables

On 2018-04-05 13:19, Gene Wirchenko wrote: At 12:43 2018-04-04, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9 I don't see why folks would use Numeric(X,0) where X > 4 instead of an Integer field. Can you tell me why? I'm guessing it's leftover legacy design? There are a

Re: Numeric(x,0) vs Integer field type in VFP tables

On 2018-04-05 01:20, Fernando D. Bozzo wrote: Yes, in this case INT is much better because it only need 4 bytes on disk and have direct hex interpretation, while the number occupies 10 bytes and need digit by digit calculation. Being both data types related, I thing that it's a secure

Re: Numeric(x,0) vs Integer field type in VFP tables

On 2018-04-04 16:53, Fernando D. Bozzo wrote: Not counting legacy reasons for already available systems, I think that this is because many did not learn about the available data types and just stay with what they know, others because did think that are the same, and others because they don't

Numeric(x,0) vs Integer field type in VFP tables

VFP9 I don't see why folks would use Numeric(X,0) where X > 4 instead of an Integer field. Can you tell me why? I'm guessing it's leftover legacy design? tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] M$ teaches about AI (free)

On 2018-04-04 11:59, Fernando D. Bozzo wrote: I did take a look at it because they say it's free, but and at the end if the content index they say that you need an Azure account which is free only for the first month... so you have the exact time fir using Azure for this course only before

Re: Unexpected results from a group by clause

On 2018-03-29 23:00, Joe Yoder wrote: I have an SQL select statement that includes a group by clause to order the output for reporting. It gets its data from a table that potentially includes legitimate duplicate records. SELECT account, date, memo, paid_amoun; FROM QB; GROUP BY

Re: FoxPro/VB for Sale...

On 2018-03-29 13:59, Paul Hill wrote: VFP was dropped from Visual Studio years ago. The Community Edition is pretty nice, you can even use it to write commercial software. There is a limit of 5 users and company turnover IIRC. On 29 March 2018 at 14:41, Kurt at VR-FX

Wonder if this ransomware attack in Atlanta was involving any VFP files?

https://www.msn.com/en-us/news/us/city-of-atlanta-still-crippled-six-days-after-ransomware-attack/ar-BBKMJPY Makes you wonder, since government had a lot of Fox apps over the years (and maybe many still do). ___ Post Messages to: ProFox@leafe.com

Re: Error 108 on an INSERT INTO MyVFPTable

Hi Frank, Nope. Still a mystery. Rarely happens so not on the "urgent" list. --Mike On 2018-03-20 07:57, Frank Cazabon wrote: Mike, did you ever solve this? Frank. Frank Cazabon On 15/03/2018 08:32 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 app/Win10 Pro

Re: _VFP vs _SCREEN

On 2018-03-20 08:41, Ted Roche wrote: On Mon, Mar 19, 2018 at 4:21 PM, wrote: I was adding another "global" application attribute for a signal flag for later code to reference, and I realized I've always used the _SCREEN object. Would seem more

Silent/behind-the-scenes installation of MariaDB from VFP (or from Inno Setup)

I'm going to be distributing a free single user (localhost) version of one of my VFP9SP2 fat client apps, and I'd like to install MariaDB behind the scenes easily (meaning without me having to manually install it on every machine). Does anyone have experience with exactly or something like

Re: Testing tells the tale (SYS 3054) -- "BETWEEN(a, b, c)" equivalent to "a BETWEEN b and c"

On 2018-03-19 18:29, Bill Anderson wrote: Mike, I believe ALLTRIM()s in SQL doesn't "defeat" optimization, it's just that you can't have ragged (meaning, varying length) indexes in VFP. A tag on ALLTRIM(field) is padded out to the full length of the field. Bill Anderson Hi Bill! But it

Re: AW: _VFP vs _SCREEN

On 2018-03-19 17:37, Jürgen Wondzinski wrote: Think of _VFP as "the engine" and _SCREEN as the "visual representation". Don't fiddle with the engine! wOOdy Ah, good way to look at it. Stay away from the _VFP object! lol ___ Post Messages to:

_VFP vs _SCREEN

(I checked the ProFox archive but searching for _VFP _SCREEN (with underscore, with underscored escaped, and without underscore) did not turn up any matches or at least the ones applicable). I know we've discussed this somewhere in the past but could not find the reference.) I was adding

Re: Testing tells the tale (SYS 3054) -- "BETWEEN(a, b, c)" equivalent to "a BETWEEN b and c"

-Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Sunday, March 18, 2018 2:34 PM To: ProFox Subject: Testing tells the tale (SYS 3054) -- "BETWEEN(a,b,c)" equivalent to "a BETWEEN b and c"

Testing tells the tale (SYS 3054) -- "BETWEEN(a,b,c)" equivalent to "a BETWEEN b and c"

VFP9SP2 WestWind WebConnection App on WinServer 2012 I was looking at a notoriously slow query to see about optimizing it. Using SYS(3054,11,"cmemvar"), I was able to do so, but during my testing, I found that using MyDate BETWEEN Arg1 and Arg1 was the same optimization-wise as

Re: Error 108 on an INSERT INTO MyVFPTable

On 2018-03-15 21:15, Richard Kaye wrote: INSERT INTO has to be doing an implicit USE, don't you think? I can't tell if the table was open, and if not, your logic is reasonable, but if it WAS already open, ___ Post Messages to:

Error 108 on an INSERT INTO MyVFPTable

VFP9SP2 app/Win10 Pro workstation/Win2012 Server Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not

Re: Date / Date Time Picker Class

On 2018-03-09 12:06, Koen Piller wrote: Paul. the form Testlargecalender errors on line lcEval = m.lcLine + [.Top = ] + TRANSFORM((m.lnDateHeight * m.lnIndex) + 51) in cntCalendar, arrangeui method lcEval shows in my debugger "This.linDateH1.Top = 109,6667" trust you have enough info

Re: Date / Date Time Picker Class

On 2018-03-05 17:41, Richard Kaye wrote: I've been using this one for a bit. 100% pure VFP. http://sandstorm36.blogspot.com/2017/12/dtpickerx-december-2017-version.html/ Strange...tried it just now and got "Sorry, the page you were looking for in this blog does not exist. "

Re: Displaying Content on a TV

On 2018-02-21 12:31, Desmond Lloyd wrote: We want to display a list of orders on a TV. coming from a VFP based system. Thus far I have generated a report to PDF, then converting that to a JPEG and displaying that on the TV/ Very clumsy and we have not been able to automate... Would

Re: New Term: Zombie Language

On 2018-02-19 07:15, Alan Bourke wrote: On Mon, 19 Feb 2018, at 11:49 AM, Ted Roche wrote: On Sun, Feb 18, 2018 at 5:02 AM, Laurie Alvey wrote: > I guess FORTRAN & PASCAL would qualify. > The only differentiation I might make is whether there are implementations still

Re: Throwback Thursday clip

On 2018-02-15 10:29, Ted Roche wrote: And another Throwback Thursday: the keynote presentation from the FoxPro DevConnections 2000 in New Orleans. https://youtu.be/iWVh3tKY2JY Lots of good stuff presented at that show: http://fox.wikis.com/wc.dll?Wiki~DevCon2000 And there were pictures:

Re: [NF] Camtasia for producing demos with video and callouts on screen

On 2018-02-14 04:34, Alan Bourke wrote: Have a look at TinyTake as well maybe. Thanks. I'll have a look. Never heard of that one! Pricing is decent. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

[NF] Camtasia for producing demos with video and callouts on screen

Used to use Qarbon's ViewletBuilder years ago but that uses/used Flash so I stopped and then have been using TechSmith's SnagIt capture for the past couple years. SnagIt is great for recording live demos but it doesn't allow me to add on-screen annotations the demo like Qarbon's

Re: Throwback Thursday clip

On 2018-02-08 16:35, Ted Roche wrote: What is FoxPro? Why, It's Magic! https://www.youtube.com/watch?v=Ni5xemuNliw Cute! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version

Re: Doug Hennig presentation on using WW dotNetBridge tomorrow

On 2018-02-09 08:09, Ted Roche wrote: Base64 MIME Decode: FYI for anyone who likes to spend quality weekend time with a VFP guru…  Excellent...thank you! ___

Throwback Thursday clip

"This new product called FOXPRO": https://www.youtube.com/watch?v=EZqzJ6f3d7w ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Blue Circle / Hour Glass

On 2018-02-08 11:14, Richard Kaye wrote: I added a variant of this to my app procedure file a long time ago. -- rk ...with a custom MouseIcon file? ___ Post Messages to:

Re: Licensing strategy

On 2018-02-06 22:25, Carl Lindner wrote: Mike, Not sure about Stephen's tip. Unless you are charging big bucks per user. You would have to track - on a daily basis logged in users. Then, would have to show those days where usage was exceeded. You would have variable billing. Seems like

Re: Licensing strategy

On 2018-02-06 15:51, Stephen Russell wrote: I agree with you in a simultaneous user license of N users. You can then look at tracking days where user count exceeds agreement and you charge a tiny daily fee for that. Instead of locking someone out of working with it. That fee needs to be

Licensing strategy

If you were marketing a vertical app and pricing it per license, would you consider a license specific to the installed machine or keep track of users logged in and make sure the active user count doesn't go over the # of licenses the client purchased? My VFP9SP2 app uses the latter, and goes

Re: Weird error with VFP9SP2 (7423 build) using ReportBehavior 90; fixed when I switched to 80 mode

On 2018-01-31 15:52, Frank Cazabon wrote: This is a known bug when the user has their fonts set to greater than 100%. Set the shortcut for your app so that it doesn't use the Windows display setting. Can't remember what the setting is but it's a checkbox in the short cut properties. Or set

Weird error with VFP9SP2 (7423 build) using ReportBehavior 90; fixed when I switched to 80 mode

Had installed FabNet on a prospective client's computer and when previewing reports, for some reason, everything was enlarged and getting cut off on the righthand side. In one report, I got a report error (but not an error that would have triggered the bug reporting). I switched to 80 mode

Re: Rainer Becker's company + Macrosoft

On 2018-01-30 23:22, Bill Anderson wrote: First work with Microsoft, then work with Macrosoft. Hmmm Remember the Mike Rowe Soft dot com 12th grader who got sued by M$? lol https://en.wikipedia.org/wiki/Microsoft_vs._MikeRoweSoft ___ Post

Re: Declaring variable as "Empty" ???

On 2018-01-30 18:02, Fernando D. Bozzo wrote: A small error writing by heart, but EMPTY class has no AddProperty() method, so really is: AddProperty( loReg, "name", value) ... I've always just used ADDPROPERTY(object, field, value)...I've never used the .AddProperty of any legitimate

Re: Declaring variable as "Empty" ???

On 2018-01-30 15:12, Frank Cazabon wrote: I've seen it used as a lightweight class. http://fox.wikis.com/wc.dll?Wiki~EmptyClass Oh I've often used the Empty class as well; very useful. Just curious why the declaration was as such. Penchant for correctness I guess.

Declaring variable as "Empty" ???

Saw this today while looking for other stuff: https://www.screencast.com/t/PyvZvy53oZFu Never saw anyone declare a variable AS "Empty" before? I guess that's basically this: loMenuItem = CREATEOBJECT("Empty") (although you'd still have to write that code, of course, since no instantiation

Re: Rainer Becker's company + Macrosoft

On 2018-01-30 13:23, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Saw this on LinkedIn:

Re: Trashed class library

On 2018-01-29 18:51, Richard Kaye wrote: It's pretty new. And you can setup Git integration which leverages the FB2P stuff. Now THAT appeals to me! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Rainer Becker's company + Macrosoft

Saw this on LinkedIn:

Re: Trashed class library

On 2018-01-29 15:57, Richard Kaye wrote: Yes. I have not integrated into the PM as of yet. Someday... Maybe at the same time I get Doug Hennig's VFPX PM replacement going. I'll have to look into Doug's VFPX PM replacement tool. I can't recall reviewing it.

Re: Trashed class library

On 2018-01-29 11:31, Richard Kaye wrote: +1 to FoxBin2Prg. Are you using this, Richard? If so, in a ProjectHook.AfterBuild event or where? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: MariaDB

On 2018-01-25 18:44, Mike wrote: I would try using the MySQL ODBC 3.51 driver instead. That's what I've always used and I'm on my 5th version of MariaDB. Likewise...I'm using the old 3.51 and running it against MariaDB 10! ___ Post Messages to:

Re: MariaDB

On 2018-01-25 16:15, Chris Davis wrote: I guess just for ease when designing forms etc and having the view on the data environment , also interested in why it just doesn't work My table is called stock and I get the error saying root.stock doesn't exist! Sounds like it's not looking in your

Does the CDX file travel across the network for each time a field that can use an index is queried/updated/deleted/added? (was Re: Indexes on VFP tables--when do they get updated)

On 2018-01-25 13:51, Gene Wirchenko wrote: At 08:15 2018-01-25, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-01-24 18:39, Fernando D. Bozzo wrote: When the index is evaluated initially, VFP knows exactly what fields affect what index, so really just affected indexes are updated.

Re: Indexes on VFP tables--when do they get updated

On 2018-01-25 13:24, Kurt at VR-FX wrote: IN theory  - the same test should be viable - just see if the CDX Timestamp was updated! Yes, it would be, but my point is that the entire CDX would come over the line, if I understand correctly. The entire DBF doesn't come over the wire (network),

Re: Indexes on VFP tables--when do they get updated

On 2018-01-24 18:39, Fernando D. Bozzo wrote: When the index is evaluated initially, VFP knows exactly what fields affect what index, so really just affected indexes are updated. It's easy to test it. just make an old index (IDX) on two different fields: CREATE TABLE test (field1 C(10),

Re: Timers in VFP

On 2018-01-25 10:56, Dave Crozier wrote: I always used to find when developing comms software where VFP timers are used to poll the input ports that the best thing to do in the Timer Event is to immediately disable the timer. Yep...that's what I do too. First line in timer event turns it

Re: Indexes on VFP tables--when do they get updated

On 2018-01-24 15:21, Ted Roche wrote: First off, don't do that. REPLACE (or better, UPDATE) once. Especially in high network traffic situations, the amount of time it takes to assemble a field and value list to issue one: UPDATE TableName SET WHERE FilterCriteria saves an enormous amount of

Re: Indexes on VFP tables--when do they get updated

On 2018-01-24 15:19, Stephen Russell wrote: I expect the update of .cdx to be at the same time that the .dbf is done. 223 meg is a tiny index size and reducing it down to 1/4 probably didn't make anything faster, did it? Now an index of 20 gig that would probably be noticed if you brought

Re: Timers in VFP

On 2018-01-24 15:37, Stephen Russell wrote: I thought it was a CPU hog. Making the call to the system for the time 100,000 time in a single min. Well that's why you have to be smart about it, Stephen, and only call it every X minutes. In my case, anywhere between 5-15 minutes. Resources

Re: Indexes on VFP tables--when do they get updated

Thanks. In this app, they indexed EVERY field, and the table in question had a CDX size of 233 MB before I pruned it. Now it's down to 56 MB. On 2018-01-24 14:35, Alan Bourke wrote: Only the indexes that involve a 'touched' field. And even then it's just a small update. -- Alan Bourke

Re: Indexes on VFP tables--when do they get updated

On 2018-01-24 13:48, Kurt at VR-FX wrote: Mike, If I was to look at this from a totally Logical stand point - I would think the Indexes are ONLY update if you update a field in a record where that field is contained in one or more of the Indices. However, Why not do a simple test - and

Indexes on VFP tables--when do they get updated

Question for you legends of the Fox (data): Say Table1 has "X" number of indexes. Program code does something like the following: IF Condition1 THEN REPLACE Field1 with SomeValue in Table1 ENDIF IF Condition2 THEN REPLACE Field48 with Datetime() in Table1 ENDIF Are each of the "X"

Timers in VFP

I've got a timer in a very small "listener" app that checks a web service and changes data in the local database based on WS returned records. I vaguely recall somebody saying timers in VFP were bad (at some point). Was it a memory leak or something? Tapping into this list's vast years of

Re: Performance issues on virtual 2K12 server

On 2018-01-23 10:59, Ken Dibble wrote: Client moved from old virtual 2K3 server to newer 2K12 server. They use an IT vendor to manage all of their IT setup. They connect via Terminal Services if I understand correctly. Apparently this legacy VFP application is run from the server by all

Performance issues on virtual 2K12 server

Client moved from old virtual 2K3 server to newer 2K12 server. They use an IT vendor to manage all of their IT setup. They connect via Terminal Services if I understand correctly. Apparently this legacy VFP application is run from the server by all users. Performance is inconsistent, with

Re: Craig Boyd

On 2018-01-19 15:07, Alan Bourke wrote: The VFPStudio thing petered out more due to changes Microsoft were making in the dynamic language runtime. I think he's just very busy. "Busy" is a good place to be, usually! ___ Post Messages to:

Re: Craig Boyd

On 2018-01-19 04:33, Alan Bourke wrote: On Fri, 19 Jan 2018, at 8:34 AM, Dave Crozier wrote: Anyone know what Craig is up to these days. I needed to load some software of his and noticed his website has been completely re-designed but no new blog posts since 2010. I emailed a while back

<    1   2   3   4   5   6   7   8   9   10   >