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
Thanks Richard - I have a copy of XP which I am tempted to install, no update
hassle there
John
John Weller
01380 723235
07976393631
-Original Message-
From: ProfoxTech On Behalf Of Richard Kaye
Sent: 22 June 2018 22:11
To: profoxt...@leafe.com
Subject: RE: VFP in Windows
You can use the Mac RDP client if you have a Terminal Server/RDS server handy.
Otherwise, Parallels will do the trick but you will need a Windows
license/installation media to create a Windows VM that will run just fine.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of
I have had a nightmare installing the latest Win 10 update. The only thing
stopping me from throwing the PC out of the window and going out and buying
a Mac was the fact that I have a number of apps still in use written in VFP
which I need to maintain. I was told recently that I could run
You need it by line item so that you can more easily reverse that part of the
transaction. IAC this is why having a service you can call that keeps track of
each state's regs so you don't have to build and maintain them all in code is
worthwhile.
--
rk
-Original Message-
From:
Frank,
You're responding here to my response to Ted's code, not yours.
Your code runs fine, and I responded to that separately.
Ken
Content-Transfer-Encoding: base64Did you run it
as part of the first set of code that I gave you?
It runs here with no errors in VFP9 with the latest hot fix
You just need to change the first line of the query to this:
SELECT COUNT(Status.ConFK) AS ConsCount, SUM(LastHours.AppHours) AS
HoursSum;
Frank.
Frank Cazabon
On 22/06/2018 01:04 PM, Ken Dibble wrote:
Maybe this will do what you want:
SELECT Status.ConFK, LastHours.AppHours;
FROM
On Thu, Jun 21, 2018 at 3:46 PM, Mike wrote:
> There are several, and the common scheme is to charge you a rate for each
> access via the API. Usually something in the tenths of a cent range.
>
> So if you need a rate for a quote, you pay.
> If you need a rate for a sale, you pay.
> If you just
Ken,
Sorry, I hadn't realised you were responding to Ted's code.
Frank.
Frank Cazabon
On 22/06/2018 01:11 PM, Frank Cazabon wrote:
Did you run it as part of the first set of code that I gave you?
It runs here with no errors in VFP9 with the latest hot fix and SPs. ;)
What error is it
Did you run it as part of the first set of code that I gave you?
It runs here with no errors in VFP9 with the latest hot fix and SPs. ;)
What error is it giving you? Maybe a line split somewhere due to the
email formatting?
This is the full code:
CREATE CURSOR Consumers;
(ConPK int)
INSERT
Illinois, I think, charges sales tax on food, unless it has wheat as an
ingredient. So a TWIX bar, which has wheat in it, is tax-free, but a
MARS BAR is taxed.
Some states charge sales tax on certain types of clothing depending on
their price...tennis-shoes are tax-free unless it's an
Maybe this will do what you want:
SELECT Status.ConFK, LastHours.AppHours;
FROM Status ;
INNER JOIN (SELECT ConFK, MAX(Date) AS MaxDate;
FROM Status;
GROUP BY ConFK) M ON Status.ConFK =
M.ConFK AND Status.Date = M.MaxDate ;
AND Type = "Approved";
LEFT JOIN
Personally I avoid _TALLY since so many commands & functions in VFP
will change it.
I don't think there's any danger of it getting changed if I store the
contents of _TALLY to a local variable immediately after running the
query, which is what I always do.
I think RECCOUNT() moves the
SELECT Consumer.*, Status.*, Hours.AppHours
FROM Consumer
JOIN Status on Consumer.ConPK=Status.ConFK
LEFT OUTER JOIN Hours on Consumer.ConPK=Hours.ConFK
WHERE Status.Date =
(SELECT MAX(Stat2.Date) FROM Status Stat2 WHERE
Stat2.ConFK = Consumer.ConPK GROUP BY Stat2.ConFK)
AND Status.Type =
Functional Government? hahahahaha
Just a heads up on the stupidity of taxes. My county has a State rate + a
VARIABLE county rate that is a function of the $$$ amount of the sale. If
the sale price is over 6500 the rate is no longer charged to that 6500.
value. 7.00 sate + 2.5 county for under
Yes. Many states have different tax rates and keeping on top of that stuff is a
bear. This is what makes it attractive and worth the cost to use a service that
takes care of all the fine details.
If we had a functional government I would expect Congress to figure out how to
fix the upcoming
Taxes get DEEP as I remember. State, County, City/Parish, etc.
Now do you pay a trifle to check them for every transaction or do you build
a log to keep all these value pairs with a date? Yeah a .001 cent fee per
sale I'd get the rate for each sale. Now if it was 1.00 USD I'd think
twice about
> Interesting. I've always just followed the principle that if a parent can
> own more than one value for a particular item, you put that item in a child
> record, and keep the child records in a separate table and JOIN it as
> needed.
So, can a Consumer be both Approved and Pending?
By your
18 matches
Mail list logo