[NF] Hardware suppliers

2013-03-05 Thread Paul Newton
Hi all Do any UK-based members supply hardware? Thanks Paul Newton ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: bit field in mysql

2013-03-05 Thread Gérard Lochon
From: MANJIT JHA kalasoft...@yahoo.co.in i have a bit field in mysql table in which values are 0 or 1, but when i take data in cursor through sqlexec command in vfp9(sp2) it becomes T for all records regardless of 0/1 in mysql. Hello. What is exactly the content of the request used ?

A Form a Strange Date Problem

2013-03-05 Thread Kurt
I'm working on this other system of ours, where my boss complained of a problem. I fixed one problem - but, then another problem occurred - regarding an EMPTY() Test. So - there's this form - to Enter Criteria for a Report. Its got numerous date fields, each are in pairs (for a Range). So - I

Re: bit field in mysql

2013-03-05 Thread MB Software Solutions, LLC
On 3/2/2013 1:45 AM, MANJIT JHA wrote: dear sir/madam i have a bit field in mysql table in which values are 0 or 1, but when i take data in cursor through sqlexec command in vfp9(sp2) it becomes T for all records regardless of 0/1 in mysql. The ODBC driver interprets the bit field

Re: A Form a Strange Date Problem

2013-03-05 Thread Frank Cazabon
Could it be that the value of those fields are actually set to character? You could initialise each textbox with a value of ={} to ensure it's an empty date Frank. Frank Cazabon On 05/03/2013 11:38 AM, Kurt wrote: I'm working on this other system of ours, where my boss complained of a

RE: A Form a Strange Date Problem

2013-03-05 Thread John Weller
I think the empty date is {} - but I'm not certain. John Weller 01380 723235 07976 393631 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Sent: 05 March 2013 15:38 To: profoxt...@leafe.com Subject: A Form a Strange Date Problem I'm

RE: A Form a Strange Date Problem

2013-03-05 Thread Kurt
Thanks Frank - I shall give that a shot right now! -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, March 05, 2013 10:54 AM To: profoxt...@leafe.com Subject: Re: A Form a Strange Date Problem Could it be that the value

RE: A Form a Strange Date Problem

2013-03-05 Thread Graham Brown
I've never trusted empty! I always use len(trim(var))=0 or dDatectod(01/01/1900) . Have to watch those nulls as well if it is sql server. From: ProFox on behalf of Kurt Sent: Tue 05/03/2013 15:45 To: profox@leafe.com Subject: A Form a Strange Date Problem

RE: bit field in mysql

2013-03-05 Thread John Weller
But does he mean that they are all True whereas some should be False? John Weller 01380 723235 07976 393631 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: 05 March 2013 15:50 To: profoxt...@leafe.com Subject:

Re: A Form a Strange Date Problem

2013-03-05 Thread Peter Cushing
Looks like a character field to me. On your form click on the field and in the properties box put D You can also (as suggested by Frank) set the variable to {} This should ensure a date. The value below / / is NOT empty. Try it in your command window. HTH * Peter Cushing * IT

RE: A Form a Strange Date Problem

2013-03-05 Thread Kurt
Graham - I've made Friends w/EMPTY() - since I like that it can work for all cases - whether Char, Num or Date. Also - Frank Hit the Nail on the Head with his suggestion - that solved my problems - Just did an Init to the Text fields per his suggestion. Now the EMPTY() function works just fine!

RE: A Form a Strange Date Problem

2013-03-05 Thread Gene Wirchenko
At 08:23 2013-03-05, Kurt k...@isssusa.com wrote: Graham - I've made Friends w/EMPTY() - since I like that it can work for all cases - whether Char, Num or Date. Not all cases. empty() is one of my friends, too, but it had a bit of a snit fit recently. empty() does not work on

Ed Leafe, Please Read This

2013-03-05 Thread Gene Wirchenko
Dear Ed: I have just completed a somewhat better messagebox() -- AFAIAC -- based on Steven Black's msgsvc.prg. Mine has the advantage of not requiring a table. What are the rules for posting code? This particular code is 22K long. Sincerely, Gene Wirchenko

RE: A Form a Strange Date Problem

