Re: [OT] an interesting picture

2012-02-01 Thread kamcginnis
http://www.facebook.com/photo.php?fbid=371674459516227&set=p.371674459516227&type=1&theater sry, I could not help passing this on. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: [OT] An inconvenient a55hole

2012-02-01 Thread Pete Theisen
Dan Covill wrote: > But that article is only about East Anglia. What's the weather like in > WEST Anglia? We need to be fair and balanced. Hi Dan, My god, you are right. If it is cool it is "just weather" What was I thinking? > Dan > > On 02/01/12 01:17, Pete Theisen wrote: >> Hi Everybody,

[NF] Dabo grabs the headlines!

2012-02-01 Thread Ed Leafe
OK, so this is from over a year ago, but someone just pointed it out to me: "DABO Software Makes Buildings More Energy-Efficient" http://www.nrcan.gc.ca/science/story/3465 ;-) -- Ed Leafe ___ Post Messages to: ProFox@leafe.com S

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 6:41 PM, Dan Covill wrote: > On 02/01/12 11:28, Frank Cazabon wrote: >> OK, cool. Of course you need the with (buffering = .T.) clause in your >> SQL if you use buffered data :) > > And that's EXACTLY why I don't do it in the form. Those considerations > belong in the data layer, not

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 6:37 PM, Dan Covill wrote: > On 02/01/12 11:12, MB Software Solutions, LLC wrote: >> No, I think the example you gave with updating the invoice total as >> items are added in the UI is fine there. In my form, I'd have a simple >> routine that calculated the total/sum and updated the te

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Dan Covill
On 02/01/12 11:28, Frank Cazabon wrote: > OK, cool. Of course you need the with (buffering = .T.) clause in your > SQL if you use buffered data :) And that's EXACTLY why I don't do it in the form. Those considerations belong in the data layer, not the UI. If I change from .DBF to something els

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Dan Covill
On 02/01/12 11:12, MB Software Solutions, LLC wrote: > No, I think the example you gave with updating the invoice total as > items are added in the UI is fine there. In my form, I'd have a simple > routine that calculated the total/sum and updated the textbox that > reflected that total: > > thisf

Re: [OT] good news if true

2012-02-01 Thread Michael Madigan
The Republicans are intent on destroying Obama in order to save the country.   He's done everything within his power to destroy America and with four more years he can put the final nail into America's Coffin - Original Message - From: geoff To: 'ProFox Email List' Cc: Sent: Wednesda

RE: [OT] good news if true

2012-02-01 Thread geoff
That's very insightful. I've also noticed that the Republicans seem intent on destroying Obama and if that destroys the economy in the process then that's ok. My political affiliations would normally run to being republican-like but Bush turned me right off by his incompetence. But the way the repu

Re: deleting a general field

2012-02-01 Thread Eurico Chagas Filho
Check my routine for the case i was working on; FUNCTION GetTexto LPARAMETERS nCode, cText *GetTexto( nCode, cText ) * LOCAL cTemp, lSave, nOldArea cTemp = [] lSave = .F. nOldArea = SELECT() IF !USED([Texts])   USE Texts IN 0 ORDER Codigo NODATA SHARED      CURSORSETPROP("Buffering",5,[Texts]) EN

Re: [OT] good news if true

2012-02-01 Thread Michael Madigan
Have you no sight?  - Original Message - From: lelandj To: ProFox Email List Cc: Sent: Wednesday, February 1, 2012 5:57 PM Subject: Re: [OT] good news if true On 02/01/2012 04:47 PM, Michael Madigan wrote: > They are one and the same Have you no shame? Regards, LelandJ > > - O

Re: [OT] good news if true

2012-02-01 Thread lelandj
On 02/01/2012 04:47 PM, Michael Madigan wrote: > They are one and the same Have you no shame? Regards, LelandJ > > - Original Message - > From: lelandj > To: ProFox Email List > Cc: > Sent: Wednesday, February 1, 2012 5:38 PM > Subject: Re: [OT] good news if true > > On 02/01/2012 04:22

Re: [OT] good news if true

2012-02-01 Thread Michael Madigan
They are one and the same - Original Message - From: lelandj To: ProFox Email List Cc: Sent: Wednesday, February 1, 2012 5:38 PM Subject: Re: [OT] good news if true On 02/01/2012 04:22 PM, Michael Madigan wrote: > Sasquatch Michelle Obama better get all her spending and vacations in b

Re: [OT] good news if true

2012-02-01 Thread lelandj
On 02/01/2012 04:22 PM, Michael Madigan wrote: > Sasquatch Michelle Obama better get all her spending and vacations in before > they take back her credit card. > > > - Original Message - > From: lelandj > To: ProFox Email List > Cc: > Sent: Wednesday, February 1, 2012 4:57 PM > Subject: R

Re: [OT] good news if true

2012-02-01 Thread Michael Madigan
Sasquatch Michelle Obama better get all her spending and vacations in before they take back her credit card.  - Original Message - From: lelandj To: ProFox Email List Cc: Sent: Wednesday, February 1, 2012 4:57 PM Subject: Re: [OT] good news if true On 02/01/2012 03:21 PM, Michael Mad

