Lately, my external editor of choice has been Notepad++. It’s flexible, highly configurable, and supports user-defined syntax coloring. Of course, it doesn’t ship with a syntax coloring file for VFP, so I came up with my own. After a while, I got tired of typing in commands as I got to them, and wrote a program to generate the whole thing.

Read the rest of this entry »

Let me count the ways.

Well, not exactly, but some Googling led me to these posts, which show how to put it together yourself using the Visual Studio Shell.

Which reminds me, Craig Boyd and Bo Durban are still working on VFPStudio. Wish I could get to SWFox for the presentation Craig is giving…

This one messed me up until I figured out that splitting on comma instead of comma-space gave me a leading space in the strings, which then sorted weirdly.

H:\>perl -e “print join qq/, /, sort {$a <=> $b } split /, /, qq/2, 3, 5, 10, 19, 20, 58, 64, 65, 330, 452, 721, 797, 798, 799, 978, 1036, 1037, 1045, 1061, 1128, 1129, 1232, 1290, 1471, 858, 895, 1289, 1248, 64, 1479, 1464, 59, 65, 58, 1465, 1466, 1326, 1290, 1326, 1615, 1679/”

2, 3, 5, 10, 19, 20, 58, 58, 59, 64, 64, 65, 65, 330, 452, 721, 797, 798, 799, 858, 895, 978, 1036, 1037, 1045, 1061, 1128, 1129, 1232, 1248, 1289, 1290, 1290, 1326, 1326, 1464, 1465, 1466, 1471, 1479, 1615, 1679

Brian Simser has a great step-by-step post explaining how to do branching in Subversion. Check it out!

Roy Osherove has created a LINQ custom provider to create regular expressions in a readable fashion.

            var query = from match in
               RegexQuery.Against("sdlfjsfl43r3490r98*(*Email@somewhere.com_dakj3j")
                        where match.Word.Repeat.AtLeast(1)
                            .Literal("@")
                            .Word.Repeat.AtLeast(1)
                            .Literal(".")
                            .Choice.Either(
                                 Pattern.With.Literal("com"),
                                 Pattern.With.Literal("net"))
                            .IsTrue()
                        select match;

*raises an eyebrow* You mean Oracle does hierarchical data natively? Neat.

SELECT groupid, parentid, groupname, LEVEL
		, CAST(SYS_CONNECT_BY_PATH(groupname, ':') as char(100)) testPath ;
	FROM ml.hiergrps ;
	START WITH groupname = 'Enterprise' ;
	CONNECT BY PRIOR groupid = parentid

I couldn’t remember how to get VFP editboxes to accept tabs as input instead of instruction to move to the next control, so I was coding something elaborate in the KeyPress event to handle it.

After all, remembering the AllowTabs property would be just too easy…

Andrew MacNeill has a good article over here about using the new “My” class, that shipped with Sedna, to store application configuration information.

Seeing Craig Boyd’s FLLs inspired me to finally figure out how to do them myself. I learned C in school, so I have a passing familiarity with it, though I’m very rusty. I’ll assume that if you’re reading this, you’re about at the same level.

Read the rest of this entry »