2013-03-05 Thread Kurt
Actually - I can well imagine it would NOT work on Objects - cause Objects are Truly an Animal of a Different Color! Basically, a much more complex data type. But, I am also curious - doesn't the VFP Help mention Objects - or maybe it does NOT mention Objects - and was never designed work with

Re: Ed Leafe, Please Read This

2013-03-05 Thread Ed Leafe
On Mar 5, 2013, at 11:21 AM, Gene Wirchenko ge...@telus.net wrote: I have just completed a somewhat better messagebox() -- AFAIAC -- based on Steven Black's msgsvc.prg. Mine has the advantage of not requiring a table. What are the rules for posting code? This particular code is

RE: Ed Leafe, Please Read This

2013-03-05 Thread Kurt
Gene - I thought that ANYONE Can upload Code stuff to ProFox - to the Downloads area - I thought it was simply a Form you fill out and upload your code. I think, then Ed receives it - and he reviews it - and decides whether to post it. AFAIK - although, I'm hope I'm not talking out my Buttocks on

Re: Ed Leafe, Please Read This

2013-03-05 Thread Ed Leafe
On Mar 5, 2013, at 11:27 AM, Kurt k...@isssusa.com wrote: Gene - I thought that ANYONE Can upload Code stuff to ProFox - to the Downloads area - I thought it was simply a Form you fill out and upload your code. I think, then Ed receives it - and he reviews it - and decides whether to post it.

RE: Ed Leafe, Please Read This

2013-03-05 Thread Kurt
Ed - U might be right - but, it looks to me like Gene just wants to upload it. Let's see what he says now... -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Tuesday, March 05, 2013 12:29 PM On Mar 5, 2013, at 11:27 AM, Kurt

RE: A Form a Strange Date Problem

2013-03-05 Thread Richard Kaye
As Kurt says, an object either exists or it does not so empty() is not appropriate. VARTYPE() is your friend for objects. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Sent: Tuesday, March 05, 2013 12:23 PM To: profoxt...@leafe.com

RE: A Form a Strange Date Problem

2013-03-05 Thread Kurt
Sounds like you have a LOT of Code-Like friend rk! :-) -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, March 05, 2013 12:43 PM As Kurt says, an object either exists or it does not so empty() is not appropriate. VARTYPE()

Re: bit field in mysql