[OT] Global Warming kills 80 in Europe

2012-02-01 Thread Michael Madigan
http://news.yahoo.com/death-freeze-grips-europe-killing-80-175634464--abc-news.html ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/

RE: Exporting a memo field to an Excel spreadsheet

2012-02-01 Thread Richard Kaye
And you might want to take a look at this. http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, February 01,

Re: Exporting a memo field to an Excel spreadsheet

2012-02-01 Thread Fred Taylor
Hi Kurt, In regards to the speed issue of automation, I agree. One way around that is to use _VFP.DataToClip() and paste into the Excel activesheet, then "cleanup" the spreadsheet as needed to remove field header rows, etc. Memo fields don't come across via this method, just Memo shows in the

Re: [OT] good news if true

2012-02-01 Thread lelandj
On 02/01/2012 03:21 PM, Michael Madigan wrote: > Gallup is trash now. I wouldn't pay much attention to this poll. The 2012 election is coming on the heals of the Great Recession of 2007-2009. The greed of Wall Street, previous political administrations, the real estate markets, and financial

RE: Exporting a memo field to an Excel spreadsheet

2012-02-01 Thread Kurt Wendt
Hi John, I agree with Fred - that Automation is one option. Although, I think that in doing so (which I HAVE done before) - there are a number of downsides to doing so (which others in the group have mentioned some of them in the past): 1 - The learning curve - if you've never done it before. 2 -

RE: deleting a general field

2012-02-01 Thread Gary Jeurink
WHEN YOU RETRIEVE it, how do you know when you have all f it? -Original Message- From: Eurico Chagas Filho [mailto:e28cha...@yahoo.com.br] Sent: Wednesday, February 01, 2012 12:48 PM To: ProFox Email List Subject: Re: deleting a general field Yes and no. The table has two fields, code an

Re: [OT] good news if true

2012-02-01 Thread Michael Madigan
Gallup is trash now.    From: lelandj To: ProFox Email List Sent: Wednesday, February 1, 2012 4:14 PM Subject: Re: [OT] good news if true It's way to early to be publishing, who is going to "lose" the election.  LOL  Most polls focus on who is likely to win

Re: [OT] good news if true

2012-02-01 Thread lelandj
It's way to early to be publishing, who is going to "lose" the election. LOL Most polls focus on who is likely to win an election. This poll is obviously pure rubbish and based on President Obama's current approval ratings in the various states. What about the approval rating of Congress? W

Re: [OT] good news if true

2012-02-01 Thread lelandj
Sit tight, and we'll see. Regards, LelandJ On 02/01/2012 02:51 PM, Michael Madigan wrote: > Which means Obama will lose by even a bigger margin > > > > From: lelandj > To: ProFox Email List > Sent: Wednesday, February 1, 2012 3:51 PM > Subject: Re: [OT] good n

Re: [OT] good news if true

2012-02-01 Thread Michael Oke, II
Didn't even look did you? Shoes presidential approval rating and extrapolates his chances of reelection based on that. Sad commentary on the miserable job don by the current resident of 1600 Pennsylvania. Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their de

Re: [OT] good news if true

2012-02-01 Thread Michael Madigan
Which means Obama will lose by even a bigger margin From: lelandj To: ProFox Email List Sent: Wednesday, February 1, 2012 3:51 PM Subject: Re: [OT] good news if true They're publishing polls numbers already, and we don't even know the Republican nominee tha

Re: [OT] good news if true

2012-02-01 Thread lelandj
They're publishing polls numbers already, and we don't even know the Republican nominee that will be running against him yet. LOL Regards, LelandJ On 02/01/2012 02:12 PM, Michael Madigan wrote: > http://campaign2012.washingtonexaminer.com/blogs/beltway-confidential/gallup-state-numbers-predic

[OT] good news if true

2012-02-01 Thread Michael Madigan
http://campaign2012.washingtonexaminer.com/blogs/beltway-confidential/gallup-state-numbers-predict-huge-obama-loss/352881  --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 2:37 PM, Paul McNett wrote: > Keeping the UI code-minimal with regards to data is a good thing to strive > for. Agreed. That was the major headache iirc with classic ASP. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutio

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 2:28 PM, Frank Cazabon wrote: > OK, cool. Of course you need the with (buffering = .T.) clause in your > SQL if you use buffered data :) Yes! Good catch, Frank. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Paul McNett
On 2/1/12 11:12 AM, MB Software Solutions, LLC wrote: > On 2/1/2012 1:20 PM, Frank Cazabon wrote: >> yes, it does make development easier, but I still do find instances >> where I would use SQL in the UI for display purposes, but maybe I should >> be trying to avoid that more. >> > > No, I think th

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
OK, cool. Of course you need the with (buffering = .T.) clause in your SQL if you use buffered data :) Frank. Frank Cazabon On 01/02/2012 03:12 PM, MB Software Solutions, LLC wrote: > On 2/1/2012 1:20 PM, Frank Cazabon wrote: >> yes, it does make development easier, but I still do find insta

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 1:20 PM, Frank Cazabon wrote: > yes, it does make development easier, but I still do find instances > where I would use SQL in the UI for display purposes, but maybe I should > be trying to avoid that more. > No, I think the example you gave with updating the invoice total as items ar

