Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Dan Baker
  Where is Dan Baker?
 Effort of the Poconos
 Pennsylvania - United States
 Dan Baker
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Simplify column style creation in cnt
Thread ID: 416471 Message ID: 416551 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 Category: Classes and Objects
Date: Tuesday, December 30, 2014 10:59:55 PM         
   


>
> Now, you can do this as well. Follow Mike's advice then later insert and enclose those with with... endwith, perform a search and replace to remove repeated objects within that enclosure such as in your case replace oControl. With .
>
> Then beautify.
>
> It is not only about WITH...ENDWITH. You'll encounter tracing problem as well on an SQL SELECT inside a TEXT....ENDTEXT. Or any codes within it as those are treated by vfp as text and not commands, function and the likes. It won't give you any error as well when there is supposed to be one and the solution is to temporarily remark TEXT and ENDTEXT. Or copy the sql select and paste it over command window and check from there.
>
> With those minor problems, I personally still prefer using the two when i need those. With for easier readability and grouping plus faster and the TEXT.. approach for some of my combobox having rowsourcetype of sql select.
>
> Just my own preference.
>
> https://vfpx.codeplex.com/releases/view/99045
> http://sandstorm36.blogspot.com

Good perspective, Jun.

Adding an AS clause at the end of the WITH statement sounds like a great way to document.

If you're selling software to a hospital or to Boeing, that's one story.  If it's a minesweeper game, that's
another story.

I'd rather not continue Mike's "skin the cat" analogy because 5 cats live at my house.  But when it comes to
"skinning the fox", there are always a few "right ways" to do it.  And those right ways depends on your
application's need, taking into account what Navy pilots call the pucker factor.

Dan B.


The Pucker Factor

There are a lot of ways you could measure an aviator's stress in an airplane. The "pucker factor" is the most usual and most graphic. 
Imagine you're eating a lemon. Your mouth puckers.  It's just like that, except that under life-threatening stress it's the
other end of the alimentary canal that puckers.  Given as a percentage: The aviator at his normally suave self is at near zero
percent pucker factor.  The pucker factor of landing on an aircraft carrier at night may reach 75%... "

ENTIRE THREAD

Simplify column style creation in cnt Posted by Dan Baker @ 12/30/2014 2:47:29 AM
RE: Simplify column style creation in cnt Posted by Jun Tangunan @ 12/30/2014 4:58:43 AM
RE: Simplify column style creation in cnt Posted by Dan Baker @ 12/30/2014 12:46:00 PM
RE: Simplify column style creation in cnt Posted by Mike Yearwood @ 12/30/2014 6:51:21 PM
RE: Simplify column style creation in cnt Posted by Dan Baker @ 12/30/2014 7:15:44 PM
RE: Simplify column style creation in cnt Posted by Mike Yearwood @ 12/30/2014 9:21:00 PM
RE: Simplify column style creation in cnt Posted by Jun Tangunan @ 12/30/2014 9:51:17 PM
RE: Simplify column style creation in cnt Posted by Dan Baker @ 12/30/2014 10:59:55 PM