RE: Grid: Row-Level Validation

2013-11-22 Thread Dave Crozier
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:

Reproduceable C5 error

2013-11-22 Thread Paul Newton
Hi all The following code ALWAYS generates a C5 error: Calculate

Re: Reproduceable C5 error

2013-11-22 Thread Tracy Pearson
Paul Newton paul.new...@pegasus.co.uk wrote: Hi all The following code ALWAYS generates a C5 error: Calculate

RE: Reproduceable C5 error

2013-11-22 Thread Paul Newton
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),

RE: Reproduceable C5 error

2013-11-22 Thread Dave Crozier
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

RE: Reproduceable C5 error

2013-11-22 Thread Paul Newton
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 +

RE: Reproduceable C5 error

2013-11-22 Thread Dave Crozier
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

Strange File In Use Error #3

2013-11-22 Thread Jeff Johnson
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

RE: Reproduceable C5 error

2013-11-22 Thread Paul Newton
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

[NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Kurt @ VR-FX
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Ted Roche
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 --

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Dave Crozier
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Alan Bourke
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

Re: Reproduceable C5 error

2013-11-22 Thread Alan Bourke
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:

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Kurt @ VR-FX
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

RE: Strange File In Use Error #3

2013-11-22 Thread Tracy Pearson
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Vincent Teachout
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Stephen Russell
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Kurt @ VR-FX
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

Re: Strange File In Use Error #3

2013-11-22 Thread Jeff Johnson
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

Re: Reproduceable C5 error

2013-11-22 Thread Ted Roche
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 ---

RE: Reproduceable C5 error

2013-11-22 Thread Dave Crozier
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

Re: Reproduceable C5 error

2013-11-22 Thread Alan Bourke
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

RE: Reproduceable C5 error

2013-11-22 Thread Richard Kaye
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

RE: Grid: Row-Level Validation

2013-11-22 Thread Richard Kaye
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)

RE: Grid: Row-Level Validation

2013-11-22 Thread Richard Kaye
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

RE: Reproducible C5 error

2013-11-22 Thread Paul Newton
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.

Re: Reproduceable C5 error

2013-11-22 Thread Ted Roche
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

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Allen
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.

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Dave Crozier
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Vincent Teachout
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.

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Allen
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

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Allen
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

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Tracy Pearson
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread AndyHC
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

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Allen
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Kurt @ VR-FX
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

[OT] For you train enthusiasts

2013-11-22 Thread MB Software Solutions General Account
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:

RE: Grid: Row-Level Validation

2013-11-22 Thread MB Software Solutions General Account
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

Re: Grid: Row-Level Validation

2013-11-22 Thread AndyHC
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

[NF] Play with MacOS System 7 and Windows 1 in your browser.

2013-11-22 Thread Alan Bourke
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:

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread John Weller
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

RE: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Allen
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

Re: [OT] For you train enthusiasts

2013-11-22 Thread Jean MAURICE
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:

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Kurt @ VR-FX
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread AndyHC
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

RE: Grid: Row-Level Validation

2013-11-22 Thread Richard Kaye
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

Re: [NF] NEW Tablets - TOO Cheap???

2013-11-22 Thread Vincent Teachout
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

RE: Grid: Row-Level Validation

2013-11-22 Thread Gene Wirchenko
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

Re: [OT] For you train enthusiasts

2013-11-22 Thread Gene Wirchenko
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.

RE: Grid: Row-Level Validation

2013-11-22 Thread Gene Wirchenko
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

Re: Grid: Row-Level Validation

2013-11-22 Thread Gene Wirchenko
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

RE: Grid: Row-Level Validation

2013-11-22 Thread Richard Kaye
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,

Re: VFP6: Why would anyone....

2013-11-22 Thread Ken Dibble
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:

RE: Grid: Row-Level Validation

2013-11-22 Thread Ken Dibble
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

Re: Grid: Row-Level Validation

2013-11-22 Thread AndyHC
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,

Re: Grid: Row-Level Validation

2013-11-22 Thread Fred Taylor
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