Damn it!! Ted beat me to it the way that he has suggested is also the way
that I implement grid validation on the few occasions that it is called for.
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko
Sent: 21 November 2013 18:18
To:
Hi all
The following code ALWAYS generates a C5 error:
Calculate
Paul Newton paul.new...@pegasus.co.uk wrote:
Hi all
The following code ALWAYS generates a C5 error:
Calculate
No nothing like that. Here is some standalone code that I used for testing
Use tmp
Local lcCommand, lcCommand1, lcCommand2, lcCommand3, lcCommand4, lcCommand5,
lcCommand6, lcCommand7, lcCommand8
Local lcNewCommand, lcFields, lcVar, lnVar
lcCommand1 = Calculate Sum(NPAYAMNT), Sum(NDUEAMNT),
If you modify the for to include a statement i.e for (.T.=.F.) and
(..) to exclude all the data does it still throw an error? In which
case I'd start to look at the data and overflow possibilities or non numeric
content such as fields with * where VFP has loaded a default overflow
Dave
This reproduces the error
lnFields = 33
lcCode =
lcCode = Create Table Test (
For n = 1 To lnFields
lcCode = lcCode + Field + Transform(n) + N(2,0) + Iif(n
lnFields,,,))
EndFor
lccode
lcCode = Calculate
lcFields =
For n = 1 To lnFields
lcCode = lcCode + Sum(Field +
Paul,
Must be something to do with the created variables and a memory overflow
condition. Nothing about it in Hackers.
If you add the following to array aResults to hold the data as opposed to
discrete variables then it works fine.
Dave
-Original Message-
From: ProFox
I have a site that has been working fine for years. All of a sudden one
file is throwing the above error on one table only. You can view the
table fine. The problem is on add. There is a stored procedure that
bumps up the primary key on add. When the stored procedure is called it
throws
Dave
I am planning to use an array and then transfer values from the array to
discrete memory variables (obtained by parsing the command I posted earlier)
Paul
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: 22 November 2013
You know what they say - if It seems to good to be True - it probably
Is!...
I never got into the whole iPad thing, or the Google type Pad things.
Figured it wasn't something I HAD to Have. But, now that prices are
dropping - I may consider it. I got the email newsletter/sales thing
from
On Fri, Nov 22, 2013 at 10:36 AM, Kurt @ VR-FX v...@optonline.net wrote:
You know what they say - if It seems to good to be True - it probably
Is!...
http://search.dilbert.com/comic/Etch%20A%20Sketch
--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com
--- StripMime Report --
Galaxy ... can't go wrong...
Its only when you put cheaper ones next to the galaxy and look at
1. The VISIBLE screen resolution as on Android pixels per inch means diddley
squat, its the viewable image that is important.
2. The Android implementation. Samsung have added great fonts/styles that
On Fri, Nov 22, 2013, at 03:36 PM, Kurt @ VR-FX wrote:
You know what they say - if It seems to good to be True - it probably
Is!...
Yep. The only one of those worth a crap is the Galaxy.
Also don't expect anything like iPad functionality and speed. There's a
reason (other than typical
C5 for me too, FWIW.
Could you build an SQL-Select as 'select sum(npayamnt) as nPayamnt ... '
into a cursor, then 'Scatter Name loTotals' from the cursor, and then
work with loTotals?
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
I just over Dilbert - awesome stuff.
So - when I started reading it - what you sent - I thought - there goes
Ted - joking around. But - what did it have to do with my question!?!?
However - once I got to the punchline of the comic - and thought about
it - then I realized your joke! VERY Funny
Jeff Johnson wrote on 2013-11-22:
I have a site that has been working fine for years. All of a sudden one
file is throwing the above error on one table only. You can view the
table fine. The problem is on add. There is a stored procedure that
bumps up the primary key on add. When the
Kurt @ VR-FX wrote:
I don't have that particular model, but I've been happy with my Galaxy
for over a year now. fwiw.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of
On Fri, Nov 22, 2013 at 9:36 AM, Kurt @ VR-FX v...@optonline.net wrote:
You know what they say - if It seems to good to be True - it probably
Is!...
I never got into the whole iPad thing, or the Google type Pad things.
Figured it wasn't something I HAD to Have. But, now that prices are
Thanks Dave - that's gerat input. Also - thanks Alan for your input.
Will take this all into consideration!
-K-
On 11/22/2013 10:40 AM, Dave Crozier wrote:
Galaxy ... can't go wrong...
Its only when you put cheaper ones next to the galaxy and look at
1. The VISIBLE screen resolution as on
On 11/22/2013 8:54 AM, Tracy Pearson wrote:
Jeff Johnson wrote on 2013-11-22:
I have a site that has been working fine for years. All of a sudden one
file is throwing the above error on one table only. You can view the
table fine. The problem is on add. There is a stored procedure
That sounds suspiciously like a limit of 2^5 for internal accumulators,
though it's not in HackFox.
Looks like we missed one. Who's ever going to need more than 32?
--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com
--- StripMime Report -- processed MIME parts ---
Ted Looks like a new edition is called for in that case!!! grin
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 22 November 2013 16:04
To: profox@leafe.com
Subject: Re: Reproduceable C5 error
That sounds suspiciously like a limit
There was a 'C++ runtime library buffer overrun with CALCULATE SUM()'
fixed in VFP9 SP2 apparently. Not fixed good enough I reckons.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free
I will second Alan's suggestion to use SQL in place of the xBase CALCULATE
function. I was also going to ask if you possibly had some wonky data but that
seems less likely considering the magic number 32, or is that 33...
--
rk
-Original Message-
From: ProfoxTech
As long as we're getting all theoretical here, data validation should not be
handled by the grid object. The grid should be able to call out to an object
where you store your business rules. Then all your default control valid method
code can be is something like businessObject.validateMe(this)
In the beforerowcolchange method, do your row level validations. If that fails
then use NODEFAULT to prevent the rowcol change. At least that's what the VFP
help implies will accomplish what you want.
i.e.
IF RowDataIsValid()
MySaveDataMethod()
ELSE
NODEFAULT
Maybe setfocus to the first
Alan
That would be a definite possibility. Thanks for the suggestion
Paul
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: 22 November 2013 15:49
To: profoxt...@leafe.com
Subject: Re: Reproduceable C5 error
C5 for me too, FWIW.
On Fri, Nov 22, 2013 at 11:05 AM, Dave Crozier da...@flexipol.co.uk wrote:
Ted Looks like a new edition is called for in that case!!! grin
Wish I could. That's not in the stars, however.
Maybe if somebody started a Kickstarter to buy the rights from Hentzenwerke
and turn into a web
One thing I have learnt is the battery life seems crap on android devices.
Much as I hate apple and the culture of apple control, I have to admit the
ipad charge lasts a while, probably because it turns itself off while you
reading something. Also apple do update the ios even on my old ipad2.
On my 7 Galaxy that I've had just over a year and use daily, I can still
easily get a full day out of it and then it is down to about 20% charge so I
don't have a problem with battery life with GPS wireless live. The other
cheaper androids at work can manage about 6 hours with GPS Wireless
Allen wrote:
Samsung are crap at updates so unless you want to stay with old versions of
android, even old out the new pack, forget it.
Hm, that hasn't been my experience with my Samsung tablet - it keeps
both the OS and apps up to date constantly.
So what version of Android has Samsung given you as an update?
I am happy with my S1 phone but only because of cyanogenmod. I'm running
4.2.2.
I only got the android to look at programming. The acer is ok for that. On
that subject I got the android basic. So far Ive installed Java, android sdk
and
All I can tell you is 6 months after buying my S1 from new Samsung failed to
update the android o/s. And that's why the anti Samsung. And if you look at
google searches on the subject, I am not alone.
Al
-Original Message-
Samsung are crap at updates so unless you want to stay with old
Allen pro...@gatwicksoftware.com wrote:
All I can tell you is 6 months after buying my S1 from new Samsung
failed to
update the android o/s. And that's why the anti Samsung. And if you
look at
google searches on the subject, I am not alone.
Al
Al,
In my experience, they phone company updates
I can't even get to look at them - they've set a geo-locator - cute!
On 22/11/2013 21:06, Kurt @ VR-FX wrote:
You know what they say - if It seems to good to be True - it probably
Is!...
I never got into the whole iPad thing, or the Google type Pad things.
Figured it wasn't something I HAD
My S1 was updated once by Samsung. It was a sim free one.
Al
-Original Message-
Al,
In my experience, they phone company updates the phone os. Tablets are
updated by the manufacturer.
--
Tracy
___
Post Messages to: ProFox@leafe.com
Wow - that's a bummer - sorry about that. Nothing i can really do - as
we can't attach pics here. FYI - this store - Microcenter - its really
more of a BrickMortar store - unlike Amazon - and its not International
- AFAIK - and why they probably do the Geo thingy...
And - thanks EVERYONE for
The official video about Miniatur Wunderland Hamburg, the largest model
railway in the world, and one of the most successful tourist attractions
in Germany.
http://www.youtube.com/watch?v=ACkmg3Y64_sfeature=youtu.be
___
Post Messages to:
On Thu, November 21, 2013 10:24 am, Richard Kaye wrote:
As long as we're getting all theoretical here, data validation should not
be handled by the grid object. The grid should be able to call out to an
object where you store your business rules. Then all your default control
valid method code
Well if we're getting theoretical, another possible (and actually very
good) place for your data validation rules in in a cursoradapter. It has
all the update control you could possibly want and - it's been some time
- but doesn't a ca draw a grid if you drag it onto a form?
On 22/11/2013
http://jamesfriend.com.au/pce-js/
http://jsmachines.net/configs/pc/machines/5160/cga/256kb/win101/
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
I can see them and I'm in UK.
John Weller
01380 723235
07976 393631
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
AndyHC
Sent: 22 November 2013 16:43
To: profoxt...@leafe.com
Subject: Re: [NF] NEW Tablets - TOO Cheap???
I can't even get
Likewise from France
Al
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John
Weller
Sent: 22 November 2013 18:28
To: profoxt...@leafe.com
Subject: RE: [NF] NEW Tablets - TOO Cheap???
I can see them and I'm in UK.
John Weller
01380 723235
07976
it's such a success that some other are 'birthing' (is that clear ?) in Europe :
www.kaeserberg.ch
www.miniworld-lyon.com/
Best Regards
The Foxil
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Maybe the site simply does Not Like Andy! Sorry Andy... :-(
Maybe try a different browser???
-K-
On 11/22/2013 12:29 PM, Allen wrote:
Likewise from France
Al
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John
Weller
Sent: 22 November 2013
I'm in India, I guess I could swap over to my uk proxy, but I found the
same things available here - the Asus works out at about $100. I need a
new audio server (my phone gets a bit too hot) - I was looking at a
small form factor bare bones PC but I wonder if one of these would do.
I'll check
Only if you can assume all your rules fit comfortably in the DB. There's data
validation and business validation if you're inclined to separate the two.
I think you're right that a CA will make a grid control much like a table or a
view but I don't use CAs so have never tried that.
--
rk
Tracy Pearson wrote:
In my experience, they phone company updates the phone os. Tablets are updated
by the manufacturer.
Ah, maybe that's the difference - I do have the tablet, not the phone.
___
Post Messages to: ProFox@leafe.com
Subscription
At 10:34 2013-11-21, Richard Kaye rk...@invaluable.com wrote:
In the beforerowcolchange method, do your row level validations. If
that fails then use NODEFAULT to prevent the rowcol change. At least
that's what the VFP help implies will accomplish what you want.
No kidding.
My
At 09:04 2013-11-22, MB Software Solutions General Account
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
The official video about Miniatur Wunderland Hamburg, the largest model
railway in the world, and one of the most successful tourist attractions
in Germany.
At 07:24 2013-11-21, Richard Kaye rk...@invaluable.com wrote:
As long as we're getting all theoretical here, data validation should not be
What theoretical? I am trying to IMPLEMENT something.
[snip]
Sincerely,
Gene Wirchenko
___
Post
At 11:55 2013-11-21, Fred Taylor fbtay...@gmail.com wrote:
Here's a sample that should show you how to do it. Just cut and paste into
a .PRG and run it. Note the Form DataCheck method and the
Grid.BeforeRowColChange code. Uses data buffering, GETFLDSTATE and OLDVAL.
I tried to remove as much
Sorry if my general commentary isn't helpful, Gene. I was just trying to makes
suggestions at more of an architectural level. I'll leave you to it.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Friday, November 22,
Oh. Just seemed odd, at the time. Like going to LA via Omaha
or something!
Wh! Charlie Daniels reference!
Ken Dibble
www.stic-cil.org
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
As long as we're getting all theoretical here, data validation should not
be handled by the grid object. The grid should be able to call out to an
object where you store your business rules. Then all your default control
valid method code can be is something like
If you want to reduce clutter at least look at cursoradapters - they
include GetFldState level info and lots more, and they offer a lot of
advantages apart from helping with validation.
There's plenty of stuff on them in Help!
On 23/11/2013 01:42, Gene Wirchenko wrote:
At 11:55 2013-11-21,
If I could work exclusively in VFP9, I'd have to agree cursor adapters
would be the tool of choice. VFP7 didn't have them. I wish I could
convince TPTB to use VFP9, but they'd rather spend the time (and money),
re-writing in .NET.
Fred
On Fri, Nov 22, 2013 at 9:00 PM, AndyHC
57 matches
Mail list logo