Thanks for the info, Ajit!
Looks like I'll use XFRX to generate the PDFs. Since I already owned
QuickPDF, I was hoping to use it for creation without recreating the wheel.
On 3/9/2021 9:37 AM, Ajit Abraham wrote:
Hello Mike,
On 09/03/2021 17:13, MB Software Solutions, LLC wrote:
If
I don't think speed is a big deal for this task...having it complete the
PDF in 5 seconds is not going to be a deal killer. Imagine the clock
striking X o'clock firing off the PDF reports that are supposed to be
generated at that hour. Not a big deal if they complete at X:01, or
even X:04 for
, creating the various reports for various individual users, and
to access them, they go to their "My Reports" link on either the website
(this is a WWWC app) or the equivalent in their desktop application.
On 3/9/2021 12:45 AM, MB Software Solutions, LLC wrote:
Task: Create PDFs via
Task: Create PDFs via scheduled job calls of my Fox EXE for creating
"reports at certain times of day" for historical review for various
users to view for their own data.
I know XFRX creates PDFs easily (along with other outputs like Excel)
but I already have the QuickPDF tool in my arsenal fr
ProFoxTech: 182
==
Top 20 Contributors by Number of Non-OT Posts
|Posts Contributor |
1.8Richard Kaye
2.6 MB Software Solu
Ditto to using MariaDB. If you'd like me to send you code of how I
manage my connection handles, just email me a.t. mbabcock a.t.
mbsoftwaresolutions dt com.
Ever since I saw Bob Lee's presentation at WhilFest 2003 or 2004, I
switched to MySQL (then later MariaDB) and never looked back.
half Of MB Software
Solutions, LLC
Sent: Saturday, February 20, 2021 10:08 PM
To: profoxt...@leafe.com
Subject: XFRX support
Attn XFRX users,
I've emailed XFRX and replied directly to Martina at eq...@eqeus.com and
supp...@eqeus.com but gotten no response regarding this question:
Hi M
Attn XFRX users,
I've emailed XFRX and replied directly to Martina at eq...@eqeus.com and
supp...@eqeus.com but gotten no response regarding this question:
Hi Martina and team,
I did not get a response from you on this. *Does the XFRX Private
Cloud solution exist? *I have a client wh
learn.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Tuesday, February 9, 2021 3:50 PM
To: profoxt...@leafe.com
Subject: [NF} Question for those Americans selling their software to those
outside the USA
I've got a Canadian company looking at
I've got a Canadian company looking at FabNet (my flagship estimating
software). For those of you who have sold to Canadians in the past, is
there anything special I have to do with respect to the sale? I'm going
to ask my accountant too but figured I'd ask those around the Fox
water-cooler h
Well, I got notice today that I'm done with my current Corporate gig as
of 3/1. And I learned my Uncle Bob passed away last night just before
midnight. (I wasn't close to him but he's still family.)
Not a great start to February!
Since losing my VFP job in early 2017, I've been playing the "
Screenshot: https://www.screencast.com/t/rfxtn8NOjxd
lol
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.co
I knowwhat a windbag. That f*cker gets the top spot nearly every
year. Ugh. :D
On 1/8/2021 7:09 AM, Alan Bourke wrote:
On Tue, 5 Jan 2021, at 1:54 AM, Srikanth Bhandari wrote:
Wow!
That looks like a competitive challenge scoreboard 😄
Damn you, MB Software Solutions, LLC! *shakes
butor |
1. 155 MB Software Solutions, LLC
2. 87Alan Bourke
3. 76Richard Kaye
4. 60Tracy Pearson
5. 55Eric Selje
6. 55Stephen Russell
7. 50Paul Newton
8. 50Ted Roche
9. 38Ed Leafe
10.
ng :)
The "correct" value would be 1+4 = 5 or a plain 0
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox Im Auftrag von MB Software Solutions, LLC
Gesendet: Dienstag, 15. Dezember 2020 19:00
An: ProFox Email List
Betreff: Error 108 - File is in use by another user on INSER
On 12/15/2020 12:59 PM, MB Software Solutions, LLC wrote:
VFP9SP2 - Citrix/VMWare server, Win10 desktop image on client
My error handling tripped on this simple line:
INSERT INTO broker!doclinks
(ifileid,idoctypeid,crange) VALUES
(thisform.oFile.iid,liDocTypeID
VFP9SP2 - Citrix/VMWare server, Win10 desktop image on client
My error handling tripped on this simple line:
INSERT INTO broker!doclinks
(ifileid,idoctypeid,crange) VALUES
(thisform.oFile.iid,liDocTypeID,ALLTRIM(loObj.txtRange.value))
VFP Help says this about Error 10
r SET DEFAULT and SET PATH?
--
rk
-Original Message-----
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Wednesday, December 9, 2020 12:09 PM
To: profoxt...@leafe.com
Subject: Re: SCX form included in EXE is not found on DO FORM line
Can we agree though that if a SCX form is included in
ginal Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Wednesday, December 9, 2020 9:51 AM
To: profoxt...@leafe.com
Subject: Re: SCX form included in EXE is not found on DO FORM line
YeahwOOdy posited that too. I'm guessing that's the cause...but weird th
your
fun...
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Wednesday, December 9, 2020 9:17 AM
To: profoxt...@leafe.com
Subject: Re: SCX form included in EXE is not found on DO FORM line
Hi Srikanth,
I agree with you on better project managem
ile: +1 669 292 9849 / +91 99625 42134 / +91 99001 39393
Email: consult...@srikanthbhandari.ind.in / srikanth.bhanda...@gmail.com
Web: srikanthbhandari.ind.in
On Tue, Dec 8, 2020 at 1:17 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
Oh sorry, Frank. Let
Yes. EXE is created in the default location, same as the Project files.
On 12/8/2020 4:38 PM, Frank Cazabon wrote:
But when you compile the exe, does that get created in the same place as the
pjx/t?
On 8 December 2020 17:17:07 GMT-04:00, "MB Software Solutions, LLC"
wrote:
Oh so
below you have confirmed that point #5 is correct that it was
built in the same folder as the PJX.
Which is it?
Frank.
Frank Cazabon
On 08/12/2020 3:07 pm, MB Software Solutions, LLC wrote:
Hi Frank,
Yeah...pretty much right. Take 43 seconds and see what I mean:
43 second demo showing th
nd it no matter what.
On 12/7/2020 2:34 PM, Richard Kaye wrote:
Smells like a PATH issue in your dev environment to me.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB
Software Solutions, LLC
Sent: Monday, December 7, 2020 2:01 PM
To: profoxt...@leafe.com
Subject: Re: SCX f
020 1:03 pm, MB Software Solutions, LLC wrote:
On 12/8/2020 9:22 AM, Richard Kaye wrote:
A fine question. 😊
I didn't watch the movie. Are you putting a path in on your DO FORM
call? Do you have a back door where you can see the runtime
environment settings? I would think if you want VFP t
On 12/8/2020 9:22 AM, Richard Kaye wrote:
A fine question. 😊
I didn't watch the movie. Are you putting a path in on your DO FORM call? Do
you have a back door where you can see the runtime environment settings? I
would think if you want VFP to walk its path to find the form in the EXE, then
y
al Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Monday, December 7, 2020 2:01 PM
To: profoxt...@leafe.com
Subject: Re: SCX form included in EXE is not found on DO FORM line
Hi Tracy,
Those wouldn't apply to me here because this is all done on my Dev machine (d
f Of Richard Kaye
Sent: Monday, December 07, 2020 9:38 AM
To: profoxt...@leafe.com
Subject: RE: SCX form included in EXE is not found on DO FORM line
Is there a SET PATH in your app config?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Monda
when compiling the EXE you are not saving tot he project folder? Always
(!) save your exe to the project-root folder.
Next idea: When calling the form, use the relative pathing to that form: i.e.
DO FORM forms\myform.scx
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox Im Auftrag von MB Sof
weirdness?
On 12/6/2020 12:00 PM, Tracy Pearson wrote:
Can you check what SET("CLASSLIB") is set to, and SET("LIBRARY")?
What is the stack, are things still running in the complied app?
Tracy
On December 6, 2020 11:30:28 AM EST, "MB Software Solutions, LLC"
wrote:
Hi
renaming the form to something else (like abc.scx) and then call
the renamed form.
Also, just verify in the project properties that this file is indeed
included.
(I know that you will see a icon in front of the file if it is
excluded - but still..)
Ajit
On 06/12/2020 06:31, MB Software
VFP9SP2 - Win 7 Pro
43 second demo showing the problem: https://www.screencast.com/t/ZjyWYqFI
The SCX form is included in the EXE. I'm running the EXE. DO FORM
errors saying that the form is not found. Makes no sense to
me. Now the app (a legacy app that I inherited which is very dirty)
c
Weird that it won't cite the specific area/line for you. (That is what
you're saying, right?)
On 11/12/2020 8:33 AM, Richard Kaye wrote:
H... Maybe a missing EXTERNAL ref in something?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Paul Newton
Sent: Thursday, November
Hi Charles,
I don't think M$ gives any of it away for free, even older versions of
their software?? Oh wait...they do give away some DotNet Studio
versions, don't they? Sorry...I know that doesn't help you with the Fox
need.
Hope the others tips help.
--Mike
On 11/6/2020 10:46 AM, Charl
LOLsorry, Charles, but I don't think it's free out there anywhere.
The next question is just as interesting though: where to get it
I'm guessing you could still get it from a MSDN subscription of some
kind. Years ago they have the very cheap ISV program, iirc.
Good luck!
--Mike
O
And this project is one of those passed through the years and isn't
something easily refactored without worries you break something
elsewhere unknown.
On 11/3/2020 1:41 PM, Stephen Russell wrote:
I hope you are the winner.
On Mon, Nov 2, 2020 at 6:25 PM MB Software Solutions
I've got a client who's main data table for their orders is over 2300
wide for record length.
Anybody seen any wider in their travels?
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Post
_NAME(schema_id), [Tables].name;
You never have to count the table rows itself. I wasn't going to show this
thinking that it wasn't viable in VFP.
On Sat, Oct 24, 2020 at 6:34 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
Hi Stephen,
Your r
This thread reminds me...wasn't there a way to specify your custom file
extension rather than the native VFP ones? Wondered if anyone ever did
that (to get away from the "ew it's FoxPro!" stigma)???
On 10/26/2020 3:51 PM, Rafael Copquin wrote:
Last week I wrote about this old VFP5 app that I
Time to use the "good" laptop. :D
On 10/26/2020 2:52 PM, Richard Kaye wrote:
Having the legendary Dave Crozier at the event is a high point for me. And
maybe Mike Babcock can get the video thing worked out for tomorrow. 😊
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Eric
Thanks, wOOdyI failed to make that clear. ;-)
On 10/26/2020 4:05 AM, Jürgen Wondzinski wrote:
You never have to count the table rows itself
But but... wouldn't this only be relevant if you just want the raw
RecordCount?
As soon as you would do a COUNT FOR (or COUNT WHERE for you SQL
VFP9SP2 using DBC tables.
The curWorkingGroup cursor had just ONE record in it. The
Carriers_To_Process table (PK = IID field) has tens of thousands. The
idea is that I'm just processing small sections at a time from
Carriers_To_Process. Rather than update the one or two records in the
curW
ze of the
table and index is a mere 364 gigs today.
On Fri, Oct 23, 2020 at 2:24 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
The WHERE clause was something to count but I don't think it was
optimizable because no index based on it. (Vague reco
Von: ProFox Im Auftrag von MB Software Solutions, LLC
Gesendet: Donnerstag, 22. Oktober 2020 21:24
An: ProFox Email List
Betreff: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works
with no issue. Why?
VFP9SP3
Why would a COUNT FOR hang ("Attempting to lock") wherea
e SQL engine I'm out of guesses. I bet Christof (or Chen) could explain it...
😊
I still don't understand why it's attempting to get a row lock. What about SET
EXCLUSIVE?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Friday, Octo
ike SET EXCLUSIVE and SET MULTILOCKS, my
first guess is COUNT FOR actually moves the record pointer through every row
in the table, Whereas SELECT COUNT() is reading the header.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Thursday, October 22,
aside the environment stuff like SET EXCLUSIVE and SET MULTILOCKS, my
first guess is COUNT FOR actually moves the record pointer through every row
in the table, Whereas SELECT COUNT() is reading the header.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions
VFP9SP3
Why would a COUNT FOR hang ("Attempting to lock") whereas my easy
workaround is SELECT COUNT(*) FROM SomeCursor WHERE <> ??
tia,
--Mike
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
__
I'm in now...thanks!
On 10/15/2020 11:26 AM, Frank Cazabon wrote:
Have you registered Andy logged in on hopin?
On 15 October 2020 11:18:38 GMT-04:00, "MB Software Solutions, LLC"
wrote:
Aw manWTF am I doing wrong?
On 10/15/2020 11:17 AM, Frank Cazabon wrote:
Nope. T
Aw manWTF am I doing wrong?
On 10/15/2020 11:17 AM, Frank Cazabon wrote:
Nope. The welcome just finished and waiting for the first session to begin at
half past the hour.
On 15 October 2020 11:15:50 GMT-04:00, "MB Software Solutions, LLC"
wrote:
Anybody else having trouble v
Anybody else having trouble viewing the webinar?
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/l
On 10/5/2020 2:30 PM, Charlie wrote:
Or, create additional tables, 1 memo field each (assuming your 8 memo
fields hold roughly equivalent amounts of data). Then link them back
to the main table - aka main tables primary key. Of course, this would
impact your data queries when pulling data. An
Nice! They're looking to get off the M$ wheel eventually?
On 9/28/2020 12:46 PM, Stephen Russell wrote:
My employer is looking to do more in python code if applicable.
I accept that as a challenge.
On Mon, Sep 28, 2020 at 11:17 AM Ed Leafe wrote:
On Sep 28, 2020, at 10:14, Stephen Russell
-- Original Message --
From: "Alan Bourke"
To: profoxt...@leafe.com
Subject: Re: VFP Apps/DBFs with AMD Processor
Date: Thu, 17 Sep 2020 07:50:26 +0100
What's important is whether VFP runs on a given version of Windows.
This is a single-threaded, 32-bit Windows executable and a
I haven't touched UT in literally 2 decades. I got my value out of
ProFox for All Things FoxPro for free (vs. the paid model Michel
Fournier used).
On 9/11/2020 8:46 AM, Jean Laeremans wrote:
Yes
Op vr 11 sep. 2020 14:42 schreef MB Software Solutions, LLC <
mbsoftwa
Or I could just copy the Server EXE to the client and call it from there
with its own customized INI settingsproblem would be that if it
changes, the Client workstation would need the update. Solved by a
Loader.exe I guess! ;-)
On 9/10/2020 7:51 PM, MB Software Solutions, LLC wrote
healthy,
Koen
Op do 10 sep. 2020 om 22:06 schreef MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com>:
VFP9SP2 Win10 clients, Win 2K12R2 Server
If MyClientApp.exe on the client creates an instance of a class from a
VFP EXE on the Server, and that MyServer.Exe has cod
----
Von: ProFox Im Auftrag von MB Software Solutions, LLC
Gesendet: Donnerstag, 10. September 2020 22:06
An: ProFox Email List
Betreff: VFP application on client invoking class from EXE on server
VFP9SP2 Win10 clients, Win 2K12R2 Server
If MyClientApp.exe on the client creates an instance of a class
VFP9SP2 Win10 clients, Win 2K12R2 Server
If MyClientApp.exe on the client creates an instance of a class from a
VFP EXE on the Server, and that MyServer.Exe has code that reads
configuration values from an INI file there on the server, I'm wondering
if it will function properly. I don't have
Did you try the magic jelly bean finder (or something named like that)?
On 9/4/2020 2:00 PM, Paul Newton wrote:
Hi all
I have lost the product key that I was sent when I purchased this software
(which was a special price for employees of the company I work for). Any
suggestions (none of the
0 12:44 PM, Jürgen Wondzinski wrote:
Ouch. Some old memories :) Glad to be indirectly helping!
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox Im Auftrag von MB Software Solutions, LLC
Gesendet: Freitag, 31. Juli 2020 23:43
An: profox@leafe.com
Betreff: Re: VFP9SP2 Error 108: File is in use by an
On 8/2/2020 11:45 AM, Ted Roche wrote:
This is a classic queue pattern: Make a task list of the items to be
processed (and perhaps breaking up multiple tasks for each item), and run
multiple workers against the list, updating the status as they go. As
Christof says, ultimately you have to LOCK, U
On Sat, Aug 1, 2020 at 6:07 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
I've got a regular process that runs, basically using key information to
grab data from an API and then update the local VFP database. There are
maybe 64000 records to p
ou to implement Codereference to find
the time consuming bottle-neck.
Instead of scan..endscan you may also try to make use of the SQL Update()
function, this should be faster.
Koen
Op za 1 aug. 2020 om 19:07 schreef MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com>:
I
I've got a regular process that runs, basically using key information to
grab data from an API and then update the local VFP database. There are
maybe 64000 records to process, and each record to update through this
process takes about a second, so to process this group would take over
17 hour
ad.cfm?qid=686993
On 31 July 2020 16:00:32 GMT-04:00, "MB Software Solutions, LLC"
wrote:
Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other
application had that program/table open, and all usage is SHARED (set
exclusive is OFF).
Anybody else ever get an Error
Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other
application had that program/table open, and all usage is SHARED (set
exclusive is OFF).
Anybody else ever get an Error 108 on a simple INSERT where there's no
exclusive use???
--
This email has been checked for viruse
To be honest, I never liked DotNet lambda expressions. This line makes
my eyes roll.
On 7/30/2020 2:17 PM, Stephen Russell wrote:
If you are filtering you should consider lamda expressions
(x => x.ColumnName != 0).ToArray()
--
This email has been checked for viruses by Avast antivirus softw
I asked because of the DO WHILE !EOF and SKIP in the sample code below.
On 7/29/2020 12:06 PM, Matt Slay wrote:
Yes, Scan/EndScan now supported in X#.
- Matt Slay
On 2020-07-29 11:00 AM, MB Software Solutions, LLC wrote:
No SCAN/ENDSCAN support yet?
On 7/29/2020 11:56 AM, Johan Nel wrote
This reminds me of the love of simplicity that is my VFP.
:-)
On 7/30/2020 3:46 AM, Alan Bourke wrote:
doing this will make the distribution much larger
though - a full runtime installation adds roughly 80-90megs to the
application (about 30-35megs in an installer package).
For .NET Core 3.x y
No SCAN/ENDSCAN support yet?
On 7/29/2020 11:56 AM, Johan Nel wrote:
Hi all VFPers,
Well have not posted much lately about X# here due to some other
issues I have to attend to, but good progress are made with support
for the VFP dialect.
As per the message regarding .NET Core, I would also
Analysis. I
pull AD data to determine who are the managers at that plant for every
truckload we ship.
On Thu, Jul 23, 2020 at 9:27 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
On 7/23/2020 8:07 PM, Stephen Russell wrote:
Pretty much for anything tha
I always thought stored procedures were faster??
On 7/24/2020 8:43 AM, Richard Kaye wrote:
There are performance implications to using SPs, at least in MSSQL.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Thursday, July 23, 2020 10:27 PM
To
On 7/23/2020 8:07 PM, Stephen Russell wrote:
Pretty much for anything that is repetitive in nature. All apps yes. I
have the instances set to not allow homemade sql except for some of our new
stuff in R, or my certificate report that passes SQL to include all of the
Lot Numbers needed. It is o
.
All of them need to be tested.
On Thu, Jul 23, 2020 at 12:18 PM Garrett Fitzgerald
wrote:
I still have trouble conceptualizing how to write unit tests for data
access.
On Thu, Jul 23, 2020, 11:37 MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
I have d
On 7/23/2020 2:12 PM, Christof Wollenhaupt wrote:
For projects that use a more object oriented approach I use foxmock to
simulate data. Most times what I really need isn't the actual data
access, because I know that these classes work, rather I have to test
the code that accesses data. foxmock
st. You create your functionality in TESTS and then use those
functions in a UI.
On Tue, Jul 21, 2020 at 5:53 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
I would wager that less than 5% of devs (in VFP anyway) have unit tests
in their solution setup.
LMAO!!! "Tabs vs. spaces!"
On 7/21/2020 12:19 PM, Bill Anderson wrote:
As a developer once (dramatically, suspiciously looks left, looks right) I
tried using tabs as an indentation...
Please forgive me
Bill Anderson
On Tue, Jul 21, 2020 at 6:15 AM Eric Selje wrote:
Forgive me father,
I would wager that less than 5% of devs (in VFP anyway) have unit tests
in their solution setup.
On 7/21/2020 10:04 AM, Johan Nel wrote:
Ah my child, I have to confess I have never in my complete development
career had a plan or unit test done...
On 2020/07/21 15:13, Eric Selje wrote:
Forgiv
--
From: "MB Software Solutions, LLC"
To: profoxt...@leafe.com
Subject: Re: NF Windows 11 ?
Date: Mon, 20 Jul 2020 17:14:35 -0400
Yeah, I call BS on this one.
On 7/20/2020 3:14 PM, Tracy Pearson wrote:
On the disclaimer page of that site: "The website has no affiliation to
Microso
M$ should go after these folks. That's very misleading.
Can I blame Gartner?
On 7/20/2020 3:25 PM, Richard A Mertl, CPA, CA wrote:
I don't think this is Microsoft.
-Original Message-
From: ProfoxTech On Behalf Of Philip
Borkholder
Sent: Monday, July 20, 2020 2:48 PM
To: profoxt...
Yeah, I call BS on this one.
On 7/20/2020 3:14 PM, Tracy Pearson wrote:
On the disclaimer page of that site: "The website has no affiliation to
Microsoft company."
I haven't heard anything about there being a Windows 11.
Looked like a advertising website.
-Original Message-
From: Profo
ld into my ancient application.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Monday, July 20, 2020 10:58 AM
To: profoxt...@leafe.com
Subject: We are only as good as we are informed!
Had a client complain about issues in their system that happened o
Had a client complain about issues in their system that happened over a
month ago.
WHERE'S THE NOTIFICATION? Yes, I can stop the bleeding, but if you're
not communicating issues to me, I can't be expected to know everything
that's going on.
There's that old saying: "The problem is communica
On 7/16/2020 4:51 PM, Bill Anderson wrote:
I have to say that Gartner *STILL* leaves a bad taste in my mouth,
these 20+ years later. (For those unaware, Gartner could be attributed
with shooting the arrow that killed Visual FoxPro.) <<
Gartner shot it but chances are that MSFT manufactured th
Got this from someone trying to connect with me on LinkedIn today:
Hi Michael,
I’m reaching out to better understand if MB Software Solutionswould
be a fit to work with our analyst community for thought leadership
and strategic insight.
I am spearheading a new Gartner channel tha
SQLYog is my go-to beyond HeidiSQL. Admittedly, I just use SQLYog for
schema comparison and automatic update SQL generation to get things in sync.
Curious -- why dump SQL Server? Costs???
On 7/10/2020 11:06 AM, Vince Teachout wrote:
Hi all,
I may have an opportunity to move our MSSQL backe
On 7/2/2020 7:44 AM, Ed Leafe wrote:
On Jul 1, 2020, at 17:48, Ed Leafe wrote:
Looks like an update to the Elasticsearch backend. Let me investigate.
Turned out to be a bit of corruption in the index. Should be working fine now!
And thanks for letting me know!
-- Ed Leafe
What's the datab
-wai Chang wrote:
Maybe your server should reindex all DBFs every night after office
hours! That's what an 10-year-old FoxPro/DOS MIS system I used to
maintain was doing :)
On Thu, Jun 25, 2020 at 10:33 AM MB Software Solutions, LLC
wrote:
MYSTERY SOLVED! IT *WAS* THE DELETED INDEX
On 6/26/2020 10:15 AM, Alan Bourke wrote:
I always just use READWRITE. Any potential few KB or microseconds saving from
not using READWRITE became meaningless many years ago.
Exactly...that's what I meant about "I'll take the sub-second
performance hit."
--
This email has been checked fo
I did set it as BINARY index. I changed all my logical field indexes
to binary a long time ago. My reasoning for what I said is that I would
have to go back to anywhere where I didn't have the READWRITE or
NOFILTER clause and expected to show the RECCOUNT() like the example I
posted, then it
On 6/24/2020 10:53 PM, Richard Kaye wrote:
In the real world it's probably negligible. I almost always use READWRITE.
Ditto. Successful for 20 +/- years with it. :-)
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
erformance gain would be worth the
aggravation this caused. (Made me doubt other areas working for years
tooyou know, the things nobody yet noticed or told you about?!?!?)
Thanks all for your thoughts,
--Mike
On 6/24/2020 5:51 PM, MB Software Solutions, LLC wrote:
The ONLY change I can
On 6/24/2020 5:35 PM, Richard Kaye wrote:
If you don't need the overhead of a writable cursor you can also use NOFILTER
to force the query engine to not just do a USE...AGAIN with a filter. As for
why now, the simplest answer I can think of is there was something about the
query and the source
ith LOCATE and FOUND(),
SEEK, even.
On Wed, Jun 24, 2020 at 5:52 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
The ONLY change I can see in the Order.dbf was that I added a INDEX ON
DELETED() tag DelFlag. Must have been that I know that changed the
o
sults.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Wednesday, June 24, 2020 5:24 PM
To: profoxt...@leafe.com
Subject: Re: Bizarre scenario solved by READWRITE clause on end of SELECT SQL
Correction...user is on a virtual machine with operating s
Correction...user is on a virtual machine with operating system being
WINDOWS 10 PRO. (Server is Win 2K12R2)
On 6/24/2020 4:35 PM, MB Software Solutions, LLC wrote:
VFP9SP2 (build 7423) on Win2K12 Terminal Server client user.
Screenshot: https://www.screencast.com/t/EYptATFR3ETW
Client
On 6/23/2020 2:06 PM, Ed Leafe wrote:
On Jun 23, 2020, at 12:35, MB Software Solutions, LLC
wrote:
Just curious--given what you said, why wouldn't you just go to MariaDB right
away then, skipping SQLite?
MariaDB requires a separate server. SQLite is a small library for a file-
VFP9SP2 (build 7423) on Win2K12 Terminal Server client user.
Screenshot: https://www.screencast.com/t/EYptATFR3ETW
Client said app that they have used since 2016 is now acting strange.
In short, a record count being reported about a cursor was now
erroneous. Underlying cause I found was that
Just curious--given what you said, why wouldn't you just go to MariaDB
right away then, skipping SQLite?
On 6/23/2020 11:48 AM, Vince Teachout wrote:
On 06/23/20 10:18 AM, John Weller wrote:
Has anyone used SQLite with VFP? I have always used DBFs as it seemed
over-kill to use SQL Server for
101 - 200 of 3305 matches
Mail list logo
