Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Frank Cazabon
Thanks for the recommendations everyone Frank. Frank Cazabon On 23/08/2012 02:46 PM, MB Software Solutions General Account wrote: On Thu, August 23, 2012 1:42 pm, Desmond Lloyd wrote: FWIW, I find the ergonomic keyboards to be more of a natural feel for the hands. Love the way the left

Re: [NF]: Object Oriented Database

2012-08-24 Thread Man-wai Chang
Waste of time, unless you have a good reason to use it. RDBMS could support hierarchical database. On Fri, Aug 24, 2012 at 4:42 AM, Eurico Chagas Filho e28cha...@yahoo.com.br wrote: I have been looking into this, particularly ZODB. I wonder if this can substitute RDMS with success. Any one of

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Man-wai Chang
I think the best defense is not to rely on a tool or design, but to exercise your palms and the tunnel muscles periodically, and to massage the tendons Nothing can replace rest and sleep, not even money. On Fri, Aug 24, 2012 at 8:22 PM, Frank Cazabon frank.caza...@gmail.com wrote: Thanks

RE: Problem with Foxcharts

2012-08-24 Thread Richard Kaye
The source for SYSTEM.APP is from the GDIPlusX project at VFPX. http://vfpx.codeplex.com/releases/view/15083 -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Friday, August 24, 2012 9:10 AM To:

RE: Problem with Foxcharts

2012-08-24 Thread Paul Newton
Thanks for that Richard - I'll look into it -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 24 August 2012 14:14 To: profoxt...@leafe.com Subject: RE: Problem with Foxcharts The source for SYSTEM.APP is from the

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Jeff Johnson
On 08/24/2012 05:35 AM, Man-wai Chang wrote: I think the best defense is not to rely on a tool or design, but to exercise your palms and the tunnel muscles periodically, and to massage the tendons Nothing can replace rest and sleep, not even money. +1 Jeff --- Jeff Johnson

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Jeff Johnson
Frank: I have been typing on a keyboard all of my adult life. During the 90's I started to develop pain in my hands and wrists. It may have been the beginnings of carpal tunnel. I went with a wave keyboard and have used them ever since. The pain went away right away and never came back.

Re: auto increment

2012-08-24 Thread Frank Cazabon
Hi Lew, SELECT MAX() + 1 can result in two or more people getting the same next ID. If you were running the system at the same time I was, we could both run that code at almost the same time and end up with the same ID which could cause no end of problems. The standard ways to do this is to

Re: auto increment

2012-08-24 Thread Alan Bourke
On Fri, Aug 24, 2012, at 02:44 PM, Lew Schwartz wrote: I never understood why these routines would be any better than max()+1. Because they are GUIDs - globally unique. That fact is very important in some applications, but overkill for a lot of others. -- Alan Bourke alanpbourke (at)

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread MB Software Solutions General Account
On Fri, August 24, 2012 9:30 am, Jeff Johnson wrote: Frank: I have been typing on a keyboard all of my adult life. During the 90's I started to develop pain in my hands and wrists. It may have been the beginnings of carpal tunnel. I went with a wave keyboard and have used them ever since.

RE: auto increment

2012-08-24 Thread Gary Jeurink
Wow, way over my head, but I've got it and can use it as a stored procedure and play with it, right? Thanks Gary -Original Message- From: Dave Crozier [mailto:da...@flexipol.co.uk] Sent: Friday, August 24, 2012 3:52 AM To: ProFox Email List Subject: RE: auto increment Why not use thee

RE: auto increment

2012-08-24 Thread Gary Jeurink
A lot of information. Thanks. For now, the max+1 will work as long as I use an unfiltered list so that updates through view update only their key record but logging in users I use a username and encrypted password. They never see their actual member number id. So is it okay to stay simple with

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Ted Roche
On Fri, Aug 24, 2012 at 9:26 AM, Jeff Johnson j...@san-dc.com wrote: On 08/24/2012 05:35 AM, Man-wai Chang wrote: I think the best defense is not to rely on a tool or design, but to exercise your palms and the tunnel muscles periodically, and to massage the tendons Nothing can replace

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Jeff Johnson
On 08/24/2012 08:23 AM, MB Software Solutions General Account wrote: On Fri, August 24, 2012 9:30 am, Jeff Johnson wrote: Frank: I have been typing on a keyboard all of my adult life. During the 90's I started to develop pain in my hands and wrists. It may have been the beginnings of carpal

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Michael Oke, II
I'm with Matt because I just can't get comfortable when using an ergo keyboard. Guess that I would adjust if it became a health issue tho. Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. On Aug 24, 2012, at 9:52 AM, M Jarvis

Re: auto increment

2012-08-24 Thread Ed Leafe
On Aug 24, 2012, at 9:31 AM, Alan Bourke wrote: Because they are GUIDs - globally unique. That fact is very important in some applications, but overkill for a lot of others. When OpenStack was first created, it used auto-incremented keys to identify resources such as servers, volumes,

