Re: [NF] Wireless network SYSFU

2012-02-08 Thread Mike Copeland
Again, apologies if you already know this...revisiting the basics... And, I agree that it is odd that everything worked until you shut it all down, then powered it all back up. One very hard lesson I learned a long time ago was to take notes about the set up, including passwords, when piecing a

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
Thanks, Mike --- -- For one of the devices, the working WAP, the default IP is 192.168.0.227. I kept this one as the default. The test computer's IP is 192.168.0.104. The subnet mask for both is 255.255.255.0 -- At this point, I'd just like to see the Admin screen for any wireless device, just to

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Mike Copeland
Don't forget that if you are connecting directly from a computer to the WAP that you'll need to make sure both devices are on the same subnet. If your laptop (just a WAG what you're using for a computer to connect to the WAP with) is set to get an IP and subnet mask from a DHCP server, then you

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Richard Quilhot
Is your test computor's IP compatable with the default IP of the router(s)? Rick Q quilh...@gmail.com On Wed, Feb 8, 2012 at 11:08 PM, Ken Kixmoeller (ProFox) < foxh...@information-architecture.com> wrote: > Oh, how I hate hardware. Hate it, hate it, HATE it!! > > OK, got that out of my syste

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
Oh, how I hate hardware. Hate it, hate it, HATE it!! OK, got that out of my system. (Actually not, but let's proceed anyway.) Testing my theory that the WAPs have been reset and are operating with the same IP addresses. Well, I can't test it. I hook up a computer directly to the WAP. Put in turn

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Stephen Russell
On Wed, Feb 8, 2012 at 9:09 PM, Richard Quilhot wrote: > Don't get me wrong, I'm fine working with EDI. But, like you said each > trading partner > has it's own take on how the standards are used. Standards? We have upped our so up yours. I have a whole collection of la

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
An EDI specialist using Foxpro.   I hope the people who pay your salary realize how specialized that actually is.   LOL From: Richard Quilhot To: ProFox Email List Sent: Wednesday, February 8, 2012 10:09 PM Subject: Re: USAGE Of Memos, Stability & an Error!

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
I hated EDI with a passion.  Hopefully the guy who invented it is burning in Hell right now.  From: "Kurt @ VR-FX" To: profox@leafe.com Sent: Wednesday, February 8, 2012 9:08 PM Subject: Re: USAGE Of Memos, Stability & an Error! U guys crack me up with the E

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Richard Quilhot
Don't get me wrong, I'm fine working with EDI. But, like you said each trading partner has it's own take on how the standards are used. Rick Q quilh...@gmail.com On Wed, Feb 8, 2012 at 9:08 PM, Kurt @ VR-FX wrote: > U guys crack me up with the EDI comments. Yeah - at times it IS a PITA. > Se

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt @ VR-FX
True. Most of our clients are running the system via VFP 7 and not 9. -K- On 2/8/2012 7:45 PM, Dan Covill wrote: > On 02/08/12 12:54, Richard Quilhot wrote: >> Unless you really need that kind of space for storing unformatted text, do >> the rewrite. >> This will continue to happen every time ther

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt @ VR-FX
U guys crack me up with the EDI comments. Yeah - at times it IS a PITA. Seems there is some kind of standard - but, then many stores have TOO Many deviations. But, there kind of is a certain amount of standards underlying it all. Believe me. I've been dealing with the stuff for like 3.5 years n

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
On Wed, Feb 8, 2012 at 5:26 PM, Richard Kaye wrote: > Then you'll need this > > http://www.dead.net/ Far out! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http:/

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
On Wed, Feb 8, 2012 at 5:32 PM, Dan Covill wrote: > On 02/08/12 09:45, Fred Taylor wrote: > > We're discussing the options this afternoon. But as with all things in > the > > programming world, the fix is needed yesterday! > > > > All the clever ideas were immediately trashed soon after their >

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Michael Madigan
If you have a wireless router that you're using as a wireless access point, make sure you're not using the uplink port and just using the switch, and make sure there is only one DHCP server on the network.  From: Dan Covill To: ProFox Email List Sent: Wednes

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Dan Covill
On 02/08/12 12:54, Richard Quilhot wrote: > Unless you really need that kind of space for storing unformatted text, do > the rewrite. > This will continue to happen every time there is a ungracefull shit down of > the app. > > Rick Q > quilh...@gmail.com > Is this an older version of VFP? I use m

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Dan Covill
Ken: After reconnecting, are they all on the same channel? I'm wired, but I think Wireless routers can change channels to deal with interference. If so, they need to be on the same channel. Dan On 02/08/12 11:44, Ken Kixmoeller (ProFox) wrote: > Hey -- I'm baffled by hardware issues --- (so w

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Dan Covill
On 02/08/12 09:45, Fred Taylor wrote: > We're discussing the options this afternoon. But as with all things in the > programming world, the fix is needed yesterday! > > All the clever ideas were immediately trashed soon after their suggestion. > Some of those were even my ideas! > > Fred Hi, Fr

RE: [NF] Wireless network SYSFU

2012-02-08 Thread Richard Kaye
Then you'll need this http://www.dead.net/features/listening-party/listening-party-daves-picks-volume-one -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Kixmoeller (ProFox) Sent: Wednesday, February 08, 2012 6:08 PM To

Fw: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
I have clients that say, "You're the expert, I'm going to trust your recommendations", and I have clients who think they know it all.  - Forwarded Message - From: Fred Taylor To: ProFox Email List Sent: Wednesday, February 8, 2012 6:06 PM Subject: Re: USAGE Of Memos, Stability & an Err

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
Every store does EDI differently, so how the hell is it a standard anyway?  From: Richard Quilhot To: ProFox Email List Sent: Wednesday, February 8, 2012 5:50 PM Subject: Re: USAGE Of Memos, Stability & an Error! It is a PITA! Rick Q quilh...@gmail.com

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
On Wed, Feb 8, 2012 at 1:48 PM, Richard Kaye wrote: > Or you can throw out all the damn computers... ... and start that sandal and candle-making business I dreamed about in the early '70s. Just a front for a head shop, of course. ___ Post Messages to:

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Fred Taylor
On Wed, Feb 8, 2012 at 3:03 PM, Paul McNett wrote: > On 2/8/12 1:42 PM, Fred Taylor wrote: > > Yep, we used to have a client in a very rural part of Connecticut. Their > > power was so bad that every time the phone rang, the lights would dim! > It > > did take the power company coming out and s

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
Well, dumb-ass-ly, I didn't pay much attention to what was plugged in where. Why bother, right? You have a bunch of WAPs and computers plugged into a router and switch. (The switch is faster than the router, so I had the bunch-o-computers that I used before consolidating all of the OS platforms ont

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
Well, your suggestions got me thinking, and and further investigating. I has set fixed IPs and they must have reset to default, as they are no longer at the IP address at which I set them. Sooo. Off to Reconfigure-land. Ken ___ Post Messages to:

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
I have always thought it was strange and baffling. The one working wireless is in the corner of the first floor. It only reaches the kitchen reliably, and not too well directly above in our master BR. The footprint is pretty small, about 900 sq. ft. Some of the rooms are additions, and there may be

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
I'm guessing they need to shut off write caching on the server or put in another server just for Foxpro.   Depending how disk-intensive your application is, you can get by with just a NAS.  Have I said lately how much I love my NAS lately? LOL From: Kurt Wendt

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Richard Quilhot
It is a PITA! Rick Q quilh...@gmail.com On Wed, Feb 8, 2012 at 5:48 PM, Michael Madigan wrote: > I break into a rash every time someone mentions EDI. > > > > From: Richard Quilhot > To: ProFox Email List > Sent: Wednesday, February 8, 2012 4:27 PM > Subject

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
I break into a rash every time someone mentions EDI.   From: Richard Quilhot To: ProFox Email List Sent: Wednesday, February 8, 2012 4:27 PM Subject: Re: USAGE Of Memos, Stability & an Error! Those EDI elements that repeat could be put into a child table(s)

RE: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt Wendt
Michael, As for item #1 - I asked my Tech here - and he didn't know (we don't do any HW or Network support for this particular client). For 2 - he says they do have one. FYI - their server - they have several where their employees log into via Thin Clients. And, those servers are NOT the ones

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Paul McNett
On 2/8/12 1:42 PM, Fred Taylor wrote: > Yep, we used to have a client in a very rural part of Connecticut. Their > power was so bad that every time the phone rang, the lights would dim! It > did take the power company coming out and showing them they were only > getting ~103 volts from the wall b

Re: [NF] Wireless network SYSFU

2012-02-08 Thread desmond . lloyd
Sent via BlackBerry by AT&T -Original Message- From: Michael Madigan Sender: profox-boun...@leafe.com Date: Wed, 8 Feb 2012 13:34:51 To: ProFox Email List Reply-To: ProFox Email List Subject: Re: [NF] Wireless network SYSFU Good point Joe, plaster reinforced with screen would certain

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Fred Taylor
A big problem here in AZ, at least for trying to get a signal on the back porch. Most exterior walls are stucco, and that's usually plaster type mixture over chicken wire. Fred On Wed, Feb 8, 2012 at 2:34 PM, Michael Madigan wrote: > Good point Joe, plaster reinforced with screen would certain

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Mike Copeland
I've seen that done in very high-end ($$$) custom homes...creates a very interesting challenge for lots of devices...cell phones, wireless devices, any kind of radio. One client ended up putting external antennas in the attic crawlspace, connected to the computer with an antenna cable dropped t

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Fred Taylor
Yep, we used to have a client in a very rural part of Connecticut. Their power was so bad that every time the phone rang, the lights would dim! It did take the power company coming out and showing them they were only getting ~103 volts from the wall before they'd believe us and put UPSs on their

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Michael Madigan
Good point Joe, plaster reinforced with screen would certainly prevent WIFI signals.   - Original Message - From: Joe Yoder To: profox@leafe.com Cc: Sent: Wednesday, February 8, 2012 4:26 PM Subject: Re: [NF] Wireless network SYSFU Wire lath? Ken - if you continue to have problems ge

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Mike Copeland
Okay...lead paint was (meant to be) a joke. My WAG is that you plugged the power back to the different components such that the device (usually the cable or DSL modem) that is providing your DHCP (dynamic IP address assignments) wasn't fully booted and stable before the power was applied to the

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
I had a client once who refused to put battery backups on his computers when he was in a very old office building with terrible power.   He only had 10 computers, the UPSs would have cost him about $500 bucks and would have saved a TON of problems.  Never underestimate the shortsightedness of a

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Richard Quilhot
Those EDI elements that repeat could be put into a child table(s) with as many rows as needed. Same thng with the tracking numbers. Rick Q quilh...@gmail.com On Wed, Feb 8, 2012 at 4:21 PM, Kurt Wendt wrote: > FYI - for that EDI Data storage - that anywhere from like 20 lines (each > 20 to 1

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Michael Madigan
We've been using memo fields for the main case history of a collection agency program for 20 years  without problems. 1.  Is opportunistic locking and write caching shut off on the data server?  2.  Does the data server have a UPS on it and is the battery good?  - Original Message - F

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Joe Yoder
Wire lath? Ken - if you continue to have problems getting connectivity restored it might be helpful to share the configuration of the system. (Are the wireless routers all connected to each other via cable or are some of the units acting as repeaters.) Another issue is whether each unit runs it's

RE: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt Wendt
FYI - for that EDI Data storage - that anywhere from like 20 lines (each 20 to 100 chars's) to 100 lines or MORE! And - as another update. My buddy told me the client had a server Crash. {NOT very shocking when he told me their server has 3GB of RAM - while the system the other day reported usage

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Ted Roche
Ken: Ignoring the lead paint and other distractions, what changed? Is it possible you put cables back into the wrong spots, or stretched and broke them? This stuff usually works, or doesn't. It usually doesn't stop just cause it was turned off and shuffled around, unless it got wired differently.

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Sytze de Boer
In my opinion, if a field has to capture data from 2 to 150 chars, I would use a text field Then I would consider a memo field S On Thu, Feb 9, 2012 at 10:06 AM, Kurt Wendt wrote: > In the one instance - it had to do with the saving of Shipment Tracking > numbers for an Invoice. It could be as

RE: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt Wendt
In the one instance - it had to do with the saving of Shipment Tracking numbers for an Invoice. It could be as few as 2 numbers, or up to 20 or more. So - the Memo field seemed the most obvious method - as well as a Quick & Dirty solution. For the other project - it happens to do with EDI data - a

RE: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt Wendt
OK Paul - that was just a POOR Attempt at Humour! But - alas - you made me chuckle - so, it was well worth it. It reminds me of a comment that one of our QA Tech's constantly makes to me. That our EDI processing code in our system Sucks - and he keeps telling me I should Re-Write the whole thing!

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Sytze de Boer
1 Beware of babies and bathwater 2 Memos can be very useful and to avoid them can be more effort than they're worth 3 There are some extremely good data recovery tools out there 4 Why not look to see what caused the problem. The corruption is a result, not a cause S On Thu, Feb 9, 2012 a

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Michael Madigan
If i'm using my laptop on the kitchen table, you can't use the microwave or else it screws up the wifi signal.  I'm wondering if biting the bullet and putting in wires isn't the best solution. - Original Message - From: john harvey To: 'ProFox Email List' Cc: Sent: Wednesday, Februar

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Richard Quilhot
Unless you really need that kind of space for storing unformatted text, do the rewrite. This will continue to happen every time there is a ungracefull shit down of the app. Rick Q quilh...@gmail.com On Wed, Feb 8, 2012 at 3:50 PM, Kurt Wendt wrote: > So - here where I work - they have genera

Re: USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Paul McNett
On 2/8/12 12:50 PM, Kurt Wendt wrote: > Any advice? Should I re-write their systems to NOT use Memo fields??? Rewrite the systems to use a backend database server and connect to it with ODBC, which Microsoft recently re-blessed. Paul ___ Post Messag

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Allen
I have an old farmhouse in France with 3 foot walls. I have two routers and I can get Wi-Fi in any room in the house and even across the courtyard to the gite in one room. However I recently got hold of some Ethernet over mains and they work a treat. Al -Original Message- ___

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Paul McNett
On 2/8/12 12:40 PM, Mike Copeland wrote: > ...lead paint? I have several layers of lead paint to go with the wood lath and plaster. Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free v

USAGE Of Memos, Stability & an Error!

2012-02-08 Thread Kurt Wendt
So - here where I work - they have generally stayed away from using MEMO Fields in the FoxPro system they have. This old guy that worked here for YEARS - he would Insist that they not be used in the system. Well, he's been gone for like 1.5 years by now. Well, recently - in 2 different client

RE: [NF] Wireless network SYSFU

2012-02-08 Thread john harvey
Antenna strength, most likely. I had an older Linksys router that didn't get to all parts of my house, so I bought an 18 db antenna from radiolabs.com and the problems went away. John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Paul McN

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Mike Copeland
...lead paint? Mike Original Message Subject: Re: [NF] Wireless network SYSFU From: Paul McNett To: profoxt...@leafe.com Date: 2/8/2012 2:11 PM On 2/8/12 11:44 AM, Ken Kixmoeller (ProFox) wrote: > I have an old house with plaster walls through which wireless signals > seem l

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Paul McNett
On 2/8/12 11:44 AM, Ken Kixmoeller (ProFox) wrote: > I have an old house with plaster walls through which wireless signals > seem loathe to pass. I have wood lath and plaster walls and the wifi is great throughout. The single AP is in one of the corner bedrooms and the opposite corner gets great

[OT] After billions in bailouts and subsidies, Chevy volt is still a PoS.

2012-02-08 Thread Michael Madigan
http://www.breitbart.tv/eric-bolling-tests-chevy-volt-runs-out-of-juice-in-lincoln-tunnel/  ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/

RE: [NF] Wireless network SYSFU

2012-02-08 Thread john harvey
Believe it or not, you can make your WAP signal directional. Put some aluminum foil behind it and create a parabola which will reflect the signal towards the intended targets. I had to do this on my Linksys router which is located on the first floor. My wife's pc couldn't get a strong enough signal

RE: [NF] Wireless network SYSFU

2012-02-08 Thread Richard Kaye
Yes. Throw out all the computers... But seriously, if you can connect directly to the WAPs/router, see what the management interfaces can tell you about the TCP/IP settings, etc. Something may have reverted to a factory setting and you probably need to reconfigure it all again. Or you can thr

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Richard Quilhot
Can you ping all of the access points? Rick Q quilh...@gmail.com On Wed, Feb 8, 2012 at 2:44 PM, Ken Kixmoeller (ProFox) < foxh...@information-architecture.com> wrote: > Hey -- I'm baffled by hardware issues --- (so what's new?) -- anyone > willing to offer me clues? WAGs welcome, too, of cou

Re: [NF] Wireless network SYSFU

2012-02-08 Thread Mike Copeland
Are you using static or dynamic IPs? Mike Original Message Subject: [NF] Wireless network SYSFU From: Ken Kixmoeller (ProFox) To: profoxt...@leafe.com Date: 2/8/2012 1:44 PM Hey -- I'm baffled by hardware issues --- (so what's new?) -- anyone willing to offer me clues? WAGs w

[NF] Wireless network SYSFU

2012-02-08 Thread Ken Kixmoeller (ProFox)
Hey -- I'm baffled by hardware issues --- (so what's new?) -- anyone willing to offer me clues? WAGs welcome, too, of course. I have an old house with plaster walls through which wireless signals seem loathe to pass. As a result, I have 3 Wireless Access Points positioned strategically throughout.

Re: Anyone heard from Eqeus recently?

2012-02-08 Thread Sytze de Boer
Dave, I had a good run with Xfrx, but have switched over to Foxypreviewer I think it is far superior product On Thu, Feb 9, 2012 at 5:25 AM, Dave Crozier wrote: > I upgraded our XFRX version to the latest version two days ago and still > haven't heard anything from Martin at Eqeus regarding t

Re: [OT] Minnesota again leads the Nation

2012-02-08 Thread Michael Madigan
You can tell a lot about someone by the enemies he has.   Santorum is hated by the radical homosexuals, progressives and Democrats. .  They've even run a Google bomb to connect his name to some vile stuff.  If someone is universally hated by bad people, he must be doing something right.   ___

Re: [OT] Minnesota again leads the Nation

2012-02-08 Thread Michael Madigan
Rick Santorum is not a fanatic From: Ken Kixmoeller (ProFox) To: ProFox Email List Sent: Wednesday, February 8, 2012 12:10 PM Subject: [OT] Minnesota again leads the Nation ... in idiocy. But what can you expect from the state that elected Jesse Ventura and

Re: decimals in remote data

2012-02-08 Thread Rafael Copquin
Bingo!!! I added the server name and eliminated the regional parameter, and it worked! Funny thing but it can kill many hours of valuable (non-paid-by-the-client) time. BTW, the actual SA password is different. I just put a fake one, least some smart ass here snoops into my laptop while I am

Re: Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Stephen Russell
On Wed, Feb 8, 2012 at 11:35 AM, Dave Crozier wrote: > Peter, > Upgrade from 7 to 9 is virtually painless as long as you obey a few simple > guidelines which I did when I ran the upgrade. You have my phone number, just > ring me if you have any problems. > > XFRX is great for producing reports i

Re: Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Peter Cushing
Dave Crozier wrote: > Peter, > Upgrade from 7 to 9 is virtually painless as long as you obey a few simple > guidelines which I did when I ran the upgrade. You have my phone number, just > ring me if you have any problems. > > XFRX is great for producing reports in various formats, Stonefield is

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
We receive various formatted dates/times from all over. Times were noted as to their source and converted as needed to the local time of the app. The problem now is that the app is seeing multiple local times, which it never did before. This app existed the way it is long before I got here. Fre

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Peter Cushing
Fred Taylor wrote: > > All the clever ideas were immediately trashed soon after their suggestion. > Some of those were even my ideas! > > Fred > > > Could you not go back to using a TS connection even though the data is now in the cloud? That would buy you some time. Peter

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Stephen Russell
On Wed, Feb 8, 2012 at 11:45 AM, Fred Taylor wrote: > > Time zones existed back then, but the app and the users were only in one. >  Even when the user base expanded, the app still only ran in one place, and > the far flung users ran it using remote desktop.  They still had their > Outlook and ot

Re: Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Allen
As far as I can remember, VFP9 upgrade is the same as full. Just an install. Al -Original Message- From: Dave Crozier Sent: Wednesday, February 08, 2012 6:35 PM To: profoxt...@leafe.com Subject: RE: Buy VFP 9 plus alternative reporters. Peter, Upgrade from 7 to 9 is virtually painless as

Re: Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Vincent Teachout
Peter Cushing wrote: > Hi All, > > Been working happily with VFP7 for years and not found a reason to > upgrade. Now need to do a report with multiple detail bands so the new > reporter looks ideal. Just checking out versions of VFP9 and the > upgrade version is cheaper, but come across confl

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
On Wed, Feb 8, 2012 at 10:28 AM, Ed Leafe wrote: > On Feb 8, 2012, at 11:23 AM, Fred Taylor wrote: > > > Ed I agree 1000%. But these apps were originally developed 18 years ago. > > No reason to think of such things then. It's amazing they were even Y2K > > compliant! > > Time zones exi

[OT] Howe losing it

2012-02-08 Thread Pete Theisen
Hi Everybody, http://www.foxnews.com/sports/2012/02/02/gordie-howes-dementia-fight-personal-and-public/?intcmp=obnetwork Hell, I remember when he came to our cub scout meeting one night. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ __

RE: Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Dave Crozier
Peter, Upgrade from 7 to 9 is virtually painless as long as you obey a few simple guidelines which I did when I ran the upgrade. You have my phone number, just ring me if you have any problems. XFRX is great for producing reports in various formats, Stonefield is fantastic at framework manageme

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Ed Leafe
On Feb 8, 2012, at 11:23 AM, Fred Taylor wrote: > Ed I agree 1000%. But these apps were originally developed 18 years ago. > No reason to think of such things then. It's amazing they were even Y2K > compliant! Time zones existed 18 years ago! :) What I'm saying is that as you

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
On Wed, Feb 8, 2012 at 10:15 AM, Stephen Russell wrote: > On Wed, Feb 8, 2012 at 11:07 AM, Fred Taylor wrote: > > Would be nice to have such things as columns to handle this. These > > applications are way too old to put that much effort into it. > > > > They're all getting replaced soon (ha!) w

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
On Wed, Feb 8, 2012 at 10:17 AM, Ed Leafe wrote: > On Feb 8, 2012, at 10:42 AM, Fred Taylor wrote: > > > But getting the user's local time is not the problem, it's posting things > > according to the application's time that's the issue. Kind of hard to > > explain (hard enough keeping it straigh

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Stephen Russell
On Wed, Feb 8, 2012 at 11:17 AM, Ed Leafe wrote: > On Feb 8, 2012, at 10:42 AM, Fred Taylor wrote: > >> But getting the user's local time is not the problem, it's posting things >> according to the application's time that's the issue.  Kind of hard to >> explain (hard enough keeping it straight in

RE: decimals in remote data

2012-02-08 Thread Richard Kaye
I'll take a wild guess and say it has something do with that Regional parameter. If you drop that from your connection string, what happens? Does it break again? Nice sa password... ;) -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] O

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Ed Leafe
On Feb 8, 2012, at 10:42 AM, Fred Taylor wrote: > But getting the user's local time is not the problem, it's posting things > according to the application's time that's the issue. Kind of hard to > explain (hard enough keeping it straight in my head!) with all the > different app requirements, us

RE: Buy VFP 9 plus alternative reporters.

2012-02-08 Thread john harvey
VFP 9 is much better and you should be able to upgrade. John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Wednesday, February 08, 2012 11:15 AM To: ProFox List Subject: Buy VFP 9 plus alternative reporters. Hi All,

Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Peter Cushing
Hi All, Been working happily with VFP7 for years and not found a reason to upgrade. Now need to do a report with multiple detail bands so the new reporter looks ideal. Just checking out versions of VFP9 and the upgrade version is cheaper, but come across conflicting information about which v

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Stephen Russell
On Wed, Feb 8, 2012 at 11:07 AM, Fred Taylor wrote: > Would be nice to have such things as columns to handle this.  These > applications are way too old to put that much effort into it. > > They're all getting replaced soon (ha!) with a .NET web app (3+ years late > already). > ---

[OT] Minnesota again leads the Nation

2012-02-08 Thread Ken Kixmoeller (ProFox)
... in idiocy. But what can you expect from the state that elected Jesse Ventura and Al Franken? For Rick Sanctimonium to win in Minnesota shows just how broken the caucus system is. 1% or less of the eligible voters showed up, and the ones that did are the wrong ones: Fanatical Fundamentalists fr

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
Would be nice to have such things as columns to handle this. These applications are way too old to put that much effort into it. They're all getting replaced soon (ha!) with a .NET web app (3+ years late already). Fred On Wed, Feb 8, 2012 at 10:02 AM, Stephen Russell wrote: > On Wed, Feb 8, 2

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Stephen Russell
On Wed, Feb 8, 2012 at 10:42 AM, Fred Taylor wrote: > That will come in handy, thanks! > > But getting the user's local time is not the problem, it's posting things > according to the application's time that's the issue.  Kind of hard to > explain (hard enough keeping it straight in my head!) with

RE: decimals in remote data

2012-02-08 Thread john harvey
Try adding the specific server to your connectionstring and see if that doesn't work. Server=myserver; John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Wednesday, February 08, 2012 10:49 AM To: profox@leafe.com Subj

Re: decimals in remote data

2012-02-08 Thread Rafael Copquin
I tried using cast as you suggest but nothing worked. However, I had been using this statement to make the connection: cConnString = [DSN=aerolom;UID=sa;PWD=12345;APP=Sistema operativo Microsoft® Windows®;WSID=RAFANUEVA;DATABASE=aerosql;LANGUAGE=Español;Regional=Yes;] nHandle = sqlstringconnec

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread Fred Taylor
That will come in handy, thanks! But getting the user's local time is not the problem, it's posting things according to the application's time that's the issue. Kind of hard to explain (hard enough keeping it straight in my head!) with all the different app requirements, users from multiple locat

Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-08 Thread AndyHC
To get the users' local time zone for your mydatetime() pinch some code from: http://support.microsoft.com/kb/194576 AndyD 8-)# ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free versio

RE: [NF] a swarm of quadrotors

2012-02-08 Thread Jerry Foote
There are multiple videos on geek.com. It certainly real/ http://www.geek.com/articles/gadgets/watch-a-team-of-autonomous-quadrotors-b uild-a-tower-structure-20110117/ Jerry -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Michael Madigan Se

RE: decimals in remote data

2012-02-08 Thread Richard Kaye
I would use CAST in your SQL to make sure you get back the precision you want. You still may need a SET DECIMALS setting and maybe try SET FIXED OFF instead of ON. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Cop

decimals in remote data

2012-02-08 Thread Rafael Copquin
My last post was directly translated from the same one in Spanish sent to a local users group, and I missed translating the subject Here it goes again, please help me Rafael quote I have an app built in VFP9SP2 as a front end and SQLServer Express 2008 RS2 as backend. The connection is made by

Fwd: [GUFA] decimales en datos remotos

2012-02-08 Thread Rafael Copquin
I have an app built in VFP9SP2 as a front end and SQLServer Express 2008 RS2 as backend. The connection is made by ODBC and the network is a LAN (no internet involved) Using SQL PassThrough I bring records from a table with a numeric data field of size 14 with 4 decimals. If I run the sql sent

RE: [NF] a swarm of quadrotors

2012-02-08 Thread Kurt Wendt
A VERY Early version of the AniMusic stuff was just these Drums - and these balls bouncing onto them in the animnation. The newer stuff looks more Hi-Tech, and much more CG Colorful. But, the very early stuff was more simplistic renderings - but, also more realistic. So - it still makes me think wh

SPS Software JSON classes.

2012-02-08 Thread Alan Bourke
Hi - anyone using Craig Boyd's json.prg? I have a collection of objects (custom ones, created with DEFINE CLASS) that I'm stringifying. Which is all fine, however the json.prg class adds additional properties about the parent class and so on into the JSON, which adds overhead. Does anyone know if