Converting ADO Recordset to Cursor with CursorAdapter

CursorAdapter can easily convert ADO recordset into a VFP cursor. It does not support conversion in opposite direction.

Convert Unix time to datetime

Unix time

is the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)

Convert Excel serial number date to VFP date

topic: 

Excel stores dates as the number of days since 1900-01-00. The number 1 represents 1900-01-01 and so on. The time part, if present, is represented as decimal portion. There's a bug in implementation of that sequence. It assumes that there was 1900-02-29 but 1900 is not a leap year. As result the code below correctly convert dates starting with 1900-03-01 only.

For more info about Excel dates see How to use dates and times in Excel and Dates And Times In Excel

.

Convert Color to RGB

topic: 

This is sample code. Add error handling and adjust to your requirements as necessary.

Convert Color to HTML

This is sample code. Add error handling and adjust to your requirements as necessary.

Changing Windows default printer

Sometimes it's necessary to change Windows default printer from within VFP application. It can be done with Windows API, WSH or WMI.

Changing Command Window Font Programmatically

This code uses Editor functions from Foxtools.fll. See George Tasker's Extended Foxtools Help Download #9333 on UT for more info.

Basic Credit Card Validation

topic: 

Based on http://www.beachnet.com/~hstiles/cardtype.html

Pages