Run your application forms on the web

I received a customer question:   I have looked all over the web and still searching, and found your blog. I have a very specific issue and I need to ask whether this is doable first of all and how to do it after.   First of all, I need to make a foxPro app…

8

Add an interactive map to your web page

It’s pretty cool to play with the maps at http://Local.Live.com   You can zoom in to various locations, add pushpins, save sets of pushpins as Collections. Aerial, Bird’s Eye and 3D view are fun too!   When you sign in, your collections are visible from any browser on any computer.   This is great when…

6

Another way to get data into a web page: using OleDB or ODBC

Here’s a way to get data into a web page to be viewed by a web browser.   The code first spits out some text into a variable, then writes the variable to a file in the c:\Inetpub\WWWRoot folder. If you have Internet Information Server installed (on WinXP Pro choose Control Panel- Add/remove programs->Add/Remove Windows…

1

Analyzing Blog hit statistics

It takes a lot of work to create the blog posts and code samples that I put in my blog, and I was curious about getting more detailed statistics about the posts.   I already aggregate some statistics for Microsoft Bloggers (see What is a Microsoft MVP? Calvin’s List updated for the new century), but…

2

Use a different kind of grid in your applications

My prior post (Create a .Net UserControl that calls a web service that acts as an ActiveX control to use in Excel, VB6, Foxpro) shows how to create a .Net control that you can use in VFP or VB6 that takes advantage of the .Net framework.   Here’s an example of how to use the…

3

Handling arbitrary strings in URLs: Escape, InternetCanonicalizeUrl, WinHttpCrackUrl and URI.EscapeUriString

Sometimes a web application might want to put arbitrary strings into a URL, and make it a valid URL. The VBScript and  JScript  escape and unescape functions do just that.   This sample shows how to use VBScript to escape and unescape a string. The escaped string looks like:   http%3A//a.com/default.htm%3Fthis%20is%20a%20test%20%21@%23%24%25%5E%26*%28%29   CLEAR ALL CLEAR…

3

Customizing the Blog Crawler for different formats

I’ve had several requests that require customizing the Blog Crawler.   The entire source code of the Blog Crawler is available, so it can be modified to crawl blogs other than http://blogs.msdn.com Currently, it saves the entire HTML retrieved from a blog’s URL. It converts relative links to absolute like so: From     href=”http://blogs.msdn.com/Themes/Blogs/hover/style/style.css” To        …

2

How does EventHandler work? IConnectionPoint!

The EventHandler function allows you to connect some code to an object’s event interface. For example, Word allows you to run code when the user changes the Selected text in a document. An ADODB Recordset will fire events, such as WillMove and MoveComplete when moving from record to record. The EventHandler function takes 2 objects…

10

The VB version of the Blog Crawler

This is the VB.Net 2005 version of the Blog Crawler. It’s based on the Foxpro version, but.it uses SQL Server Everywhere so you can deploy it on your mobile device! It crawls a blog and stores all entries into a SQL Server Everywhere table. This includes blog comments and Cascading Style Sheets. I had to…

19