Calvin Hsia's WebLog

thoughts from a professional developer

April, 2006

  • Calvin Hsia's WebLog

    More DECLARE DLL performance discussion

    • 4 Comments
    In this post DECLARE DLL performance questions I asked whether using the WIN32API keyword or the particular DLL file name would be faster. It turns out that Win32API is much faster, and Martin Jindra, Timo, and Fabio Lunardon answered correctly that with...
  • Calvin Hsia's WebLog

    DECLARE DLL performance questions

    • 13 Comments
    I was writing a sample about DECLARE DLL to show some of its features which I implemented about 12 years ago, when I rediscovered an interesting performance issue. The purpose of DECLARE DLL is to allow the user to call functions in a DLL directly...
  • Calvin Hsia's WebLog

    Using Foxpro to query line lengths

    • 6 Comments
    I was reviewing some code changes, and I noticed some of the lines were quite different in length. I wrote some code to figure out why. I thought initially that I would just create a cursor with a field of length 250 and then use the APPEND FROM...
  • Calvin Hsia's WebLog

    SQL Server interpreter sample

    • 4 Comments
    I was writing some code to test Microsoft SQL Server: SQL Server 2005 Express Edition (which I believe you can download for free) It connects to SQL Express (It’s simple change to use SQL Server 2005), creates a database called Test, creates a table...
  • Calvin Hsia's WebLog

    Today's Quiz. How many times is a user function called?

    • 6 Comments
    Run the code below. How many times is the function FOO called? Why? The first SELECT is a single table query. The next is a 2 table self-join with no join condition. PUBLIC nCount nCount= 0 CREATE CURSOR test ( name c( 10 )) nRecs...
  • Calvin Hsia's WebLog

    Can you keep a server around after it's been released?

    • 2 Comments
    I received a question from a reader: I decided to extend my VPF9SP1 application to support OLE Automation like MS Office. I'd like to enable user (through code, i.e. VBA macro in Excel) to instantiate my app, create a new form, fill-in some data...
  • Calvin Hsia's WebLog

    Why should VFP allow large programs?

    • 17 Comments
    I received a question regarding this post: How do large programs work? Hi Calvin. I thought we're supposed to write granular, encapsulated programs. I have read that the highest quality code is also some of the smallest code. If that's true, then...
  • Calvin Hsia's WebLog

    Microsoft Sudoku article

    • 6 Comments
    Several months ago, I wrote The mechanics of Sudoku and Sudoku puzzles screen capture . As a result, Stephen Toub emailed me and asked if I’d like to beta test his Tablet PC version of Sudoku. He sent me several versions over the next few months to...
Page 1 of 1 (8 items)