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
is the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)
Convert Excel serial number date to VFP date
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
| 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 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
Based on http://www.beachnet.com/~hstiles/cardtype.html