Re: auto increment

2012-08-24 Thread Paul McNett
On 8/24/12 2:18 AM, Paul Hill wrote: Guids are nice but can add a significant size overhead to your database. Yes, that is the one disadvantage I've identified, but storage is cheap. It isn't as if query performance necessarily goes down as the database grows in size. Paul

Re: auto increment

2012-08-24 Thread Paul McNett
On 8/24/12 10:17 AM, Ed Leafe wrote: The worst part is that several of us argued for UUIDs from the start, but lost that discussion to those who favored the simplicity of letting the database handle key generation. In my mind, keeping it simple means UUID. Paul

Re: auto increment

2012-08-24 Thread Ed Leafe
On Aug 24, 2012, at 3:24 PM, Paul McNett wrote: Guids are nice but can add a significant size overhead to your database. Yes, that is the one disadvantage I've identified, but storage is cheap. It isn't as if query performance necessarily goes down as the database grows in size.

Re: auto increment

2012-08-24 Thread Paul McNett
On 8/24/12 1:29 PM, Ed Leafe wrote: On Aug 24, 2012, at 3:24 PM, Paul McNett wrote: Guids are nice but can add a significant size overhead to your database. Yes, that is the one disadvantage I've identified, but storage is cheap. It isn't as if query performance necessarily goes down as

Re: Tables left open when form closes

2012-08-24 Thread MB Software Solutions General Account
On Fri, August 24, 2012 4:11 pm, Peter Hart wrote: I have an application which uses Arg Software Ribbon bars. When I click on an icon to open a form which needs to open a table exclusive i.e. for re-indexing. I get an error that the table is already in use. I don't get this error if either

Re: Tables left open when form closes

2012-08-24 Thread Fred Taylor
A private DataSession will close it's own use of a table. Are you sure that the table wasn't already open before your private DS form ran? If the tables were already open, the private DS will not close them, only its use of the tables, essentially like a USE AGAIN. Fred On Fri, Aug 24, 2012

Re: Tables left open when form closes

2012-08-24 Thread Eurico Chagas Filho
Don't waste time looking for the problem. Just emit a SET Database TO and  CLOSE TABLES ALL . After that execute your routine. E. From: Peter Hart ph...@peterhartcomputers.co.uk To: 'profox@leafe.com' profox@leafe.com Sent: Friday, August 24, 2012 5:11 PM

RE: Tables left open when form closes

2012-08-24 Thread John Weller
Try AUSED() to find which tables are open. John Weller 01380 723235 07976 393631 -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Peter Hart Sent: 24 August 2012 21:12 To: profoxt...@leafe.com Subject: Tables left open when

Re: Tables left open when form closes

2012-08-24 Thread Fred Taylor
AUSED() only reports on the current session if a sessionid is not specified. In any case, it only reports on a single session. Fred On Fri, Aug 24, 2012 at 2:07 PM, John Weller j...@johnweller.co.uk wrote: Try AUSED() to find which tables are open. John Weller 01380 723235 07976 393631

Re: Tables left open when form closes

2012-08-24 Thread Tracy Pearson
Peter Hart ph...@peterhartcomputers.co.uk wrote: I have an application which uses Arg Software Ribbon bars. When I click on an icon to open a form which needs to open a table exclusive i.e. for re-indexing. I get an error that the table is already in use. I don't get this error if either this is

Re: auto increment

2012-08-24 Thread Ken Dibble
Over the years of my experience with Fox and VFP, I used all kinds of ways to generate primary keys, and in retrospect the best ever was concatenating the machine name with the output of sys(2015). Wasn't it true at one time that SYS(2015) didn't guarantee uniqueness? More like

Re: auto increment

2012-08-24 Thread Paul McNett
On 8/24/12 5:21 PM, Ken Dibble wrote: That's why I concatenate with the machine name. I guess if you are really paranoid that a second instance of VFP could be running sys(2015) for the same table in the exact same timeslice as the first process you could also concatenate the process id.

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-24 Thread Ken Dibble
I was found to have carpel tunnel problems a decade ago with nerve conduction tests. The doc told me of two kinds of surgery available, one with a two week recovery, one with 48 hour recovery, but a higher risk of permanent loss of feeling in the hands. There's no guarantee you'll get the

Re: auto increment

2012-08-24 Thread Ken Dibble
On 8/24/12 5:21 PM, Ken Dibble wrote: That's why I concatenate with the machine name. I guess if you are really paranoid that a second instance of VFP could be running sys(2015) for the same table in the exact same timeslice as the first process you could also concatenate the

Re: Tables left open when form closes

2012-08-24 Thread Ken Dibble
Is it possible to run through all used work areas to see if the tables required are in use and if so close them? You can use AUSED(), you may need to use SET DATASESSION also. You can use ASESSIONS() to get an array of data session IDs, and then loop through those, use AUSED() to get an