Re: deleting a general field

2012-02-01 Thread Eurico Chagas Filho
Yes and no. The table has two fields, code and text( C 250), if code is an integer field u use multiple tables. But if code is a composite key, say table name and primary key, it could be just one table. E. So you require multiple tables to store memo data? > >Michael Oke, II >661-349-6221 >

Re: Exporting a memo field to an Excel spreadsheet

2012-02-01 Thread Fred Taylor
You can do it via automation, and populate the cells with the memo field value. Excel is limited to 32K characters in a cell, but even then, you may not see all of the characters in the cell, but they will display in the formula bar. Fred On Wed, Feb 1, 2012 at 11:16 AM, John J. Mihaljevic < j

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
yes, it does make development easier, but I still do find instances where I would use SQL in the UI for display purposes, but maybe I should be trying to avoid that more. Frank. Frank Cazabon On 01/02/2012 12:38 PM, MB Software Solutions, LLC wrote: > On 2/1/2012 5:49 AM, Frank Cazabon wrote

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
So would you call your bizobj method while the user was editing the invoice in order to update the invoice total as a new line item gets added? I've always thought of that as being a UI thing (as it's just for display so the user can see what the total is) rather than a BO thing. Although I w

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Dan Covill
On 02/01/12 02:49, Frank Cazabon wrote: > Ah, all my systems are n-tier too, but I still make use of sql commands > against the local cursors for various aspects of the ui, such as totaling > invoice details during editing and so on. > I do that as well, but the sql commands are in a prg. The met

Re: [OT] An inconvenient a55hole

2012-02-01 Thread Dan Covill
But that article is only about East Anglia. What's the weather like in WEST Anglia? We need to be fair and balanced. Dan On 02/01/12 01:17, Pete Theisen wrote: > Hi Everybody, > > A data update released by, whoops, the climate-gate crowd, quietly > contained the admission that they had been ly

Re: deleting a general field

2012-02-01 Thread Michael Oke, II
So you require multiple tables to store memo data? Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. On Feb 1, 2012, at 6:14 AM, Eurico Chagas Filho wrote: > That's the thing i created a system of .dbf files that store in 255 > charac

Re: [OT] An inconvenient a55hole

2012-02-01 Thread Michael Oke, II
So you are saying that climate changes in cycles? Amazing. Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. On Feb 1, 2012, at 1:17 AM, Pete Theisen wrote: > Hi Everybody, > > A data update released by, whoops, the climate-gate cr

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 5:49 AM, Frank Cazabon wrote: > Ah, all my systems are n-tier too, but I still make use of sql commands > against the local cursors for various aspects of the ui, such as totaling > invoice details during editing and so on. Oh we query against our local cursors too, Frank, I'm sure, b

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread MB Software Solutions, LLC
On 2/1/2012 4:08 AM, Alan Bourke wrote: > > > On Tue, Jan 31, 2012, at 09:03 PM, Frank Cazabon wrote: >> Dan, >> You don't use sql in your forms? Why not? >> > > Probably the classic tiered approach and the separation of the UI and > data layer. > > I tend to try to have minimal code of any kind in

Re: [OT] What Is It About Mormons?

2012-02-01 Thread lelandj
After Barack Obama won the Presidency in 2008, the big boy changed the rules of the game using legal channels to put he odds back in their favor, (eg Citizen United case). It's like a seven card stud poker game, where the dealer calls deuces wild after looking at his hold cards. LOL Anyway,

Re: deleting a general field

2012-02-01 Thread Eurico Chagas Filho
That's the thing i created a system of .dbf files that store in 255 characters fields all the text. It's like a chain. I got some routines to save and to restore, the rest is the same as if u had a memo. E. Where do you put things like biographies or recipes... descriptions etc... > >-Orig

ProFox List Statistics for January 2012

2012-02-01 Thread List Administrator Account
== ProFox List Statistics January 2012 == Subscriber Count at End of Month: ProFox: 254 ProFoxTech: 155 == Total Posts: 85

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Frank Cazabon
Ah, all my systems are n-tier too, but I still make use of sql commands against the local cursors for various aspects of the ui, such as totaling invoice details during editing and so on. I'm also a relative newbie here on profox and do not recall that discussion. On 1 Feb 2012 01:52, "Dan Covill

[OT] An inconvenient a55hole

2012-02-01 Thread Pete Theisen
Hi Everybody, A data update released by, whoops, the climate-gate crowd, quietly contained the admission that they had been lying after all for the last 15 years. "Based on readings from more than 30,000 measuring stations, the data was issued last week without fanfare by the Met Office and th

Re: Using VFP 9 to modify a VFP 7 system

2012-02-01 Thread Alan Bourke
On Tue, Jan 31, 2012, at 09:03 PM, Frank Cazabon wrote: > Dan, > You don't use sql in your forms? Why not? > Probably the classic tiered approach and the separation of the UI and data layer. I tend to try to have minimal code of any kind in form classes, instead just calls to programmatic clas