Calvin Hsia's WebLog

thoughts from a professional developer

December, 2004

  • Calvin Hsia's WebLog

    Creating a VFP application as a service:

    • 29 Comments
    Sometimes it’s useful to make your application run as a service. A service can run without any user logged in, can automatically start upon reboot, and can survive user logoffs. It can also run as a different user with different access rights. Normally...
  • Calvin Hsia's WebLog

    Foxpro Performance tip: field name lookup for tables

    • 11 Comments
    When FoxPro opens or uses a table or cursor, internally we have to keep track of the field names used in that table. For example, this statement creates a table with 3 fields. CREATE TABLE foo ( lastname c( 10 ), firstname c( 10 ),address c( 20 )) When...
  • Calvin Hsia's WebLog

    Another customer problem: a product doesn't work with VFP

    • 3 Comments
    A customer reported that a product they have doesn’t work with Visual Foxpro . Time to put on the detective hat! In the command window, type o= CREATEOBJECT (“ABCProduct.Application”) After hitting the Enter key, the FoxPro process crashes. I tried from...
  • Calvin Hsia's WebLog

    Unbelievable performance gain by changing an Algorithm

    • 9 Comments
    Visual Foxpro added Object Oriented Programming in version 3 which was released about 10 years ago. Back then users weren’t expected to use very many objects. Nowadays, with more memory, users create thousands of objects, and things were slowing down...
  • Calvin Hsia's WebLog

    Sending Christmas cards: Creating mailng labels automatically

    • 14 Comments
    A family member sent out an emergency email plea for help: I bought labels: Avery 8160, which have very clear instructions about how to enter names and addresses manually, but nothing about how to use data from an Excel file to do so. Avery.com tells...
  • Calvin Hsia's WebLog

    Fox plays music

    • 10 Comments
    I received a customer question: I have searched the net and asked as many people as I could and could not get an answer, so I am bothering you. Do you know of a way to get VFP to play mp3 format tunes? There must be a way to use a media player driver...
  • Calvin Hsia's WebLog

    Intellisense: inspecting live objects

    • 7 Comments
    In this entry I talked about a performance improvement of FoxPro’s object handling. I showed an example of object based programming: oExcel= CREATEOBJECT ("excel.application") oExcel. A live instance of Excel is created. When you type the “.”, intellisense...
  • Calvin Hsia's WebLog

    Interactively experimenting with controls: the Slider

    • 1 Comments
    I have a simple form that can show an individual photograph, or at the push of a button, show an array of thumbnails. It is a simple client front end for my collection of about 18000 digital photos and home movies. The thumbnail view shows about 100 pictures...
  • Calvin Hsia's WebLog

    Using non-Automation compatible types

    • 3 Comments
    A customer asks: I’m using a third party COM server dll with my VFP8 application. One of its methods requires a structure as a parameter. It seems to me that unlike with dlls, where you can trick VFP into substituting a character string for a structure...
Page 1 of 1 (9 items)