ASP.NET and AJAX tips

I found a couple articles regarding performance and scalability for ASP.NET, and ASP.NET with AJAX. I think these are a good read for anyone doing development with these tools.

Cross-MV development made easy…er

I just finished setting up the latest mv.NET v3.5.1.2 and used the Data Manager to create simultaneous connections to multiple MV environments. I dunno if other people get as much of a kick out of this as I do but just the ability to do this tickles me.

Application Virtualization Part 2

The first note I wrote on this topic was back in May of 2006. A recent forum inquiry asked about the merits of VMware to host MV DBMS software. I thought I’d take the opportunity to post a follow-up to the original posting with an update of how I’m using virtualization today.

Mine Field of Excel Development Tools – Part 6

In Part 5 of this unintended series I provided complete details on how to create an Excel Automation Add-in using the COM Shim Wizard from Microsoft. It works for development, not for deployment. I’ve found that in the deployment system some registry keys are missing.

Mine Field of Excel Development Tools – Part 5

It’s time to call it quits for now. Yup, I give up. I’ve killed an entire week on this, well over 100 hours. I have clients that need attention and this project isn’t earning its keep. The code is working great on development systems but I can’t get it to work properly on a non-development workstation. I’m am closing this […]

Mine Field of Excel Development Tools – Part 4

Andrew Whitechapel’s generous bloggings on Automation Add-ins and shims are chock full of helpful information. Unfortunately the blog entries are also over two years old and I’ve just found out the code details are no longer valid.

Mine Field of Excel Development Tools – Part 3

The task is to create an Excel User Defined Function with managed .NET code. It seems so far that the way to go is with shims which proxy COM requests from Excel and separate the managed code into its own application domain for security and stability. This short article summarizes how I’ve come to that conclusion.

Mine Field of Excel Development Tools – Part 2

I’m continuing my notes here for anyone else who needs to tread through this minefield. At the moment my code is working great on systems that have Visual Studio installed, but not on another test system without VS. Sigh. That means I can’t deploy this code yet. See the Summary in this article for the current status, and see the […]

Mine Field of Excel Development Tools – Part 1

If you’ve been reading my other blog entries, you know I’ve been working a lot with Excel lately. I worked intensely with this environment several years ago. I’ve found all of the Microsoft Office applications to be fun to work with at the object model level – OK, call me a geek. Unfortunately MS Office apps have always been far […]

NebulaXChange : Excel to MV and beyond

A long time ago there was a product called CrowFlight that retrieved data into Excel from MV. Some companies still have it and I occassionally get a call from someone looking to replace it. Well… I now have two ways of using Excel formulas to call into MV, and this functionality can be combined with NebulaXLite.

New Product and New Forum

We released a new product today, though it’s been on the website for about a month to start drumming up interest – and that it did. NebulaXLite allows MV BASIC to create "real" Excel workbooks – and it seems to work with OpenOffice and Google Doc Spreadsheets too! We also have a new forum to discuss our product and service […]

SQL with Excel

This is a response to an inquiry in the U2 tech forum about the need to use [Worksheet$] syntax in a SQL query, and the idea that an Excel worksheet is treated like a System Table. This isn’t really a U2 topic so I thought I’d tackle it here.

Don’t Migrate – Integrate

Faced with a migration from your current software package? Lost a client to Oracle, SAP, Quckbooks? Many MV shops lose the war because they aren’t invited to the battles. And sometimes even the people who win wind up losing. There is a better way.

Mixed Messages

Why do I suddenly feel like someone just asked me if this computer thing will really catch on, or if water is a good idea?

D3 C Functions – Part 1: Confusing docs?

A recent forum posting said the D3 Reference Manual is "confused" about which %functions are for Unix and which are for Windows. I have a lot of comments on this topic but with just a couple minor exceptions I disagree with the statement that the doc is really "confused" anymore.

What do we have in Common?

One of our colleagues asked a good question in a forum yesterday about when to use UnNamed Common vs Named Common in Pick BASIC programs. I thought this would be a good opportunity to post some detailed information to the MV category here in the blog so that everyone could see it.

Is it OK to Extend DesignBais?

It’s started – people are getting more comfortable with DesignBais, learning the strengths and how to deal with the weaknesses. When the first release of a new application UI is in production and developers look back to see what they can do better (and respond to the end-user enhancement requests), they’re starting to get creative, get more out of the […]