2013-03-05 Thread Gérard Lochon
- Original Message - From: John Weller j...@johnweller.co.uk whereas some should be False? First respond to my previous reply. Without further information, we are able to discuss about the sex of angels using Foxpro as a new layer ... (and we've got background about thatt). :o))

RE: A Form a Strange Date Problem

2013-03-05 Thread Gene Wirchenko
At 09:42 2013-03-05, profox@leafe.com profox@leafe.com wrote: As Kurt says, an object either exists or it does not so empty() is not appropriate. VARTYPE() is your friend for objects. msgsvc.prg has a test for whether the first parameter is empty: IF EMPTY(lxPassed1) and simply

RE: Ed Leafe, Please Read This

2013-03-05 Thread Gene Wirchenko
At 09:35 2013-03-05, Kurt k...@isssusa.com wrote: Ed - U might be right - but, it looks to me like Gene just wants to upload it. Let's see what he says now... Upload. I have some other things to do first so it might be a week. I will post a notice here after I upload. [snip]

RE: Ed Leafe, Please Read This

2013-03-05 Thread Kurt
Hey Gene - as we are attempting to build a new system here - I may seriously look over your thing and use it! So - I shall keep my eye out for your posting... -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Tuesday, March

Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt
Hey folks, I'm hoping to get a little input on this topic - I know it's a rather general one - and probably one that HAS been discussed in the past. But, since I have been on the list for a few years now - I think it was QUITE a while ago that it was last discussed. We are working on a new

Re: Ed Leafe, Please Read This

2013-03-05 Thread Ed Leafe
On Mar 5, 2013, at 2:40 PM, Gene Wirchenko ge...@telus.net wrote: Upload. I have some other things to do first so it might be a week. I will post a notice here after I upload. Just FYI: I get an email on all uploads. They are held until I can check 'em out to make sure that they

RE: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt
Wow Dave - U F'ing ROCK! Compared to the Only other programmer here at my job - I already look like a Genius! Now I will look like a SUPER Genious! Thanks - I am going to try this out As Soon As I Possibly Can - and shall report my results back here... :-) -K- -Original Message- From:

RE: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt
Holy Crap Batman - That was SO Frickin' Easy to implement - it was like CHILDS Play!!! I showed it to my Boss - and he almost Stained his pants!!! :-) Thanks again Dave - I can't believe this existed and I didn't know about it! -K- -Original Message- From: ProfoxTech

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Ed Leafe
On Mar 5, 2013, at 4:08 PM, Kurt k...@isssusa.com wrote: Holy Crap Batman - That was SO Frickin' Easy to implement - it was like CHILDS Play!!! I showed it to my Boss - and he almost Stained his pants!!! Now that was dumb. You should have said to your boss Geez, this is gonna take me

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread MB Software Solutions, LLC
On 3/5/2013 4:31 PM, Dave Thayer wrote: On Tue, Mar 5, 2013 at 2:01 PM, Kurt k...@isssusa.com wrote: Now my boss gets on my case today. He claims that the system should have screens that are sizable. Like - if people are working on BIG Monitors - that the screens should be expandable to fill

RE: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt
DUDE - it does EVERYTHING - its like MAGIC! -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, March 05, 2013 5:16 PM To: profoxt...@leafe.com Subject: Re: Screen Res. Design Monitor Sizes... On

RE: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt
Ur Hysterical ED! But - yeah - I probably SHOULD have done that!!! -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Tuesday, March 05, 2013 5:12 PM To: profoxt...@leafe.com Subject: Re: Screen Res. Design Monitor Sizes... On Mar 5,

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Sytze de Boer
I've played with a lot of Sizers and have usually been somewhat disappointed. I wonder if you found something I've missed all this time On Wed, Mar 6, 2013 at 11:24 AM, Kurt k...@isssusa.com wrote: Ur Hysterical ED! But - yeah - I probably SHOULD have done that!!! -Original

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt @ VR-FX
If you haven't tried this one - you really MUST - it was Simple to implement - and it Truly worked like Magic! :-) -K- On 3/5/2013 5:31 PM, Sytze de Boer wrote: I've played with a lot of Sizers and have usually been somewhat disappointed. I wonder if you found something I've missed all this

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt @ VR-FX
Will do! -K- On 3/5/2013 5:36 PM, Dave Thayer wrote: On Tue, Mar 5, 2013 at 3:08 PM, Kurt k...@isssusa.com wrote: Holy Crap Batman - That was SO Frickin' Easy to implement - it was like CHILDS Play!!! I showed it to my Boss - and he almost Stained his pants!!! :-) Glad it worked out! Make

RE: Screen Res. Design Monitor Sizes...

2013-03-05 Thread jerry foote
I compiled the project and ran it and got error that MSOUTL32.OCX was missing. Do I need this?, Where can I find it. Thanks Jerry -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, March 05, 2013 6:56 PM To: profox@leafe.com Subject:

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt @ VR-FX
It was in the ZIP file! -K- On 3/5/2013 8:19 PM, jerry foote wrote: I compiled the project and ran it and got error that MSOUTL32.OCX was missing. Do I need this?, Where can I find it. Thanks Jerry -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Kurt @ VR-FX
No - Ted - the Tablet App was Completely different! -K- On 3/5/2013 7:55 PM, Ted Roche wrote: On Tue, Mar 5, 2013 at 4:01 PM, Kurt k...@isssusa.com wrote: But - I'd like the opinion of others here. Since I'm on a Wide screen monitor - that's 19 inch diagonal - and currently set to 1366x768 -

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread Ken Dibble
So - what do you all think? Design screen sizes at something like 1280x700??? And, what if some users at one of our client companies have smaller screens? They will Totally have their database system screens get chopped off - and I think that would SUCK! I still design everything to be full

Re: Screen Res. Design Monitor Sizes...

2013-03-05 Thread AndyHC
Like the man said, the corollary is: Any technology that is distinguishable from Magic isn't sufficiently advanced. On 06/03/2013 03:54, Kurt wrote: DUDE - it does EVERYTHING - its like MAGIC! snip ___ Post Messages to: ProFox@leafe.com