Re: Bizarre scenario solved by READWRITE clause on end of SELECT SQL (SOLVED)

2020-06-26 Thread MB Software Solutions, LLC
How does that have anything to do with the price of tea in China?   lol It wasn't that an index was out of whack; it's that the attempt to fully optimize caused VFP to unfortunately filter the table instead of give me an inaccurate count of the cursor. On 6/26/2020 11:06 AM, Man-wai Chang wro

AZURE and VFP

2020-06-26 Thread Rafael Copquin
I just started a trial instance of SQL Server on Azure. My question is whether it is possible to upload a VFP exe into a Storage account on Azure and have it run from a local browser. I have this app that produces payroll receipts. I can generate the payroll receipts for each employee in a pd

Re: Bizarre scenario solved by READWRITE clause on end of SELECT SQL (SOLVED)

2020-06-26 Thread Man-wai Chang
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 THAT CAUSED THE CHANGE

Re: Bizarre scenario solved by READWRITE clause on end of SELECT SQL

2020-06-26 Thread MB Software Solutions, LLC
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

Re: Bizarre scenario solved by READWRITE clause on end of SELECT SQL

2020-06-26 Thread Alan Bourke
I always just use READWRITE. Any potential few KB or microseconds saving from not using READWRITE became meaningless many years ago. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: